By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

SQL Query to list table(s) in LOAD PENDING

P: n/a
IBM DB2 UDB
Is there a SQl query I can send from the web server that will return a
list of tables currently in the LOAD PENDING state?

LOAD QUERY is not quite waht I'm looking for.

Thanks!

Jun 4 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Mr. DOS wrote:
IBM DB2 UDB
Is there a SQl query I can send from the web server that will return a
list of tables currently in the LOAD PENDING state?
Not sure whether there really is a load pending state. If it is check
pending you are looking for:

select tabname from syscat.tables where status = 'C'

[lelle@53dbd181 lelle]$ db2 "select tabname from syscat.tables where
status = 'C'"

TABNAME

--------------------------------------------------------------------------------------------------------------------------------

0 record(s) selected.
[lelle@53dbd181 lelle]$ db2 load from /dev/null of ixf messages /tmp/A
replace into A

Number of rows read = 0
Number of rows skipped = 0
Number of rows loaded = 0
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 0
[lelle@53dbd181 lelle]$ db2 "select tabname from syscat.tables where
status = 'C'"

TABNAME

--------------------------------------------------------------------------------------------------------------------------------
A
1 record(s) selected.

[lelle@53dbd181 lelle]$ db2 "set integrity for A immediate checked"
DB20000I The SQL command completed successfully.
[lelle@53dbd181 lelle]$ db2 "select tabname from syscat.tables where
status = 'C'"

TABNAME

--------------------------------------------------------------------------------------------------------------------------------

0 record(s) selected.
/Lennart
Jun 5 '07 #2

P: n/a
On Jun 4, 9:57 pm, Lennart <erik.lennart.jons...@gmail.comwrote:
Not sure whether there really is a load pending state. If it is check
pending you are looking for:
Thanks for the response, but if anyone aout there is familiar please
let me know.

http://www.ibm.com/developerworks/db...nyk/index.html

Jun 5 '07 #3

P: n/a
Mr. DOS wrote:
On Jun 4, 9:57 pm, Lennart <erik.lennart.jons...@gmail.comwrote:
>Not sure whether there really is a load pending state. If it is check
pending you are looking for:

Thanks for the response, but if anyone aout there is familiar please
let me know.

http://www.ibm.com/developerworks/db...nyk/index.html
Ah, I see. Thanks for the link. If you are on V9 I think you can use a
stmt like:

select tabschema, tabname from SYSIBMADM.ADMINTABINFO
where load_status = 'PENDING'"
Sorry for the confusion I might have caused
/Lennart
Jun 5 '07 #4

P: n/a
Thank you for your help. We are on v8 for most environments until
about 4Q 2007.

Jun 6 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.