Hi, You can do same by following tric. STOP database and start it again

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

Question Posted / kiran bhamare

5 Answers
23006 Views
Xansa, I also Faced
E-Mail Answers

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 query_cache_limit?

977

What is nvl in db2?

1099

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

1120

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

1069

What is db2 bind process?

1244

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

How many types of page locks can be held in db2?

1044

What does a deadlock mean in DB2?

1169

How to find the number of rows in db2 tables?

1073

Which isolation level provides maximum concurrency?

1155

What is null value in db2?

1029

What is null in db2?

1029

How to compare data between two tables in db2?

1088

How to connect to db2 database from windows command line?

1066

what is a corelated subquerry?

1122