IBM Support

IT29937: DB2PD -LOGS DISPLAYS WRONG LOG FILE NAME WHEN LOG NUMBER IS GREATER THAN 9999999

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When log number is greater than 9999999, db2pd -logs displays
    wrong log file name. In below sample output, db2pd -logs
    displays log file name S10000000.LOG, but actually the name of
    the log file is S0000000.LOG.
    
    Database Member 0 -- Database MR -- Active -- Up 0 days 00:01:32
    -- Date 2019-04-28-01.12.06.140101
    
    Logs:
    Current Log Number            9999997
    Pages Written                 3
    Cur Commit Disk Log Reads     0
    Cur Commit Total Log Reads    0
    Method 1 Archive Status       n/a
    Method 1 Next Log to Archive  n/a
    Method 1 First Failure        n/a
    Method 2 Archive Status       n/a
    Method 2 Next Log to Archive  n/a
    Method 2 First Failure        n/a
    Log Chain ID                  0
    Current LSO                   44849115
    Current LSN                   0x00000000000416BB
    
    Address            StartLSN         StartLSO             State
    Size       Pages      Filename
    0x00007F31901AF8B8 000000000004163A 44836001
    0x00000000 1024       1024       S9999997.LOG
    0x00007F31901B0B78 0000000000000000 49009825
    0x00000000 1024       1024       S9999998.LOG
    0x00007F31901B14D8 0000000000000000 53183649
    0x00000000 1024       1024       S9999999.LOG
    0x00007F31901B1E38 0000000000000000 57357473
    0x00000000 1024       1024       S10000000.LOG
    0x00007F31901B2798 0000000000000000 61531297
    0x00000000 1024       1024       S10000001.LOG
    0x00007F31901B30F8 0000000000000000 65705121
    0x00000000 1024       1024       S10000002.LOG
    0x00007F31901B3A58 0000000000000000 69878945
    0x00000000 1024       1024       S10000003.LOG
    0x00007F31901B43B8 0000000000000000 74052769
    0x00000000 1024       1024       S10000004.LOG
    0x00007F31901B4D18 0000000000000000 78226593
    0x00000000 1024       1024       S10000005.LOG
    0x00007F31901B5678 0000000000000000 82400417
    0x00000000 1024       1024       S10000006.LOG
    0x00007F31901B5FD8 0000000000000000 86574241
    0x00000000 1024       1024       S10000007.LOG
    0x00007F31901B6938 0000000000000000 90748065
    0x00000000 1024       1024       S10000008.LOG
    0x00007F31901B7298 0000000000000000 94921889
    0x00000000 1024       1024       S10000009.LOG
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29937

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-08-07

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

    IT29930

  • 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

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020