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.