|
Problem IT34654
|
Status: Closed |
WARNING MESSAGES ARE GETTING LOGGED AS SEVERE MESSAGES
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| 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: |
| 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. *
**************************************************************** |
| Local Fix: |
These Severe messages can be safely ignored. |
| Solution |
|
| Workaround |
****************************************************************
* 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. *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.10.2020
12.03.2021
12.03.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
