- How can i check does a table in loading stage or normal stage?
- of course, table cannot be queried during loading stage, so we can easily to know by just quering it. But what i mean is any method that we can check it from data dictionary, not query tables one by one.

Thanks

Hi,

there is a status attribute in SYSCAT.TABLES you probably can make use of, albeit I am not sure if it will reflect load in some way.

The other option would be to use the LOAD QUERY command. This I believe has to be executed at the very place in the filesystem where the load is running.

Last, there should be an entry in db2diag.log after load started.

Johann