what needs to be done if a table is in copy pending / check
pending status?
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
Which component is responsible for db2 startup and shutdown?
What is declare cursor?
define clustering index.
What is schema in db2?
What is null indicator in db2?
What do you mean by commit and rollback?
How connect db2 database to datastage?
Describe major components of db2?
What db2 400?
Highlight all the advantages that are attached to a package.
How to resolve deadlock issue
What language is db2 written in?
Discuss about db2 bind?
How do I delete a table in db2?
What is null indicator in cobol db2?