If you need more detail, you can use the INSPECT command. I t provides its
output in a report file and can be quite detailed. It is an interactive
command and the db does not have to be deactivated.
The load query table output you show gives you the status of the tablespace.
I'm not totally sure but I think that the command would only show the table
status for check pending. Load pending is a tablespace status I believe.
Regards, Pierre.



-----Message d'origine-----
De : Shi Zhong
[mailto:db2udbdba-ezmlmshield-x34077169.[Email address protected]
Envoyé : 30 avril, 2007 09:44
À : LazyDBA Discussion
Objet : Best Way to Find Abnormal Table Status

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.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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