By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,025 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,025 IT Pros & Developers. It's quick & easy.

BACKUP TO SAMBA NETWORK DRIVE FAILS BUT THE FIRST TIME

P: n/a
I am trying to backup sample database to network drive J:\ which maps
to a SAMBA share.

The first time the backup is successfull but the the next time fails.
I've to delete J:\sample.0 if I want to backup again.

Here is the log:

[C:\]NET USE J: \\LINUXSERVER\BACKUPDB2
The command completed successfully.

[C:\]DB2 BACKUP DATABASE SAMPLE TO J:

Backup successful. The timestamp for this backup image is :
20060904191614
[C:\]DB2 BACKUP DATABASE SAMPLE TO J:
SQL2036N The path for the file or device "J:\" is not valid.

[C:\]NET USE J: \\LINUXSERVER\BACKUPDB2
The command completed successfully.

[C:\]DB2 BACKUP DATABASE SAMPLE TO J:

Backup successful. The timestamp for this backup image is :
20060904191614
[C:\]DB2 BACKUP DATABASE SAMPLE TO J:
SQL2036N The path for the file or device "J:\" is not valid.

[C:\]type c:\sqllib\db2\db2diag.log

2006-09-04-19.16.14.890000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Starting a full database backup.

2006-09-04-19.16.39.420000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Backup Complete.

2006-09-04-19.18.56.100000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Starting a full database backup.

2006-09-04-19.18.56.330000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:14 Appid:none
oper_system_services sqlomkdirp Probe:37

b700 0000 ....
2006-09-04-19.18.56.540000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:14 Appid:none
database_utilities sqluCreateBackupFile Probe:20

Media controller -- dos path error. path = J:\SAMPLE.0

2006-09-04-19.18.56.610000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:14 Appid:none
database_utilities sqluMCInitBackupMC Probe:80

Media controller -- device initialization warning

2006-09-04-19.18.56.610007 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubMWResponse Probe:5 Database:SAMPLE

DiagData
0cf8 ffff 4a3a 5c00 ....J:\.
2006-09-04-19.18.56.620000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubMWResponse Probe:10 Database:SAMPLE

DiagData
0cf8 ffff ....
2006-09-04-19.18.56.680000 Instance:DB2 Node:000
PID:388(DB2SYSC.EXE) TID:6 Appid:*LOCAL.DB2.060904171614
database_utilities sqlubcka Probe:0 Database:SAMPLE

Backup terminated.

Sep 4 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.