Troubleshooting
Problem
BACKUP, RESTORE or LOAD will fail with SQL2036N when the path is mapped as remote drive.
Symptom
Following error will be thrown when backup command is run:
$db2 backup db sample online to F:
SQL2036N The path for the file or device "<F:\>" is not valid."
db2diag.log shows the following error:
2012-02-09-11.01.33.499000+330 E92208862H491 LEVEL: Error
PID : 8812 TID : 10172 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-5429 APPID: *LOCAL.DB2.120209053132
AUTHID : ADMINISTRATOR
EDUID : 10172 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:875
MESSAGE : SQL2036N The path for the file or device "F:\" is not valid.
Cause
BACKUP, RESTORE and LOAD operations are performed specifying network share instead of fully qualified Universal Naming Convention (UNC) name.
Environment
Windows environment and the directory used for DB2 backup, restore or load is mapped as remote drive
Diagnosing The Problem
Check if a network share is used for DB2 backup, restore or load operations.
Resolving The Problem
Perform below steps:
1. Identify UNC name using windows command : "net use"
C:\Users\db2admin>net use
New connections will be remembered.
Status Local Remote Network
----------------------------------------------------------------------------
OK F:\ \\Backup\test Microsoft Windows Network
2. Once the UNC name is identified , re-run the failing command with the UNC name.
For Example : db2 backup db sample to \\ Backup\test
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21585018