DB2 - Problem description
Problem IC66132 | Status: Closed |
EXTRANEOUS DB2DIAG.LOG MESSAGES AT DIAGLEVEL 3 DURING DATABASE MIGRATION | |
product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problem description: | |
These informational msgs were being logged at DIAGLEVEL WARNING level settings (diaglevel 3) during database migration time. Depending on the number of tables and table spaces within the database, there could be a large number of these messages, which would make the db2diag.log unnecessarily large. This APAR ensures that these msgs will only be logged at DIAGLEVEL INFO level settings (diaglevel 4). PID : 933902 TID : 2829 PROC : db2sysc 0 INSTANCE: vicchang NODE : 000 DB : PCMIS00I APPHDL : 0-51 APPID: *N0.vicchang.091205151252 AUTHID : VICCHANG EDUID : 2829 EDUNAME: db2agent (PCMIS00I) 0 FUNCTION: DB2 UDB, data management, sqldMigrateDAT, probe:1162 MESSAGE : Migrate DAT object ID DATA #1 : unsigned integer, 4 bytes PID : 933902 TID : 2829 PROC : db2sysc 0 INSTANCE: vicchang NODE : 000 DB : PCMIS00I APPHDL : 0-51 APPID: *N0.vicchang.091205151252 AUTHID : VICCHANG EDUID : 2829 EDUNAME: db2agent (PCMIS00I) 0 FUNCTION: DB2 UDB, data management, sqldMigrateDMSTablespace, probe:2153 MESSAGE : Starting Migration of DMS table space ID DATA #1 : String, 11 bytes SYSCATSPACE | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * These informational msgs were being logged at DIAGLEVEL * * WARNING level settings (diaglevel 3) during database * * migration time. Depending on the number of tables and table * * spaces within the database, there could be a large number of * * these messages, which would make the db2diag.log * * unnecessarily large. This APAR ensures that these msgs will * * only be logged at DIAGLEVEL INFO level settings (diaglevel * * 4). * * * * PID : 933902 TID : 2829 PROC : * * db2sysc 0 * * INSTANCE: vicchang NODE : 000 DB : * * PCMIS00I * * APPHDL : 0-51 APPID: * * *N0.vicchang.091205151252 * * AUTHID : VICCHANG * * EDUID : 2829 EDUNAME: db2agent (PCMIS00I) * * 0 * * FUNCTION: DB2 UDB, data management, sqldMigrateDAT, * * probe:1162 * * MESSAGE : Migrate DAT object ID * * DATA #1 : unsigned integer, 4 bytes * * * * * * PID : 933902 TID : 2829 PROC : * * db2sysc 0 * * INSTANCE: vicchang NODE : 000 DB : * * PCMIS00I * * APPHDL : 0-51 APPID: * * *N0.vicchang.091205151252 * * AUTHID : VICCHANG * * EDUID : 2829 EDUNAME: db2agent (PCMIS00I) * * 0 * * FUNCTION: DB2 UDB, data management, * * sqldMigrateDMSTablespace, probe:2153 * * MESSAGE : Starting Migration of DMS table space ID * * DATA #1 : String, 11 bytes * * SYSCATSPACE * **************************************************************** * RECOMMENDATION: * * Upgrade to v98 fp3. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
v9.8.3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.02.2010 17.01.2011 17.01.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.8.3, 9.8.FP3 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.8.0.3 |