DB2 - Problem description
Problem IC66086 | Status: Closed |
EXTRANEOUS DB2DIAG.LOG MESSAGES AT DIAGLEVEL 3 DURING DATABASE MIGRATION | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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: * * database migration only * **************************************************************** * 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 DB2 version 9.7.0.2 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
9.7.0.2 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC66132 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.02.2010 08.04.2010 13.05.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.0.2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |