Symptom
- During a system refresh performed using backup restore with SWPM and when prompted to run the restore command by SWPM as per the example below
db2 restore database <SID> from <backup_filepath> TAKEN AT <backup_timestamp>, the following error is returned.
SQL2036N The path for the file, named pipe, or device"path" is not valid. - During a restore operation, the following errors are preventing the restore from commencing.
Examples seen in the db2diag.log
2019-01-01-00.00.00.483000+000 E9329F581 LEVEL: Error
PID : 6156 TID : 4640 PROC : db2syscs.exe
INSTANCE: DB2SID NODE : 000 DB : SID
APPHDL : 0-01 APPID: *LOCAL.DB2SID.191217151832
AUTHID : DB2SID HOSTNAME: hostname
EDUID : 4640 EDUNAME: db2med.5792.0 (SID) 0
FUNCTION: DB2 UDB, database utilities, sqluMCCheckDevType, probe:113
MESSAGE : Media controller -- invalid device path:
\dirhome\dir\SID.0.DB2SID.DBPART000.20190101010000
2019-01-01-00.00.00.483000+000 E9329F581 LEVEL: Error
PID : 6156 TID : 4640 PROC : db2syscs.exe
INSTANCE: DB2SID NODE : 000 DB : SID
APPHDL : 0-01 APPID: *LOCAL.DB2SID.191217151832
AUTHID : DB2SID HOSTNAME: hostname
EDUID : 4640 EDUNAME: db2med.5792.0 (SID) 0
FUNCTION: DB2 UDB, database utilities, sqluMCCheckDevType, probe:113
MESSAGE : SQL2036N The path for the file, named pipe, or device "" is not valid.
Read more...
Environment
Db2 LUW IBM
Keywords
System Copy, Migration, CLP, option, , KBA , BC-DB-DB6-DBA , Database Administration , 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