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 db2 stogroup?

899

Can there be more than one cursor open for any program?

919

What is the syntax for seeing the columns and data types of a table in the db2 database?

822

What is bufferpool in db2?

816

How do I add a column to an existing table in db2?

790

Define data page.

832

What's The Error Code For Unique Index Voilation?

889

What is package in db2 mainframe?

735

How many databases can be created inside an instance in db2 ?

822

Define sqlca.

856

What is an instance in db2?

779

What is copy pending and check pending in db2?

758

Differentiate between cs and rr isolation levels? Where do you specify them?

837

What is scrollable cursor in db2?

810

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1806