IBM Support

IC66249: AIC IS NOT PUT INTO SUSPENDED STATE AFTER RECEIVING -952 ERROR. IF AIC IS NOT IN SUSPENDED STATE, IT IS NOT INVOKED FOR RETRY.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If AIC is interrupted with user user interrupt(-952 in SQLCA),
    its status is set to ABP_TASK_PRO_ERROR state.  You will see the
    following entries in the db2diag.log:
    
    ************************************************************
    
    FUNCTION: DB2 UDB, catalog services,
    sqlrlAlterDetachCatalogChange,
    probe:100
    RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"
    
    
        <SNIP>
    
    
    FUNCTION: DB2 UDB, AIC, aicDelDPartID, probe:150
    
    MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"
    CALLED  : DB2 UDB, catalog services, sqlrlCleanDPartID
    RETCODE : ZRC=0x82A90067=-2102853529=ABP_TASK_PRO_ERROR
              "Task processor encountered an error"
    
    
        <SNIP>
    
    FUNCTION: DB2 UDB, ABP,
    ABPDispatcher::updateAssignedTaskProCont,
    probe:100
    MESSAGE :
    ADM13500E  An agent executing an asynchronous background task
    processor encountered an unrecoverable error. The task processor
    has been suspended and diagnostic information was written to the
    db2diag.log. Contact IBM Support for assistance. The task
    processor context is "0x07800002493DA4A0". The task processor
    description is "Remove Partition ID from Catalog".
    
    ************************************************************
    
    DB2 should rather put AIC in suspended state (
    ABP_SUSPEND_TASK_PRO).  When AIC is put in suspended state, it
    will retry the task every 5 minutes until it succeed.
    

Local fix

  • You can manually resume the AIC process left in such error
    state as following:
    
    
    db2pd -db <DB_NAME> -abp resume <CONTEXT_ADDRESS>
    
    Where,
    
    <DB_NAME>         = name of the database
    <CONTEXT_ADDRESS> = This context address can be found in the
                        db2diag.log entry as I have shown in the
                        error description.
    
    For example,
    
    db2pd -db SAMPLE -abp resume 0x07800002493DA4A0
    

Problem summary

  • If AIC is interrupted with user user interrupt(-952 in SQLCA),
    
    its status is set to ABP_TASK_PRO_ERROR state.  You will see the
    following entries in the db2diag.log:
    
    ************************************************************
    
    FUNCTION: DB2 UDB, catalog services,
    sqlrlAlterDetachCatalogChange,
    probe:100
    RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"
    
    
        <SNIP>
    
    
    FUNCTION: DB2 UDB, AIC, aicDelDPartID, probe:150
    
    MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"
    CALLED  : DB2 UDB, catalog services, sqlrlCleanDPartID
    RETCODE : ZRC=0x82A90067=-2102853529=ABP_TASK_PRO_ERROR
              "Task processor encountered an error"
    
    
        <SNIP>
    
    FUNCTION: DB2 UDB, ABP,
    ABPDispatcher::updateAssignedTaskProCont,
    probe:100
    MESSAGE :
    ADM13500E  An agent executing an asynchronous background task
    processor encountered an unrecoverable error. The task processor
    has been suspended and diagnostic information was written to the
    db2diag.log. Contact IBM Support for assistance. The task
    processor context is "0x07800002493DA4A0". The task processor
    description is "Remove Partition ID from Catalog".
    
    ************************************************************
    
    DB2 should rather put AIC in suspended state (
    ABP_SUSPEND_TASK_PRO).  When AIC is put in suspended state, it
    will retry the task every 5 minutes until it succeed.
    

Problem conclusion

  • Defect   => wsdbu00624192
    Fixed in => v9.7 + FP3
    Module   => engn_ABP
    

Temporary fix

  • You can manually resume the AIC process left in such error
    state as following:
    
    
    db2pd -db <DB_NAME> -abp resume <CONTEXT_ADDRESS>
    
    Where,
    
    <DB_NAME>         = name of the database
    <CONTEXT_ADDRESS> = This context address can be found in the
                        db2diag.log entry as I have shown in the
                        error description.
    
    For example,
    
    db2pd -db SAMPLE -abp resume 0x07800002493DA4A0
    

Comments

APAR Information

  • APAR number

    IC66249

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-11

  • Closed date

    2010-09-24

  • Last modified date

    2010-09-24

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

    IZ70173

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC66249

Modified date: 24 September 2010