IBM Support

IT30507: DETACH PARTITION TAKES A LONG TIME -601 ERROR REPORTED ON DB2DIAG.LOG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Detach partition logs -601 in db2diag.log. Blocks drop table
    command due to pending detach.
    
    Every DETACH of any partitioned table actually takes a long time
    to complete, filling db2diag.log with SQLCODE -601 in
    db2diag.log
    
    On db2diag.log we have:
    
    2019-08-23-08.09.55.785575+120 I132057A547          LEVEL: Error
    PID     : 8781874              TID : 28307          PROC :
    db2sysc 0
    INSTANCE: db2inst1            NODE : 000           DB   : SAMPLE
    APPHDL  : 0-42744              APPID: *LOCAL.DB2.190823060955
    AUTHID  : db2inst1             HOSTNAME: MYHOST1
    EDUID   : 28307                EDUNAME: db2taskp
    FUNCTION: DB2 UDB, catalog services,
    sqlrlCreateTargetIndexesOnDetach, probe:100
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    
    2019-08-23-08.09.55.785904+120 I132605A932          LEVEL: Error
    PID     : 8781874              TID : 28307          PROC :
    db2sysc 0
    INSTANCE: db2inst1            NODE : 000           DB   : SAMPLE
    APPHDL  : 0-42744              APPID: *LOCAL.DB2.190823060955
    AUTHID  : db2inst1            HOSTNAME: MYHOST1
    EDUID   : 28307                EDUNAME: db2taskp (SAMPLE) 0
    FUNCTION: DB2 UDB, AIC, apdTaskProcessor, probe:1196
    MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : String, 28 bytes
    APD ERROR DURING PROCESSING!
    DATA #2 : APD_TASK_PRO_INFO, PD_APD_TYPE_TASK_PRO_INFO, 24 bytes
    
    APD_TASK_PRO_INFO: Address:a00010040c24960, Size:x18, Size:24
       x0000        cleanupType                   DD
       x0008        pApdDtCurrentTask             a00010043bb3320
       x0010        apdDtMasterPoolID             65530
       x0012        apdDtMasterObjectID           32771
       x0014        apdDtDPartID                  55
    
    2019-08-23-08.09.55.786247+120 I133538A1457         LEVEL:
    Warning
    PID     : 8781874              TID : 28307          PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    APPHDL  : 0-42744              APPID: *LOCAL.DB2.190823060955
    AUTHID  : db2inst1             HOSTNAME: MYHOST1
    EDUID   : 28307                EDUNAME: db2taskp
    FUNCTION: DB2 UDB, AIC, apdTaskProcessorCleanup, probe:197
    MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    CALLED  : DB2 UDB, AIC, apdTaskProcessor
    RETCODE : ZRC=0x82A90066=-2102853530=ABP_SUSPEND_TASK_PRO
              "Suspend the task processor"
    DATA #1 : String, 28 bytes
    Source Table Schema and Name
    DATA #2 : String, 8 bytes
    XX
    DATA #3 : String, 9 bytes
    ONLINE
    DATA #4 : String, 12 bytes
    Partition ID
    DATA #5 : unsigned integer, 2 bytes
    55
    DATA #6 : String, 28 bytes
    Target Table Schema and Name
    DATA #7 : String, 8 bytes
    XX
    DATA #8 : String, 21 bytes
    ONLINEXXXXX
    DATA #9 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -601   sqlerrml: 27
    sqlerrmc: XX.XXXXXXXXX INDEX
    sqlerrp : SQLRL1D0
    sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0xFFFFE0A3      (6)
    0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    
    2019-08-23-08.09.55.803498+120 I134996A547          LEVEL: Error
    PID     : 8781874              TID : 11379          PROC :
    db2sysc 0
    INSTANCE: db2inst1           NODE : 000           DB   : SAMPLE
    APPHDL  : 0-43429              APPID: *LOCAL.DB2.190823060455
    AUTHID  : XXXXXXX             HOSTNAME: MYHOST1
    EDUID   : 11379                EDUNAME: db2taskp (SAMPLE) 0
    FUNCTION: DB2 UDB, catalog services,
    sqlrlCreateTargetIndexesOnDetach, probe:100
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    
    2019-08-23-08.09.55.803791+120 I135544A931          LEVEL: Error
    PID     : 8781874              TID : 11379          PROC :
    db2sysc 0
    INSTANCE: db2inst1           NODE : 000           DB   : SAMPLE
    APPHDL  : 0-43429              APPID: *LOCAL.DB2.190823060455
    AUTHID  : XXXXXX            HOSTNAME: MYHOST1
    EDUID   : 11379                EDUNAME: db2taskp (SAMPLE) 0
    FUNCTION: DB2 UDB, AIC, apdTaskProcessor, probe:1196
    MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : String, 28 bytes
    APD ERROR DURING PROCESSING!
    DATA #2 : APD_TASK_PRO_INFO, PD_APD_TYPE_TASK_PRO_INFO, 24 bytes
    
    APD_TASK_PRO_INFO: Address:a0001001879be60, Size:x18, Size:24
       x0000        cleanupType                   DD
       x0008        pApdDtCurrentTask             a00010040ce33a0
       x0010        apdDtMasterPoolID             65530
       x0012        apdDtMasterObjectID           32772
       x0014        apdDtDPartID                  3
    
    2019-08-23-08.09.55.804114+120 I136476A1454         LEVEL:
    Warning
    PID     : 8781874              TID : 11379          PROC :
    db2sysc 0
    INSTANCE: db2inst1           NODE : 000           DB   : SAMPLE
    APPHDL  : 0-43429              APPID: *LOCAL.DB2.190823060455
    AUTHID  : db2inst1            HOSTNAME: MYHOST1
    EDUID   : 11379                EDUNAME: db2taskp (SAMPLE) 0
    FUNCTION: DB2 UDB, AIC, apdTaskProcessorCleanup, probe:197
    MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    CALLED  : DB2 UDB, AIC, apdTaskProcessor
    RETCODE : ZRC=0x82A90066=-2102853530=ABP_SUSPEND_TASK_PRO
              "Suspend the task processor"
    DATA #1 : String, 28 bytes
    Source Table Schema and Name
    DATA #2 : String, 8 bytes
    XXX
    DATA #3 : String, 8 bytes
    ONLINE
    DATA #4 : String, 12 bytes
    Partition ID
    DATA #5 : unsigned integer, 2 bytes
    3
    DATA #6 : String, 28 bytes
    Target Table Schema and Name
    DATA #7 : String, 8 bytes
    XXXX
    DATA #8 : String, 20 bytes
    XXXXXXXXXX
    DATA #9 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -601   sqlerrml: 27
    sqlerrmc:XX.XXXXXXXXX INDEX
    sqlerrp : SQLRL1D0
    sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0xFFFFE0A3      (6)
    0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    
    Output from list utilities:
    
    ID                               = 22219
    Type                             = ASYNCHRONOUS PARTITION DETACH
    Database Name                    = SAMPLE
    Member Number                    = 0
    Description                      = Finalize the detach for
    partition '3' of table 'XX.XXXXXXX'
    Start Time                       = 08/22/2019 06:24:15.415654
    State                            = Waiting
    Invocation Type                  = Automatic
    Progress Monitoring:
          Start Time                 = 08/23/2019 08:09:55.803789
    
    
    ID                               = 22031
    Type                             = ASYNCHRONOUS PARTITION DETACH
    Database Name                    = SAMPLE
    Member Number                    = 0
    Description                      = Finalize the detach for
    partition '55' of table 'XX.XXXXXXX'
    Start Time                       = 08/22/2019 03:33:08.137462
    State                            = Waiting
    Invocation Type                  = Automatic
    Progress Monitoring:
          Start Time                 = 08/23/2019 08:09:55.785901
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30507

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-04

  • Closed date

    2021-03-31

  • Last modified date

    2022-03-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022