Hello,

Is there a way to get a list of tables being in the "Load Pending" state?

syscat.table's status and access_mode columns don't seem to be useful for
this (I just compared the values of these for a table in normal state and
in Load Pending state).

--
Troels

On 2011-01-29 08:47, Troels Arvin wrote:
I think you can use SYSIBMADM.ADMINTABINFO.load_status for this, if I
remember correctly the value is 'PENDING'


/Lennart

On Jan 29, 9:34*am, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:
That's correct, following query will show tables in "Load Pending"
state:
db2 "select tabschema, tabname from SYSIBMADM.ADMINTABINFO where
load_status = 'PENDING'"

--
Jeroen

Hello,

Lennart Jonsson wrote:
Thanks (and thanks to "The Boss", as well).

However, queries in SYSIBMADM.ADMINTABINFO are surprisingly slow.
Like in http://groups.google.com/group/comp.databases.ibm-db2/
browse_thread/thread/1f19045b8def6812/61edbc947b7e1ad1 I suspect that
queries in SYSIBMADM.ADMINTABINFO triggers I/O in all involved tables.

I wish IBM would re-consider table availability instrumentation aiming at
making it more useful, i.e. realistic to use for regular monitoring.

--
Troels

On Jan 30, 10:49*pm, Troels Arvin <tro... (AT) arvin (DOT) dk> wrote:
(You probably already considered this, but just to be sure)
If you suspect a specific table (or a limited number of them) you
could use LOAD QUERY like explained here:
http://publib.boulder.ibm.com/infoce.../r0002000.html

Useful for adhoc situations, not so for regular monitoring of more
than a few tables.

--
Jeroen