IBM Support

IT32551: MULTIPLE SEVERE/INFO MESSAGES WITH -803 COULD BE RECORDED IN DB2DIAG.LOG AND MAY AFFECT PERFORMANCE

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/info messages could be written to
    db2diag.log for inserting rows in DPF environment and it may
    affect performance.
    
    <Info level>
    2020-04-01-13.37.12.798719+540 E9502E1045           LEVEL: Info
    PID    : 13152               TID : 110036245367830 PROC :
    db2sysc 0
    INSTANCE: db2inst1            NODE : 000           DB  : SAMPLE
    APPHDL : 0-203               APPID:
    108.135.246.21.34722.110320041521
    UOWID  : 2                   ACTID: 1321
    AUTHID : DB2INST1           HOSTNAME: newel1.castle.fyre.ibm.com
    EDUID  : 211                 EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca, probe:20
    DATA #1 : String, 61 bytes
    Received sqlcode -803 for request 80000001 from node number 1
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -803  sqlerrml: 23
     sqlerrmc: 2 UEP101003.TEST_BLUMPP
     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:
    
    <Severe level>
    2019-11-27-22.50.18.104367-300 I1986E970             LEVEL:
    Severe
    PID     : 3069119              TID : 140735953233664 PROC :
    db2sysc 0
    INSTANCE: jl08183              NODE : 000            DB   :
    TEST1
    APPHDL  : 0-118                APPID: *N0.jl08183.191128035018
    AUTHID  : JL08183              HOSTNAME: hotellnx107
    EDUID   : 386                  EDUNAME: db2agent (TEST1) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_array_input,
    probe:4790
    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: 12
    sqlerrmc: 2 CLI.ARRINC
    sqlerrp : sqldmisr
    sqlerrd : (1) 0x80090005      (2) 0x00000005      (3) 0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * when user executing a large number of insert & updates       *
    * statements in parallel,                                      *
    * a lot of -803 messages will be logged into db2diag.log and   *
    * thus impacted the performance.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v111m4fp6, db2_main or later version          *
    ****************************************************************
    

Problem conclusion

  • db2_v111m4fp6, db2_main and later level
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32551

  • 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

    2020-04-14

  • Closed date

    2021-03-26

  • Last modified date

    2021-03-26

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

  • 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

[{"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:
27 March 2021