|
Problem IC72641
|
Status: Closed |
ADM1552E ROLLFORWARD BACKWARD RECOVERY PHASE NOT USING OVERFLOW LOG PATH SPECIFIED IN ROLLFOWARD COMMAND WHEN LOGSECOND = -1 |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
During the backward phase of recovery rollfoward db2 is not
looking in the overflow log path for log files
This message repeats every 5 minutes even though the logs are
in the overflow log path specified
ADM1552E DB2 is unable to open active logfile "......" This
could be caused by problem in retrieving the log file
from archive.
DB2 will try again every 5 minutes.
Messages seen in db2diag.log file during rollforward
2010-10-25-09.10.44.535533-300 I141182E401 LEVEL: Info
PID : 8457 TID : 47714544904512PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 303 EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgPostLogMgrToRetrieve, probe:1050
DATA #1 : <preformatted>
RTStatus is in state 16 at index 0.
2010-10-25-09.10.44.535753-300 I141584E178 LEVEL: Error
PID:8457 TID:47714544904512 NODE:000 Title: SQLP_DBCB
Dump File:/home/db2inst1/sqllib/db2dump/8457.303.000.dump.bin
2010-10-25-09.10.44.536127-300 I141763E377 LEVEL: Error
PID : 8457 TID : 47714544904512PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 303 EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOpenCAL,
probe:120
MESSAGE : Retrieved failed with error -2146434659
2010-10-25-09.10.44.536413-300 E142141E533 LEVEL: Error
PID : 8457 TID : 47714544904512PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
EDUID : 303 EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOpenCAL,
probe:200
MESSAGE : ADM1552E DB2 is unable to open active log file
"S0000309.LOG". This
could be caused by problem in retrieving the log file
from archive.
DB2 will try again every 5 minutes.
This occurs during backward phase with logsecond set to -1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* During the backward phase of recovery rollfoward db2 is not *
* looking in the overflow log path for log files *
* *
* *
* *
* This message repeats every 5 minutes even though the logs *
* are in the overflow log path specified *
* *
* *
* *
* ADM1552E DB2 is unable to open active logfile "......" *
* This could be caused by problem in retrieving the log file *
* from archive. *
* *
* DB2 will try again every 5 minutes. *
* *
* *
* *
* *
* *
* Messages seen in db2diag.log file during rollforward *
* *
* *
* *
* 2010-10-25-09.10.44.535533-300 I141182E401 LEVEL: *
* Info *
* PID : 8457 TID : 47714544904512PROC : *
* *
* db2sysc 0 *
* *
* INSTANCE: db2inst1 NODE : 000 DB : SAMPLE *
* *
* EDUID : 303 EDUNAME: db2loggr (SAMPLE) 0 *
* *
* FUNCTION: DB2 UDB, data protection services, *
* sqlpgPostLogMgrToRetrieve, probe:1050 *
* *
* DATA #1 : <preformatted> *
* *
* RTStatus is in state 16 at index 0. *
* *
* *
* *
* 2010-10-25-09.10.44.535753-300 I141584E178 LEVEL: *
* Error *
* PID:8457 TID:47714544904512 NODE:000 Title: SQLP_DBCB *
* *
* Dump *
* File:/home/db2inst1/sqllib/db2dump/8457.303.000.dump.bin *
* *
* *
* 2010-10-25-09.10.44.536127-300 I141763E377 LEVEL: *
* Error *
* PID : 8457 TID : 47714544904512PROC : *
* db2sysc 0 *
* *
* INSTANCE: db2inst1 NODE : 000 DB : SAMPLE *
* *
* EDUID : 303 EDUNAME: db2loggr (SAMPLE) 0 *
* *
* FUNCTION: DB2 UDB, data protection services, sqlpgOpenCAL, *
* probe:120 *
* *
* MESSAGE : Retrieved failed with error -2146434659 *
* *
* *
* *
* 2010-10-25-09.10.44.536413-300 E142141E533 LEVEL: *
* Error *
* PID : 8457 TID : 47714544904512PROC : *
* *
* db2sysc 0 *
* *
* INSTANCE: db2inst1 NODE : 000 DB : SAMPLE *
* *
* EDUID : 303 EDUNAME: db2loggr (SAMPLE) 0 *
* *
* FUNCTION: DB2 UDB, data protection services, sqlpgOpenCAL, *
* probe:200 *
* *
* MESSAGE : ADM1552E DB2 is unable to open active log file *
* *
* "S0000309.LOG". This could be caused by problem in *
* retrieving the log file from archive. *
* DB2 will try again every 5 minutes. *
* *
* *
* *
* *
* This occurs during backward phase with logsecond set to -1 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.5 Fixpack 8 *
**************************************************************** |
| Local Fix: |
Move logs to the active log directory |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in V9.5 Fixpack 8 |
| Workaround |
Copy log files into active log directory |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.11.2010
15.07.2011
15.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
