Pending status of table(s) 
Author Message
 Pending status of table(s)
Hi,
 How to find out total number of table having pending status. can i
find out by any query or any other way.

Ajay

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 05 Mar 2003 03:00:00 GMT
 Pending status of table(s)

If you mean the STATUS of a table, then:
Db2 select tabname,status,const_checked from syscat.tables where definer
is not = 'SYSIBM'

If you mean the status of the table space, then:
db2 select tabname,tableid,tbspaceid from syscat.tables where definer is
not = 'SYSIBM'
then
db2 list tablespaces show detail
and correlate tablespace id with tbspaceid

HTH,  Pierre.


Quote:
> Hi,
>  How to find out total number of table having pending status. can i
> find out by any query or any other way.

> Ajay

> Sent via Deja.com http://www.deja.com/
> Before you buy.

  sescons.vcf
< 1K Download


Thu, 06 Mar 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Preventing copy pending status on a table after load

2. SQL Cluster node2 failing, online pending status

3. Rollback Segment Status 'PENDING OFFLINE'

4. Backup pending status on TS / db2stset

5. Tablespace stuck in a load pending status.

6. Terminate backup pending state of table spaces

7. dbaccess fail status to Bourne shell exit status

8. Status 2's that are not really status 2's

9. Write DTS job status (successful or failed) to Table or File

10. How do you read the status column of the sysfiles table

11. Status Table for Cursor

12. Sysindex table status = 10485856


 
Powered by phpBB® Forum Software