Symptom
Performing DB6CONV table conversion (using "Load -> Recoverable" option) on HADR primary triggers SQL2036N error on standby database, making the standby db inoperable with log replay stopped and tablespace stuck in RESTORE PENDING.
Here is the db2diag.log logging ->
2023-11-16-15.37.22.568761-300 E1040203E448 LEVEL: Error
PID : 10079 TID : 140062201210624 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000
HOSTNAME: hostname
EDUID : 820 EDUNAME: db2med.25.1 0
FUNCTION: DB2 UDB, database utilities, sqluMCCheckDevType, probe:181
MESSAGE : Media controller -- invalid device path:
/db2/PSE/log_archive/PSE.4.db2sid.DBPART000.20231116153719.001
2023-11-16-15.37.22.575881-300 E1040652E416 LEVEL: Error
PID : 10079 TID : 140062201210624 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000
HOSTNAME: hostname
EDUID : 820 EDUNAME: db2med.25.1 0
FUNCTION: DB2 UDB, database utilities, sqluMCCheckDevType, probe:181
MESSAGE : SQL2036N The path for the file, named pipe, or device "" is not valid.
2023-11-16-15.37.22.584082-300 I1041483E480 LEVEL: Error
PID : 10079 TID : 140064382248704 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-45382 APPID: *LOCAL.DB2.230902030305
HOSTNAME: hostname
EDUID : 25 EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag, probe:0
MESSAGE : state error , 31, 0x2, Detected in file:sqludcpy.C, Line:806
2023-11-16-15.37.32.626449-300 I1074356E506 LEVEL: Severe
PID : 10079 TID : 140064382248704 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-45382 APPID: *LOCAL.DB2.230902030305
HOSTNAME: hostname
EDUID : 25 EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, database utilities, sqludUpdateSqlca, probe:5459
MESSAGE : DIA0001E An internal error occurred. Report the following error code
: "".
2023-11-16-15.37.32.631987-300 E1098235E589 LEVEL: Error
PID : 10079 TID : 140064239642368 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-45382 APPID: *LOCAL.DB2.230902030305
HOSTNAME: hostname
EDUID : 817 EDUNAME: db2redom (SID) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSetPoolState, probe:202
MESSAGE : ADM12512W Log replay on the HADR standby has stopped on table space
"SID#BTAB" (ID "41") because it has been put into "RESTORE
PENDING" state.The standby reports log_archive path not found leaving tablespace SID#BTAB in restore pending state.
Read more...
Environment
- Netweaver AS ABAP any release
- IBM DB2 LUW (DB6) any release
Product
Keywords
SQL2036N , DB6CONV , HADR , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview