How to see the status of the table?

Showing Answers 1 - 4 of 4 Answers

saravanan

  • Jul 31st, 2005
 

code file-status in data division

  Was this answer useful?  Yes

suresh

  • Mar 13th, 2006
 

what is the command for that

  Was this answer useful?  Yes

Saleem Kidwai

  • May 23rd, 2006
 

Use DB2I command. Option 7.
TO CHECK STATUS OF DATABASE (IT IS READ or READ/WRITE ETC)
-DIS DB(*) SPACE(*)

For eg,to check whether TABLESPACE PXXXXXXX.PZZZZZZZ IS IN CHECK PENDING, 
GIVING FOLLOWING :
-DIS DB(PXXXXXXX) SPACE(PZZZZZZZ)       

  Was this answer useful?  Yes

amit

  • May 29th, 2006
 

also QUERY TABLE command will tell  you if load is complete or not

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions