Can we unload data from a DB2 table which is in STOP status



IBM's flagship relational database management system

Can we unload data from a DB2 table which is in STOP status

Postby lakshmi reddi » Fri Jan 25, 2013 8:43 pm

Hi All,

I wanted to test the 'RESTART' option of BMC unload job.For that I wanted to abend the job during execution and restart the job with RESTART parameter.So I forced the DB to STOP status during execution.But the UNLOAD job didn't abend.I submitted one more job against the table present in STOP status but the job went fine and unloaded the records.

Can you please let me know if we can UNLOAD from a table present in STOP status
lakshmi reddi
 
Posts: 1
Joined: Fri Jan 25, 2013 8:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Can we unload data from a DB2 table which is in STOP sta

Postby NicC » Sat Jan 26, 2013 5:24 am

Well, according to what you have written you have just done it so you have answered your own question.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post