Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    27

    Unanswered: when load pending in UDB 7.2, any better way to find out which table to load teminate

    when load pending in UDB 7.2, is there any better way to find out which table to be load terminate...instead of check the log...

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    First connect to the database and then issue the List Tablespace command to show the state of the Tablespace. Not the same as the table, but it may help you.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: when load pending in UDB 7.2, any better way to find out which table to load teminate

    See if

    db2 list history load all for <dbname>

    gives any useful information ...

    Cheers

    Sathyaram

    Originally posted by r390gt1
    when load pending in UDB 7.2, is there any better way to find out which table to be load terminate...instead of check the log...

  4. #4
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    Another way to do this is:

    db2 list tablespaces show detail | grep -iE "name|state"

    This will list the tablespace that is causing the problem. In addition to this, you will see the object ID and the tablespace ID.

    Then look for which table is in the failed state.


    select tabname, tableid, tbspaceid from syscat.tables where tableid=<objectID> and tbspaceid=<tablespaceID>

Posting Permissions

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