Results 1 to 2 of 2

Thread: Tables status

  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Unanswered: Tables status

    - 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

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: Tables status

    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

    Originally posted by miemcos
    - 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •