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.