Skip to Content
0

DB2 backup error SQL2036N Thepath for the file, named pipe, or device

Apr 28, 2017 at 01:37 PM

157

avatar image

Hi experts,

i am not able to take db2 backup on remote mapped network folder in windows 2012.

i can take backup on local drive without an error.

getting below error while taking backup on shared network folder. ( NAS Box )

pls help me out.

27.04.2017 11:16:50 Job started 27.04.2017 11:16:50 Step 001 started (program RSDBAJOB, variant &0000000000049, user ID BASIS) 27.04.2017 11:16:50 Backup_Dev:Database Backup to Device 27.04.2017 11:16:50 Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE for system PRD on server NHB-PRD2 27.04.2017 11:16:50 Backup_Dev:Database connection +++DB6ADM established successfully 27.04.2017 11:16:50 Backup_Dev:Parameter TESTMODE has not been set 27.04.2017 11:16:50 Backup_Dev:Parameter RUNTIME has not been set 27.04.2017 11:16:50 Backup_Dev:Parameter BACKUP_MODE has been set to "ONLINE" 27.04.2017 11:16:50 Backup_Dev:Parameter PARTITION has not been set 27.04.2017 11:16:50 Backup_Dev:Parameter BACKUP_TYPE has been set to "" 27.04.2017 11:16:50 Backup_Dev:Parameter COMPRESS has been set to "COMPRESS" 27.04.2017 11:16:50 Backup_Dev:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS" 27.04.2017 11:16:50 Backup_Dev:Parameter NUMBER_BUFFERS has been set to " 2" 27.04.2017 11:16:50 Backup_Dev:Parameter BUFFER_SIZE has been set to " 1024" 27.04.2017 11:16:50 Backup_Dev:Parameter PARALLELISM has been set to " 2" 27.04.2017 11:16:50 Backup_Dev:Parameter UTIL_IMPACT_PRIORITY has not been set 27.04.2017 11:16:50 Backup_Dev:Parameter DEDUP_DEVICE has not been set 27.04.2017 11:16:50 Backup_Dev:Parameter FILE_PATH has been set to "S:\BACKUP" 27.04.2017 11:16:52 Backup_Dev:Command ' BACKUP DATABASE PRD ON DBPARTITIONNUM (0 ) ONLINE TO"S:\BACKUP" WITH 2 BUFFERS BUFFER 10 27.04.2017 11:16:52 Backup_Dev:24 PARALLELISM 2 COMPRESS INCLUDE LOGS 'failed 27.04.2017 11:16:52 Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r 27.04.2017 11:16:52 Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 0 27.04.2017 11:16:52 Backup_Dev: Kernel Error ID: 27.04.2017 11:16:52 Backup_Dev: WP ID: 11 27.04.2017 11:16:52 Backup_Dev: WP PID: 7256 27.04.2017 11:16:52 Backup_Dev: Application Server: NHB-PRD2 27.04.2017 11:16:52 Backup_Dev:SYSID: 27.04.2017 11:16:52 Backup_Dev: SY-SUBRC: 1208 27.04.2017 11:16:52 Backup_Dev: SY-TABIX: 0 27.04.2017 11:16:52 Backup_Dev: Message: ADBC error 27.04.2017 11:16:52 Backup_Dev: Database: 27.04.2017 11:16:52 Backup_Dev:caused by 27.04.2017 11:16:52 Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP 27.04.2017 11:16:52 Backup_Dev:line 59 27.04.2017 11:16:52 Backup_Dev: Kernel Error ID: 27.04.2017 11:16:52 Backup_Dev: WP ID: 11 27.04.2017 11:16:52 Backup_Dev: WP PID: 7256 27.04.2017 11:16:52 Backup_Dev: Application Server: NHB-PRD2 27.04.2017 11:16:52 Backup_Dev: SYSID: PRD 27.04.2017 11:16:52 Backup_Dev: SY-SUBRC: 1208 27.04.2017 11:16:52 Backup_Dev: Message: ADBC error 27.04.2017 11:16:52 Backup_Dev: Command: BACKUP DATABASE PRD ON DBPARTITIONNUM ( 0 ) ONLINE TO"S:\BA 27.04.2017 11:16:52 Backup_Dev: CKUP" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 2 COMPRESS INCLUDE LOG 27.04.2017 11:16:52 Backup_Dev:S 27.04.2017 11:16:52 Backup_Dev: Database: +++DB6ADM 27.04.2017 11:16:52 Backup_Dev:caused by 27.04.2017 11:16:52 Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT 27.04.2017 11:16:52 Backup_Dev: Kernel Error ID: 27.04.2017 11:16:52 Backup_Dev: DB Error: Yes 27.04.2017 11:16:52 Backup_Dev: SQL Code: 2036- 27.04.2017 11:16:52 Backup_Dev: SQL Message: SQL2036N Thepath for the file, named pipe, or device 27.04.2017 11:16:52 Backup_Dev: "S:\BACKUP" is not valid row=1 27.04.2017 11:16:52 Backup_Dev: DB Object Exists: No 27.04.2017 11:16:52 Backup_Dev: DuplicatedKey: No 27.04.2017 11:16:52 Backup_Dev: Internal Error: 1 27.04.2017 11:16:52 Backup_Dev: Invalid Cursor: No 27.04.2017 11:16:52 Backup_Dev: Unknown Connection: No 27.04.2017 11:16:52 Backup_Dev: Connection Closed: No 27.04.2017 11:16:52 Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 41 27.04.2017 11:16:52 Backup_Dev:terminated with error 27.04.2017 11:16:52 REASON=ADBC error 27.04.2017 11:16:52 Job finished

Thanks

Anteshwar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Olaf Balzer
May 02, 2017 at 05:27 AM
0

Hello Anteshwar,

which release youre using.

In some former releases it wasnt allowed you use non UNC pathes in backup command. So please find out what the unc path name for your S:\BACKUP" is and use this in your command. Use the command "net use" to find the right path name.

Regards

Olaf

Share
10 |10000 characters needed characters left characters exceeded