SAP Knowledge Base Article - Preview

3421149 - DB6CONV table conversion reports SQL2036N error on HADR standby database.

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

SAP ERP 6.0

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.