IBM Support

IT34654: WARNING MESSAGES ARE GETTING LOGGED AS SEVERE MESSAGES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Db2 version: ""DB2 v11.1.4.4", "s1902261400",
    "DYN1902261400AMD64", and Fix Pack "4a"
    
    SQL1179W warning messages are getting logged as Severe Messages.
    It need to reflected as Warnings Messages.
    
    
    
    2020-10-19-12.16.17.237558+480 I11401E1079 LEVEL: Severe
    PID : 11327 TID : 140624422496000 PROC : db2sysc 0
    INSTANCE: tofdb88 NODE : 000 DB : TOF
    APPHDL : 0-11657 APPID: XXXXXXXXXXXXXXX
    AUTHID : TOFCLNT88 HOSTNAME: XXXXXXXXXX
    EDUID : 5257 EDUNAME: db2agent (TOF) 0
    FUNCTION: DB2 UDB, base sys utilities,
    sqeIcoordCB::WaitForCompletion, probe:748
    RETCODE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
    "SQLCA has been built and saved in component specific control
    block."
    DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x8005006D
    DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: 1179 sqlerrml: 23
    sqlerrmc: PACKAGE LVY.P1317968857
    sqlerrp : SQLRA159
    sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:
    

Local fix

  • These Severe messages can be safely ignored.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2LUW Users                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Db2 version: ""DB2 v11.1.4.4", "s1902261400",                *
    * "DYN1902261400AMD64", and Fix Pack "4a"                      *
    *                                                              *
    * SQL1179W warning messages are getting logged as Severe       *
    * Messages. It need to reflected as Warnings Messages.         *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2020-10-19-12.16.17.237558+480 I11401E1079 LEVEL: Severe     *
    * PID : 11327 TID : 140624422496000 PROC : db2sysc 0           *
    * INSTANCE: tofdb88 NODE : 000 DB : TOF                        *
    * APPHDL : 0-11657 APPID: XXXXXXXXXXXXXXX                      *
    * AUTHID : TOFCLNT88 HOSTNAME: XXXXXXXXXX                      *
    * EDUID : 5257 EDUNAME: db2agent (TOF) 0                       *
    * FUNCTION: DB2 UDB, base sys utilities,                       *
    * sqeIcoordCB::WaitForCompletion, probe:748                    *
    * RETCODE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT           *
    * "SQLCA has been built and saved in component specific        *
    * control block."                                              *
    * DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes                          *
    * 0x8005006D                                                   *
    * DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes                *
    * sqlcaid : SQLCA sqlcabc: 136 sqlcode: 1179 sqlerrml: 23      *
    * sqlerrmc: PACKAGE LVY.P1317968857                            *
    * sqlerrp : SQLRA159                                           *
    * sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000       *
    * (4) 0x00000000 (5) 0x00000000 (6) 0x00000000                 *
    * sqlwarn : (1) (2) (3) (4) (5) (6)                            *
    * (7) (8) (9) (10) (11)                                        *
    * sqlstate:                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Ignore the Errors , Will be fixed in next fixpack.           *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • NA
    

Comments

  • NA
    

APAR Information

  • APAR number

    IT34654

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-23

  • Closed date

    2021-03-12

  • Last modified date

    2021-03-12

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

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

Fix information

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:
13 March 2021