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
22791 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

Why db2 is called db2?

981

What language is db2 written in?

986

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2287

What is concurrency?

1165

What is a dbrm in db2?

976

What kind of database is db2?

987

How can you classify the locks in db2?

1041

What is null in db2?

959

What is iseries database?

1006

List out the buffer pools in db2

1028

What types of tables are there in the db2 database?

1014

List out the data types available.

1101

What is the syntax for FETCH in DB2 ?

1152

what is the sqlcode -501

12950

What is the physical storage length of timestamp data type?

1035