home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList