home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC96715 Status: Closed

DB2DIAG.LOG IS FILLED WITH -443 WARNING MESSAGES

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
This scenario can occur when we are trying to call 
UTL_FILE.FREMOVE with Invalid Path. Applying this APAR will 
remove the extra info in db2diag.log 
 
Following warning message will be dumped in the db2diag.log 
 
2013-09-09-10.07.15.303595-300 E1221656E857        LEVEL: 
Warning 
PID     : 12060                TID  : 47036938316096PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE 
APPHDL  : 0-36520              APPID: 
140.95.202.156.56501.130917010024 
AUTHID  : TESTER 
EDUID   : 31425                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, runtime interpreter, 
sqlriTrustedTruncateTokensUserSqlState, probe:100 
DATA #1 : signed integer, 4 bytes 
-443 
DATA #2 : String with size, 5 bytes 
5UA06 
DATA #3 : String with size, 30 bytes 
SYSIBMADM.UTL_FILE.IMP_FREMOVE 
DATA #4 : String with size, 20 bytes 
UTL_FILE_IMP_FREMOVE 
DATA #5 : String with size, 21 bytes 
UTL_FILE.INVALID_PATH 
DATA #6 : signed integer, 4 bytes 
68 
DATA #7 : signed integer, 4 bytes 
20 
DATA #8 : signed integer, 4 bytes 
20 
DATA #9 : signed integer, 4 bytes 
21
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************
Local Fix:
N/A
available fix packs:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 9.7 Fix Pack 9.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC97837 IC97850 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.10.2013
17.12.2013
17.12.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList