Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

what needs to be done if a table is in copy pending / check
pending status?

Question Posted / kiran bhamare

Answer Posted / kiran bhamare

Hi,

You can do same by following tric.
STOP database and start it again using DB2 commands.
1)-DIS DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to dsisplay status of DB
2)-STOP DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to stop database.
3)-START DATABASE (DATABASENAME) SPACE (TABLESPACENAME) ACC
(FORCE)
to start database.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum length of sqlca?

1174

What is difference between rollback and commit?

917

What is null in db2?

782

What kind of database is db2?

811

What is nvl in db2?

847

When do you specify the isolation level?

815

What is with ur in db2?

1059

i want to maintain uniqueness on pdf without make lf??????????

1932

What are the various isolation levels possible?

889

What is runstats and reorg in db2?

1040

How to check table size in db2 sap?

805

What is the role of the data page in the db2 database?

802

What are concurrency issues?

836

Explain the benefits you can get from mainframe connect?

757

How to execute stored procedure in db2 command editor?

781