DB2 - Problem description
Problem IT29930 | Status: Closed |
DB2PD -LOGS DISPLAYS WRONG LOG FILE NAME WHEN LOG NUMBER IS GREATER THAN 9999999 | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Customers whose log number greater than 9999999. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to V11.1.4.5 or above. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT29937 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.08.2019 07.08.2019 07.08.2019 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |