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

Define db2 and its databases?

620

What are host variables in db2?

626

What language is db2 written in?

595

How do you pull up a query which was previously saved in qmf?

674

What are the bind parameters ibm db2?

624




How will you return the number of records in table?

518

What is the connection string to connect to the DB2 Database ?

614

How to find the number of rows in a db2 table?

644

Give the name of some fields form sqlca.

614

How can you do the explain of a dynamic sql statement?

637

How to compare data between two tables in db2?

660

How does coalesce work?

586

How to resolve deadlock issue

17978

Where can you declare a cursor in a cobol-db2 program?

604

What happens in bind step in a db2 program?

569