About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Shipped in Db2 12.1 GA.
INF preferred over WAR, but WAR would be acceptable over ERR/SEV
Thanks
Hi. This what you probably saw:
2022-09-07-13.14.30.438399-240 I25454E468 LEVEL: Warning
FUNCTION: DB2 UDB, data protection services, sqlpgarl, probe:445
DATA #1 : <preformatted>
Read Lso 4212582282425 no longer in the active Log path on log stream 0.
2022-09-07-13.14.30.439268-240 I25923E511 LEVEL: Error
FUNCTION: DB2 UDB, data protection services, sqpLoggrEdu::sqlpLoggrMain, probe:2
MESSAGE : ZRC=0x82100101=-2112880383=SQLP_LOG_NOT_ACTIVE
"Log needed for read is no longer in the active log space."
2022-09-07-13.14.30.447439-240 I26435E1100 LEVEL: Error
FUNCTION: DB2 UDB, data protection services, sqlpgrlgSearchInActiveLogs, probe:1033
MESSAGE : ZRC=0x82100101=-2112880383=SQLP_LOG_NOT_ACTIVE
"Log needed for read is no longer in the active log space."
2022-09-07-13.14.30.458513-240 I27536E901 LEVEL: Error
FUNCTION: DB2 UDB, data protection services, sqlpgrlgSearchSharedReadBufferAndActiveLogs, probe:1234
MESSAGE : ZRC=0x82100101=-2112880383=SQLP_LOG_NOT_ACTIVE
"Log needed for read is no longer in the active log space."
2022-09-07-13.14.30.480297-240 I28438E638 LEVEL: Severe
FUNCTION: DB2 UDB, data protection services, sqlpgrlg, probe:1885
MESSAGE : ZRC=0x82100101=-2112880383=SQLP_LOG_NOT_ACTIVE
"Log needed for read is no longer in the active log space."
At the very least we will look to keep these consistent and use WAR throughout. Will assess if INF possible to use too.
There are cases where this may need to be ERR/SEV, but not in your case, which is the typical.