IBM Support

IT30925: SEVERE MESSAGE WITH -803 COULD BE RECORDED IND B2DIAG.LOG.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The following kind of severe error could be written to
    db2diag.log for insering rows in DPF environment.
    Returning SQL0803 to the applications is reasonable. However,
    recording this record in db2diag.log is unnecessarily.
    
    2019-10-28-19.07.35.946280+540 I2365168E1007         LEVEL:
    Severe
    PID     : 11267                TID : 140096678389504 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    BLUDB
    APPHDL  : 0-48089              APPID: x.x.x.x.xxxxx.xxxxxxxxxxxx
    AUTHID  : UEP101002            HOSTNAME: hostname
    EDUID   : 787                  EDUNAME: db2agent (BLUDB) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_array_input,
    probe:4718
    MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -803   sqlerrml: 18
     sqlerrmc: 1 UEP101002.TEST01
     sqlerrp : sqldmisr
     sqlerrd : (1) 0x80090005      (2) 0x00000005      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000001
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * User using Db2 server utilizing DPF.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V11.1 Mod 4 Fix Pack 6.                           *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in V11.1 Mod 4 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30925

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-13

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

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

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

    412AC3Ÿ IT31072

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
20 March 2021