DB2 backup on TAPE unsuccessfull

[Former Member]

Dear Expertise,

I can perform my full database backup on Hard disk and sometimes on TAPE successfully. My archive log backup is successful everytime on TAPE. Maximum times my database backup gets failed on TAPE following is the log. please guide me.

"""""""""""""""""""'""

Job started

Step 001 started (program RSDBAJOB, variant &0000000000076, user ID JOHNSON)

Backup_Dev:Database Backup to Device

Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE on server devecc6

Backup_Dev:Parameter TESTMODE has not been set

Backup_Dev:Parameter PARALLELISM has been set to " 0"

Backup_Dev:Parameter RUNTIME has not been set

Backup_Dev:Parameter BACKUP_MODE has been set to "ONLINE"

Backup_Dev:Parameter PARTITION has not been set

Backup_Dev:Parameter BACKUP_TYPE has been set to ""

Backup_Dev:Parameter COMPRESS has been set to ""

Backup_Dev:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS"

Backup_Dev:Parameter NUMBER_BUFFERS has been set to " 0"

Backup_Dev:Parameter BUFFER_SIZE has been set to " 0"

Backup_Dev:Parameter PARALLELISM has been set to " 0"

Backup_Dev:Parameter UTIL_IMPACT_PRIORITY has not been set

Backup_Dev:Parameter FILE_PATH has been set to "
.\tape0"

Backup_Dev:Command ' 'failed

Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r

Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP

Backup_Dev: Kernel Error ID:

Backup_Dev:SYSID:

Backup_Dev: SY-SUBRC: 1208

Backup_Dev: SY-TABIX: 0

Backup_Dev: Message: ADBC error

Backup_Dev: Database:

Backup_Dev:caused by

Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method EXECUTE_CM

Backup_Dev: D line 43

Backup_Dev: Kernel Error ID:

Backup_Dev: SYSID: DEC

Backup_Dev: SY-SUBRC: 1208

Backup_Dev: Message: ADBC error

Backup_Dev: Command: BACKUP DATABASE DEC ONLINE TO"
.\tape0" INCLUDE LOGS

Backup_Dev: Database:

Backup_Dev:caused by

Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT

Backup_Dev: Kernel Error ID:

Backup_Dev: DB Error: Yes

Backup_Dev: SQL Code: 2035-

Backup_Dev: SQL Message: SQL2035N Thewarning condition "2045" was encountered

Backup_Dev: while executing the utility in non-interrupt mode row=1

Backup_Dev: DB Object Exists: No

Backup_Dev: Duplicated Key: No

Backup_Dev: Internal Error: 1

Backup_Dev: Invalid Cursor: No

Backup_Dev: Unknown Connection: No

Backup_Dev: Connection Closed: No

Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 40

Backup_Dev:terminated with error

REASON=ADBC error

Job finished

"""""""""""""""""""""

Thanks in advance,

Ravindra

[Former Member]

Hi

I am facing the same problem

I am using IBM/DB2 ver 9.1 as database and windows 2003 Std 64bit R2 edition

How to initialize the tape device in DB2

I run command DB2 INITIALIZE TAPE on
.\tape0 using 4096

but it is giving error sqlstate : 42601

can u please tell me step by step

because i am very new in DB2 i don't know any thing about using DB2

and also tell me step by step offline backup in DB2 procedure

Kindly help me

Thanks & Regards,

Saket

[paul_power]

Hi,

Does it suceed if you use:

db2 initialize tape using 4096

then proceed with the backup command to
.\tape0

Regards,

Paul

[Former Member]

Hi Ravindra,

in DB2 which version you are using?

Archive on tape will do easily from db13.

but for online backup you have to first initialize tape with block size 4096

using following command

db2 INITIALIZE TAPE on
.\tape0 using 4096

then db13 give block size as 4096

and device path as
.\tape0

hope it will help you

Regards,

Nitin Salunkhe

[Former Member]

Hi Nitin,

Thank you for giving fast response.

It working perfectly fine.

Can you please tell me how can i set my default block size to 4096 or i have to enter it every time before backup.

Thanks and regards,

Ravindra

Edited by: Ravindra Bade on Mar 11, 2009 7:54 AM

[Former Member]

How to initialize tape when working on UNIX platform?

[paul_power]

Hi,

The initialize command is only valid on Windows systems.

Please see

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.

ibm.db2.udb.admin.doc/doc/r0002033.htm

regards,

Paul