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 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
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

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 FixList