468,288 Members | 1,968 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,288 developers. It's quick & easy.

BACKUP TO SAMBA NETWORK DRIVE FAILS BUT THE FIRST TIME

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
0 2891

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Przemo Drochomirecki | last post: by
3 posts views Thread by Ray Lavelle | last post: by
2 posts views Thread by nt | last post: by
2 posts views Thread by Damn fool | last post: by
9 posts views Thread by gabe101 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.