SQL Query to list table(s) in LOAD PENDING

[Mr. DOS]

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!

[Lennart]

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

[Mr. DOS]

On Jun 4, 9:57 pm, Lennart <erik.lennart.j [e-mail] mwrote:

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

[Lennart]

Mr. DOS wrote:

On Jun 4, 9:57 pm, Lennart <erik.lennart.j [e-mail] mwrote:

>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.ADMIN TABINFO
where load_status = 'PENDING'"
Sorry for the confusion I might have caused
/Lennart

[Mr. DOS]

Thank you for your help. We are on v8 for most environments until
about 4Q 2007.