IT24960: -901 ERROR IN SOME CASES WHEN EXPLAIN MODE IS ON AND A STATEMENTIS RUN TWICE

APAR status

• Closed as program error.

Error description

• Example:
  
  2017-03-08-14.59.04.187441+060 I1415362911E992       LEVEL:
  Severe
  PID     : 13860                TID : 139985030211328 PROC :
  db2sysc 0
  INSTANCE: XXXX             NODE : 000            DB   : XXX
  APPHDL  : XXXXXX           APPID: XXXXXXXXXXX
  AUTHID  : XXXX               HOSTNAME: XXX
  EDUID   : XXX                  EDUNAME: db2agent (PB3) 0
  FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
  probe:250
  MESSAGE : ZRC=0x825B01ED=-2107964947=SQLRA_PREP_ANON_BLOCK
            "Can't compile the anonymous block directly, use
  icoord method"
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 0
  sqlerrmc:
  sqlerrp : SQLRA067
  sqlerrd : (1) 0x825B01ED      (2) 0x000001ED      (3) 0x00000000
             (4) 0x00000000      (5) 0xFFFFFC18      (6)
  0x00000000
  sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
             (7)      (8)      (9)      (10)        (11)
  sqlstate:
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 11.1 Mod 4 Fixpack 4
  

Temporary fix

Comments

APAR Information

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

  IT23319

• 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

• RB10 PSN

     UP