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 | |
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 | |
10.5.0.1 |