Skip to Content
0
Former Member
Mar 10, 2009 at 01:47 PM

DB2 backup on TAPE unsuccessfull

53 Views

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