|
Blue Forest http://www.lslnet.com at 11:08 on July 18, 2006
 DB2 V7.2+FP10 backup to TSM error happened!
I have two databases in one Instance. Both backup to TSM
DB1 's db cfg : Logretain=Recovery, Userexit=On, TrackMod=On
DB2 's db cfg : Logretain=Recovery, Userexit=Off, TrackMod=On
All DB1 and DB2 can do full backup online.
DB1 can be back-to TSM successfully and also LOG can be back-to TSM successfully. Delta DB1 can do incremental backup and incremental backup. DB1 can do full backup too.
DB2 can do full backup online too. DB2 's LOG was backup to HardDisk.
Coz that did 't do userexit.
"But When I do DB2 's incremental backup to TSM. It always fail. "
The attachment is db2diag.log. Hope someone who can know the error
Teach me how to do that Thx!
OS:WIN2K SERVER+SP4
DB2 : DB2 EE V7.2+FP10
RAM:4G
The following is db2diag.log=======
2003-11-03-10.50.12.756000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2640 Appid:*LOCAL.DB2.031103061516
Database_utilities sqlubcka Probe:0 Database:DB1
Starting an incremental delta database backup.
2003-11-03-10.51.26.959000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2640 Appid:*LOCAL.DB2.031103061516
Database_utilities sqlubcka Probe:0 Database:DB1
Backup Complete.
2003-11-03-10.57.25.146000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.031103061635
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental delta database backup.
2003-11-03-11.00.29.756000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2276 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-03-11.00.29.928000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2276 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-03-11.00.29.959000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.031103061635
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-03-11.00.29.975000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.031103061635
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-03-11.00.30.490000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2388 Appid:*LOCAL.DB2.031103061635
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-03-11.06.01.537000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2400 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental delta database backup.
2003-11-03-11.08.49.959000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2276 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-03-11.08.50.146000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2276 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-03-11.08.50.146001 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2400 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-03-11.08.50.178000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2400 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-03-11.08.50.725000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2400 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-03-11.21.48.678000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2680 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB1
Starting an incremental delta database backup.
2003-11-03-11.22.47.084000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2680 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB1
Backup Complete.
2003-11-03-11.24.38.365000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2584 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental database backup.
2003-11-03-11.27.20.209000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2696 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-03-11.27.20.459000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2696 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-03-11.27.20.490000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2584 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-03-11.27.20.506000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2584 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-03-11.27.21.021000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2584 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-03-11.29.49.100000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1852 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Starting a full database backup.
2003-11-03-11.42.21.943000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1852 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Backup Complete.
2003-11-03-11.49.07.178000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2712 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental delta database backup.
2003-11-03-11.55.46.568000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2696 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-03-11.55.46.709000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2696 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-03-11.55.46.725000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2712 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-03-11.55.46.740000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2712 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-03-11.55.47.459000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2712 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-03-11.58.17.584000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2412 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental database backup.
2003-11-03-12.05.56.803000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2308 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-03-12.05.56.959000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2308 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-03-12.05.56.975000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2412 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-03-12.05.56.990000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2412 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-03-12.05.57.959000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2412 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-03-12.10.33.068000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2720 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental database backup.
2003-11-03-12.10.33.131000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2404 Appid:none
Database_utilities sqluMCTestDevType4Backup Probe:60
Media device controller -- invalid path : F:\TEMP
2003-11-03-12.10.33.146000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2720 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
0cf8 ffff 463a 5c54 454d 5000. . . . F:\TEMP.
2003-11-03-12.10.33.162000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2720 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
0cf8 ffff. . . .
2003-11-03-12.10.33.287000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2720 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-03-12.10.37.662000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1608 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental database backup.
2003-11-03-12.17.43.506000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1608 Appid:*LOCAL.DB2.031103062725
Database_utilities sqlubcka Probe:0 Database:DB2
Backup Complete.
2003-11-03-13.15.22.100000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2136 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB1
Starting an incremental database backup.
2003-11-03-13.18.27.428000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2136 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB1
Backup Complete.
2003-11-03-13.56.46.396000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1964 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental database backup.
2003-11-03-13.59.30.850000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1980 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-03-13.59.31.021000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1980 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-03-13.59.31.021001 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1964 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-03-13.59.31.037000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1964 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-03-13.59.31.631000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:1964 Appid:*LOCAL.DB2.031103061832
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-04-00.30.01.709000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.031103163004
Database_utilities sqlubcka Probe:0 Database:DB1
Starting an incremental delta database backup.
2003-11-04-00.30.55.303000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2624 Appid:*LOCAL.DB2.031103163004
Database_utilities sqlubcka Probe:0 Database:DB1
Backup Complete.
2003-11-04-01.30.01.490000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2464 Appid:*LOCAL.DB2.031103173004
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental delta database backup.
2003-11-04-01.32.47.318000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2332 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-04-01.32.47.521000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2332 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-04-01.32.47.537000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2464 Appid:*LOCAL.DB2.031103173004
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-04-01.32.47.553000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2464 Appid:*LOCAL.DB2.031103173004
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-04-01.32.48.225000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2464 Appid:*LOCAL.DB2.031103173004
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated.
2003-11-05-00.30.01.649000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2288 Appid:*LOCAL.DB2.031104163004
Database_utilities sqlubcka Probe:0 Database:DB1
Starting an incremental database backup.
2003-11-05-00.31.22.133000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2288 Appid:*LOCAL.DB2.031104163004
Database_utilities sqlubcka Probe:0 Database:DB1
Backup Complete.
2003-11-05-01.30.01.899000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2608 Appid:*LOCAL.DB2.031104173005
Database_utilities sqlubcka Probe:0 Database:DB2
Starting an incremental database backup.
2003-11-05-01.32.37.336000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2540 Appid:none
Database_utilities sqluMapVend2MediaRCWithLog Probe:1
Error in line at Vendor Support Code : 1035. Rc : -50
2003-11-05-01.32.37.618000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2540 Appid:none
Database_utilities sqluMCWriteToDevice Probe:50
Media controller -- problem writing to vendor device. Rc = -2025
2003-11-05-01.32.37.618001 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2608 Appid:*LOCAL.DB2.031104173005
Database_utilities sqlubMWResponse Probe:5 Database:DB2
DiagData
Ffff 30ff 5453 17f8 2d35 4d00. . . . -50.TSM.
2003-11-05-01.32.37.649000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2608 Appid:*LOCAL.DB2.031104173005
Database_utilities sqlubMWResponse Probe:10 Database:DB2
DiagData
17f8 ffff. . . .
2003-11-05-01.32.38.165000 Instance:DB2 Node:000
PID:880 (db2syscs.exe) TID:2608 Appid:*LOCAL.DB2.031104173005
Database_utilities sqlubcka Probe:0 Database:DB2
Backup terminated. |
DB2 V7.2+FP10 backup to TSM error happened!
Secretary users padding is not the authority (the authority of tsm) |
DB2 V7.2+FP10 backup to TSM error happened!
But DB1 be made to complete backup and incremental backup
DB2 can be done only when absolutely do incremental backup when the backup will fail |
| |
