Pierre, Doug and Monty6,
Thanks for your replies.
I may not need very detail information here and I have used little the inspect command . As for the tablespace status I actually also have the following sql running at the same time but it did not catch the tablestate load pending:
select substr (tablespace_name, 1, 18) as tbs, tablespace_state from table (SNAPSHOT_TBS_CFG ('MEDDATA', -1)) as TABLESPACE_CFG where tablespace_state <> 0
TBS TABLESPACE_STATE
------------------ --------------------
0 record(s) selected.
On UDB v8.2, the load pending is at table level. The question remains: what is a good way to check them out?
On the other hand, the check pending can be caught by the previous sql -- select substr(tabname, 1, 18) as tbl, status from syscat.tables where status <> 'N'
Thanks.
Zhong
FCSO DBA
x10208
-----Original Message-----
From: Pierre Saint-Jacques [mailto:db2udbdba-ezmlmshield-x95197815.[Email address protected]
Sent: Monday, April 30, 2007 1:09 PM
To: LazyDBA Discussion
Subject: RE: Best Way to Find Abnormal Table Status
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
---------------------------------------------------------------------
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
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