ecc6 on windows 2003 db2 v9.1 ,db13 backup error

[Former Member]

Below is the log :

1.Step 001 started (program RSDBAJOB, variant &0000000000032, user ID SAP*)

2.Execute logical command DB6_DBBACKUP On host gwdb2ides

3.Parameters:C11 ONLINE TO

. ape0 BUFFERS 0 4.BUFFERSIZE 0 PARALLELISM 0 INCLUDE LOGS

5.set connect partition: 0

6.Initializing tape...

7.Command: "db2 initialize tape on

. ape0 using 1024"

8.DB21060E Ò»######Ï¡#

9.External program terminated with exit code 2

10.DB6_DBBACKUP returned error status E

Please check attachment . i check error code db21060E . it means block size error , tape is LTO-3 800-1600G .

how to do .thanks .....

[Former Member]

Hi,

we are also facing similar problem .this is bug of db2 v9.1.Pls upgrade to db2 9.5 or apply FP5 of 9.1.

This will solve u r offline backup from DB13.

You can take offline backup from db2 command line

db2 BACKUP DATABASE <dbsid> TO E:\backup

Thanks

Partha

[Former Member]

My db2 with FP5 . kernel new update .

I don't know how to do .

[Former Member]

Hello,

Can you try to initialize the tape with blocksize 4096. The only fixed block sizes DB2 supports are 512, 1024, 2048, and 4096.

Best Regards,

Adam

[former_member640873]

Hi Jun Jie,

Please refer to another thread:

[https://forums.sdn.sap.com/click.jspa?searchID=-1&messageID=5961595]

for a similar problem.

Regards,

[Former Member]

The same error message ,below is the screenshot

http://www.rongyj.com/er1.jpg

i check the full backup command is

dmdb6bkp C11 ONLINE TO
.\tape0 BUFFERS 0 BUFFERSIZE 0 PARALLELISM 0 INCLUDE LOGS

backup setting

http://www.rongyj.com/er2.jpg

and i can run dmdb6bkp c11 online to
.\tape0 in the db2cmd

Edited by: jun jie ruan on Sep 10, 2008 9:44 AM

[former_member640873]

Hi Jun Jie,

Do you see any error in sm50 or sm21? Is there any SQL error code? Have you tried running the backup through DB2 command line or Control Center?

Regards,

[Former Member]

>

> The same error message ,below is the screenshot 
> http://www.rongyj.com/er1.jpg
> i check the full backup command is 
> dmdb6bkp C11 ONLINE TO 
.\tape0 BUFFERS 0 BUFFERSIZE 0 PARALLELISM 0 INCLUDE LOGS
> 
> backup setting  
> http://www.rongyj.com/er2.jpg
> 
> and i can run dmdb6bkp c11 online to  
.\tape0  in the db2cmd
> 
> Edited by: jun jie ruan on Sep 10, 2008 9:44 AM

Just curious.. have you try to put buffersize 1024, as you init your tape with 1024 , to speed it put 2 buffer .