View previous topic :: View next topic
|
Author |
Message |
rajesh_m
New User
Joined: 15 Apr 2008 Posts: 39 Location: India
|
|
|
|
How to check the copy pending status of a table. Is there any status field kind of thing to check the status. |
|
Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
rajesh_m wrote: |
How to check the copy pending status of a table. Is there any status field kind of thing to check the status. |
-DISPLAY DATABASE(dddd) SPACENAM(tttt)
If u display it will show the status of the space whether in R/RW mode. |
|
Back to top |
|
|
rajesh_m
New User
Joined: 15 Apr 2008 Posts: 39 Location: India
|
|
|
|
I want to know it from a sql query is it possible? |
|
Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
rajesh_m wrote: |
I want to know it from a sql query is it possible? |
may be but i am not sure of that some one has to throw lite on this. |
|
Back to top |
|
|
Ajesh
New User
Joined: 03 Apr 2008 Posts: 6 Location: Chennai
|
|
|
|
Rajesh,
When u try to access a table which is in copy pending status,the SQL query will return you an SQL code -904.This way you can identify it.
Hope this solves your problem. |
|
Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
Ajesh wrote: |
Rajesh,
When u try to access a table which is in copy pending status,the SQL query will return you an SQL code -904.This way you can identify it.
Hope this solves your problem. |
The copy pending status will appear when image copies job fails while copying the data to Tape or DASD. So the Tablespace status will be copy pending status and the table will be an read only table with no updates. |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
rajesh_m wrote: |
I want to know it from a sql query is it possible? |
You need to have a DB2 command processor for that! |
|
Back to top |
|
|
|