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 IC84498 Status: Closed

THE INDIVIDUAL DB2 DIAGNOSTIC ROTATING LOG ( DB2DIAG.#.LOG, OR
<INSTANCE>.#.NFY ) IS LIMITED WITHIN 4G IN SIZE.

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
If DIAGSZIE is set to a value so that the size of individual db2 
diagnostic rotating log ( db2diag.#.log, or <instance>.#.nfy ) 
is more than 4G, then, when the individual db2 diagnostic 
rotating log reached 4G in size, following ADM14000E will be 
dumped into <instance>.nfy, and current db2diag.#.log will be 
stopped logging. 
 
2012-01-21-02.58.42.413049   Instance:ndm   Node:021 
 
PID:2688288(db2linit 21)   TID:8001 
 
Appid:10.154.145.104.42631.120120185744 
 
RAS/PD component  pdLogInternal Probe:18   Database:NDB 
 
 
 
ADM14000E  DB2 is unable to open diagnostic log file "".  Run 
the 
command 
 
"db2diag -rc "0x870f014c"" to find out more.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 10 on Linux, Unix and Windows           * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If DIAGSZIE is set to a value so that the size of individual * 
* db2                                                          * 
* diagnostic rotating log ( db2diag.#.log, or <instance>.#.nfy * 
* )                                                            * 
* is more than 4G, then, when the individual db2 diagnostic    * 
* rotating log reached 4G in size, following ADM14000E will be * 
* dumped into <instance>.nfy, and current db2diag.#.log will   * 
* be                                                           * 
* stopped logging.                                             * 
*                                                              * 
* 2012-01-21-02.58.42.413049   Instance:ndm   Node:021         * 
*                                                              * 
* PID:2688288(db2linit 21)   TID:8001                          * 
*                                                              * 
* Appid:10.154.145.104.42631.120120185744                      * 
*                                                              * 
* RAS/PD component  pdLogInternal Probe:18   Database:NDB      * 
*                                                              * 
*                                                              * 
*                                                              * 
* ADM14000E  DB2 is unable to open diagnostic log file "".     * 
* Run                                                          * 
* the                                                          * 
* command                                                      * 
*                                                              * 
* "db2diag -rc "0x870f014c"" to find out more.                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10 Fix Pack 1.                        * 
****************************************************************
Local Fix:
Reset DIAGSIZE to a value so that the size of  individual db2 
diagnostic rotating log ( db2diag.#.log, or <instance>.#.nfy ) 
is less then 4G, then restart instance. 
Or 
Archive ( or delete ) the current db2 diagnostic rotating log ( 
db2diag.#.log, or <instance>.#.nfy )
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 10 Fix Pack 1
Workaround
Reset DIAGSIZE to a value so that the size of  individual db2 
diagnostic rotating log ( db2diag.#.log, or <instance>.#.nfy ) 
is less then 4G, then restart instance. 
Or 
Archive ( or delete ) the current db2 diagnostic rotating log ( 
db2diag.#.log, or <instance>.#.nfy )
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.06.2012
13.11.2012
13.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 FixList