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 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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList