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

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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