Fixes are available
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:
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022