DB2 - Problem description
Problem IT04293 | Status: Closed |
IN PURESCALE DB2 LOG HEADER (XHDR) UPDATION INFO IS DUMPED AS WARNING ,WHICH SHOULD BE AT INFO LEVEL | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
In Purescale , We observe the following messages continiously 2014-09-01-02.22.11.722641+330 E40910681A2078 LEVEL: Warning PID : 4587740 TID : 56163 PROC : db2sysc 1 INSTANCE: db2ipist NODE : 001 DB : PRODIST HOSTNAME: pneftswdb0q2 EDUID : 56163 EDUNAME: db2hadrp.1.1 (PRODIST) 1 FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEdu:: hdrEduP, probe:5234 DATA #1 : String, 32 bytes Waiting for closed bit to be set DATA #2 : SQLPG_XHDR, PD_TYPE_SQLPG_XHDR, 2048 bytes Validity Check 1 = 155 Format Version = 13 alVersion = V:10 R:5 M:0 F:3 I:0 SB:0 Log Extent State = 0x00010001 - SQLPG_State_Init - SQLPG_State_FileEntryNum1_Valid Signature = IBMLOG Partition = 0 Log Stream = 1 Topology Life ID = 1396543046 2014-04-03-16.37.26.000000 GMT Compression Mode = 0 (UNCOMPRESSED) Segment Size = 0 Extent Number = 5464 Extent Size = 32768 Number of Pages = 32768 Previous Extent ID = 1409457290 2014-08-31-03.54.50.000000 GMT Database Log ID = 1396543046 2014-04-03-16.37.26.000000 GMT Current Extent ID = 1409462868 2014-08-31-05.27.48.000000 GMT Original Current Extent ID = 1409176967 2014-08-27- 22.02.47.000000 GMT firstLso = 704554012673 maps to 000000A4D8C00010 minTruncOffset = 0 fileEntryNum1 = 16845 fileEntryNum2 = 0 logFileChainId = 4 lsnBase = 00000000D96CDBB7 logChainInfo[0] = 19551803 000000000E38186C 1398289089 3145 logChainInfo[1] = 0 0000000000000000 1396543046 6239 logChainInfo[2] = 19551803 000000000E38186C 1398289089 3145 logChainInfo[3] = 18446744073709551615 FFFFFFFFFFFFFFFF 4294967295 0 gfaNumEntries = 0 gfa(Global FRALA Array) : idx gfaLogStreamId gfaExtNum 0 0 6552 1 1 5290 (All-zero GFA entries after gfaNumEntries entries are omitted) firstLFSInExtent = 491921636 firstLFSInNextExtent = 0 lastLfsInExtent = 18446744073709551615 lastLsnInExtent = FFFFFFFFFFFFFFFF firstRecLso = 704554013724 hbGroupNextLfsLsn = 0/0000000000000000 hbStreamLastLfsLsn = 0/0000000000000000 hbStreamDiskLso = 0 xhdrCheckSum = 9B369809 expectedCheckSum 9B369809 This is a normal condition, where the HADR primary needs to wait for some final updates to be made in the log file header (XHDR) before shipping it to standby. The condition is not supposed to last long, as these final updates are supposed to be made and the LFR will see them We are making the message as Info level. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 PureScale users * **************************************************************** * PROBLEM DESCRIPTION: * * We observe db2 log header info dumped continiously as * * Warning. * * * * We will change the message level to Info. * **************************************************************** * RECOMMENDATION: * * Ignore the message. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Comment | |
Problem is first fixed in db2 v10.5 fp7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.09.2014 25.01.2016 25.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |