Results 1 to 14 of 14
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: Failed to lock table and fix TCB

    Getting these errors every 15 minutes like clockwork (even with no activity against the database) can anyone shed any light?

    This is DB2 LUW on Windows V 9.7

    Code:
    2013-07-09-20.15.14.356000-240 I67462266H479      LEVEL: Warning
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
    DATA #1 : <preformatted>
    Starting LOAD operation (S) (3) (I).
    
    2013-07-09-20.15.14.387000-240 I67462747H583      LEVEL: Error
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 148 bytes
    LOADID: 1804.2013-07-09-20.15.14.356000.0 (7;535)
    Failed to lock table and fix TCB , -2147221458, 00000000, Detected in file:sqluTarget.C, Line:2758
    
    2013-07-09-20.15.14.387000-240 I67463332H485      LEVEL: Severe
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadStart, probe:2716
    MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
    
    2013-07-09-20.15.14.387000-240 I67463819H459      LEVEL: Severe
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3622
    MESSAGE : Load Error: Error loading table.
    
    2013-07-09-20.15.14.387000-240 I67464280H584      LEVEL: Error
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 149 bytes
    LOADID: 1804.2013-07-09-20.15.14.356000.0 (7;535)
    Error acquiring partition resources. , -2147221458, 00000000, Detected in file:sqluvtld.C, Line:965
    
    2013-07-09-20.15.14.387000-240 I67464866H462      LEVEL: Warning
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:100
    MESSAGE : SQLEU_FLAG1_FORCE_RBK is set, doing rollback
    
    2013-07-09-20.15.14.387000-240 I67465330H552      LEVEL: Error
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 117 bytes
    LOADID: 1804.2013-07-09-20.15.14.356000.0 (7;535)
    sqluv_rollback , 0, 00000002, Detected in file:sqluvutl.C, Line:938
    
    2013-07-09-20.15.14.387000-240 I67465884H481      LEVEL: Severe
    PID     : 4292                 TID  : 1804        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-5846               APPID: *LOCAL.DB2.130710001721
    AUTHID  : DB2
    EDUID   : 1804                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, probe:961
    MESSAGE : Load Error: Error acquiring partition resources

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Read result of:
    db2diag -rc -2147221458

    then check if any tables in the target database are in check-pening condition or in any state that frustrates load.

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    Thanks for the reply. since these errors and warnings are happening with such frequency (every 15 minutes) regarless or whether or not there are any 'loads' happening - Will check the status of all tables.
    Last edited by itsonlyme44; 09-11-13 at 07:34.

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    You can query syscat.tables using both the TYPE and STATUS columns as predicates...
    Read the docs on-line
    SYSCAT.TABLES catalog view - IBM DB2 9.7 for Linux, UNIX, and Windows

    Also depends on your idea of health, other tools are available, but try simplest query first to ensure all tables are in normal state.

  5. #5
    Join Date
    Dec 2007
    Posts
    288
    Thank you!

  6. #6
    Join Date
    Dec 2007
    Posts
    288
    a query against syscat.tables showed all tables in a normal state. I checked the health of the Tablesspaces and they are also normal as well.

    Any other suggestions? the errors continue to scroll..

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by itsonlyme44 View Post
    a query against syscat.tables showed all tables in a normal state. I checked the health of the Tablesspaces and they are also normal as well.

    Any other suggestions? the errors continue to scroll..
    You need to contact IBM software support.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You're looking at the messages from July 9th? From the db2diag.log messages you pasted here, it's clear that the table (7;535) was in check pending at the time LOAD started. Do you still see the appid (for the messages that are repeated every 15min) reported in the db2diag.log in the list applications output?

  9. #9
    Join Date
    Dec 2007
    Posts
    288
    When I perform a LIST ACTIVITIES - there is no activity against the DB

    here is what is still happening in the log

    When I perform a LIST ACTIVITIES - there is no activity against the DB

    here is what is still happening in the log

    Code:
    2013-09-13-17.45.10.231000-240 I23392345H479      LEVEL: Warning
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:839
    DATA #1 : <preformatted>
    Starting LOAD operation (S) (3) (I).
    
    2013-09-13-17.45.10.247000-240 I23392826H583      LEVEL: Error
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 148 bytes
    LOADID: 8044.2013-09-13-17.45.10.231001.0 (7;535)
    Failed to lock table and fix TCB , -2147221458, 00000000, Detected in file:sqluTarget.C, Line:2758
    
    2013-09-13-17.45.10.247000-240 I23393411H485      LEVEL: Severe
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadStart, probe:2716
    MESSAGE : Load Error: Attempt to lock table/fix tcb unsuccessful
    
    2013-09-13-17.45.10.247000-240 I23393898H459      LEVEL: Severe
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqluLoadPartition, probe:3622
    MESSAGE : Load Error: Error loading table.
    
    2013-09-13-17.45.10.247000-240 I23394359H584      LEVEL: Error
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 149 bytes
    LOADID: 8044.2013-09-13-17.45.10.231001.0 (7;535)
    Error acquiring partition resources. , -2147221458, 00000000, Detected in file:sqluvtld.C, Line:965
    
    2013-09-13-17.45.10.247000-240 I23394945H462      LEVEL: Warning
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrrbck, probe:100
    MESSAGE : SQLEU_FLAG1_FORCE_RBK is set, doing rollback
    
    2013-09-13-17.45.10.247000-240 I23395409H552      LEVEL: Error
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    DATA #1 : String, 117 bytes
    LOADID: 8044.2013-09-13-17.45.10.231001.0 (7;535)
    sqluv_rollback , 0, 00000002, Detected in file:sqluvutl.C, Line:938
    
    2013-09-13-17.45.10.247000-240 I23395963H481      LEVEL: Severe
    PID     : 7936                 TID  : 8044        PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000         DB   : MYDB
    APPHDL  : 0-38538              APPID: *LOCAL.DB2.130913214737
    AUTHID  : DB2
    EDUID   : 8044                 EDUNAME: db2agent (MYDB) 0
    FUNCTION: DB2 UDB, database utilities, sqlu_register_table_load, probe:961
    MESSAGE : Load Error: Error acquiring partition resources.
    The box has been rebooted several times since July 9th and the behavior persists!

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Are the messages always for the same table (7,535)? Find out the table name (tablespace id = 7 and table id = 535) and try to query it.

    Please collect:
    db2pd -d <db name> -app -tra -api
    db2pd -util

  11. #11
    Join Date
    Dec 2007
    Posts
    288
    Thank you, I did not realize that the number 7;535 represented the tablespace ID and tables ID.

    I found the table name and it has a normal status in syscat.tables.
    when I ty and query it I get this:
    select * from myschema.snapshot_table
    SQL0204N "myschema.SNAPSHOT_TABLE" is an undefined name. SQLSTATE=42704

    output from db2pd -d <db name> -app -tra -api and
    db2pd -util attached. THANK YOU
    Attached Files Attached Files

  12. #12
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Is the schema name lowercase? Is so, put it in quotes.

    Please provide:

    db2 "select creator, name from sysibm.systables where tid =7 and fid = 535"
    db2cat -d <db name> -s <schema name> -n <table name> -v -o db2cat.out

    If the table exists in the catalog, but you get an error when trying to access it -> you do need to open a pmr. They have a db2cleancat tool that can be used to check for any orphan rows in the catalog.

  13. #13
    Join Date
    Dec 2007
    Posts
    288
    output from db2 "select creator, name from sysibm.systables where tid =7 and fid = 535"
    MYSCHEMA.SNAPSHOT_TABLE

    output from db2cat -d MYDB -s MYSCHEMA -n SNAPSHOT_TABLE -v -o db2cat.out

    DB2 Version 9.7, 5622-044 (c) Copyright IBM Corp. 2009
    Licensed Material - Program Property of IBM
    IBM DATABASE 2 Catalog Analysis and Repair Tool
    ************************************************** ***********
    Validating Packed Descriptor: MYSCHEMA.SNAPSHOT_TABLE
    No Corruption Detected.

  14. #14
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Please consider opening a pmr.

Posting Permissions

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