DB2 - Problem description
| Problem IT03584 | Status: Closed |
AFTER UPGRADING DAS TO DB2 9.7 FP9, EXECUTING A TASK WITH 'RUN NOW' FAILS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
After upgrading the DB2 Administration Server (DAS) to DB2 9.7
FP9, depending on the platform, the task center may return the
following error when you try to execute a task ('Run Now' ) :
SQL22282N The scheduler is unable to access the Tools Catalog
database. Reason code = "5" and SQLCODE "-30082".
or
SQL22221 The scheduler is not active. Reason code "1"
Depending on the platform, you may also see the following
message in your db2diag.log :
2014-02-07-08.14.53.806922+060 I6094146A1074 LEVEL: Error
PID : 5374020 TID : 2059 PROC :
db2dasstm
INSTANCE: db2inst1 NODE : 000
EDUID : 2059
FUNCTION: DB2 Common, Cryptography, cryptDecryptInit,
probe:999
MESSAGE :
ECF=0x90000403=-1879047165=ECF_CRYPT_UNEXPECTED_ERROR
Unexpected cryptographic error
DATA #1 : String, 14 bytes
gpCryptContext
DATA #2 : Hex integer, 4 bytes
0xDADEDADE
CALLSTCK: (Static functions may not be resolved correctly,
as they are resolved to the nearest symbol)
[0] 0x09000000005FA228 pdOSSeLoggingCallback + 0x34
[1] 0x090000000205CE44 oss_log__FP9OSSLogFacUiN32UlN26iPPc
+ 0x1C4
[2] 0x090000000205CC30 ossLog + 0xD0
[3] 0x0900000011365F1C cryptDecryptInit + 0xDC
[4] 0x09000000113682D8 cryptDecryptBuffer + 0x78
[5] 0x09000000113606B8 getUserData__FPcT1 + 0xB8
[6] 0x0900000011373F3C getDBConfig__FP12DasCfgStruct +
0x21C
[7] 0x09000000113914F4 runNow + 0xB4
[8] 0x09000000112CA6CC db2dasSCRunNow + 0x46C
[9] 0x0000000100005E60 runCAPI__FP14run_c_api_dataP5sqlca
+ 0x2E0 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Task Center users using db2 client less than v101fp5 are * * affected * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v101fp5 and use a client of v97fp10/v101fp5 or * * higher * **************************************************************** | |
| Local Fix: | |
Depending on the platform, one of the following may help : 1 - drop and recreate the DAS 2 - db2 reset admin cfg Please note that on AIX, there is no workaround. | |
| Solution | |
This is a limitation. This APAR fixed the error that is coming for scheduling tasks but due to security vulnerability, Customers are requested to use task center of v97fp10 or higher or v101fp5 or higher to schedule tasks. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.08.2014 13.07.2015 13.07.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10, 9.7.FP10/V10 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.5 |
|