Guru,

What is the best way to check all the abnormal status for all the tables
so I can act proactively?

I have the follow query run periodically and sent mail to me when it
find something:

$ db2 "select substr(tabname, 1, 18) as tbl, status from syscat.tables
where status <> 'N'"

TBL STATUS
------------------ ------

0 record(s) selected.

However, this morning I found out it does not catch this one:

$ db2 load query table ac_2007.header

SQL3109N The utility is beginning to load data from file
...
Tablestate:
Load Pending


Thanks.

Zhong
FCSO DBA
x10208



First Coast Service Options, Inc., and its affiliates are not responsible for errors or omissions in the transmission of this e-mail message. Any personal comments made in this e-mail do not reflect the views of First Coast Service Options, Inc., or its affiliates. The information contained in this document may be confidential and is intended solely for the use of the individual or entity to whom it is addressed. This document may also contain material that is privileged or protected from disclosure under applicable law. If you are not the intended recipient or the individual responsible for delivery to the intended recipient, please (1) be advised that any use, dissemination, forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2) notify sender immediately by telephone and destroy the document. Thank you.


DB2 & UDB email list listserv db2-l LazyDBA home page