IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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.
    

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 )
    

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.                        *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 10 Fix Pack 1
    

Temporary 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 )
    

Comments

APAR Information

  • APAR number

    IC84498

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-14

  • Closed date

    2012-11-13

  • Last modified date

    2012-11-13

  • APAR is sysrouted FROM one or more of the following:

    IC81710

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 November 2012