IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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: aix
    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: aix
    EDUID   : 28307                EDUNAME: db2taskp (DUDBKSK1) 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: aix
    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: aix
    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: aix
    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: aix
    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

    2021-03-31

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
01 April 2021