home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66249 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
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
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Defect   => wsdbu00624192 
Fixed in => v9.7 + FP3 
Module   => engn_ABP
Workaround
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
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.02.2010
24.09.2010
24.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList