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 table space in db2?

570

is it compulsory commitment control in journal?

2000

What is the use of predicate?

573

Explain about rct in db2?

621

How can record locking be achieved in those DB2 versions which do not support it?

607




What is nvl in db2?

613

How to connect to db2 database from windows command line?

553

How do I delete a table in database?

585

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3778

What is copy pending and check pending in db2?

565

What is bind and rebind in db2?

634

How do you concatenate the firstname and lastname from emp table to give a complete name?

591

What is the physical storage length of timestamp data type?

634

Mention the definition of cobol in varchar field.

675

How can the duplicate values be eliminated from db2 select?

613