DB2 Online Backup failed with ABCD Error
Error Log
Job started
Step 001 started (program RSDBAJOB, variant &0000000000005, user ID AMIT)
Backup_Dev:Database Backup to Device
Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE on server eccqa
Backup_Dev:Parameter TESTMODE has not been set
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 "COMPRESS"
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 "/dev/rmt0"
Backup_Dev:Command ' BACKUP DATABASE GEQ ON DBPARTITIONNUM (0 ) ONLINE TO"/dev/rmt0" COMPRESS INCLUDE LOGS 'f
Backup_Dev:ailed
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 method line 0
Backup_Dev: Kernel Error ID:
Backup_Dev: WP ID: 12
Backup_Dev: WP PID: 9633896
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 SSV_BACKUP
Backup_Dev:line 59
Backup_Dev: Kernel Error ID:
Backup_Dev: WP ID: 12
Backup_Dev: WP PID: 9633896
Backup_Dev: SYSID: GEQ
Backup_Dev: SY-SUBRC: 1208
Backup_Dev: Message: ADBC error
Backup_Dev: Command:BACKUP DATABASEGEQ ON DBPARTITIONNUM ( 0 ) ONLINE TO"/dev/rm
Backup_Dev: t0" COMPRESS 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: 2413-
Backup_Dev: SQL Message: SQL2413N Online backup is not allowed because the dat
Backup_Dev: abase is not recoverable or a backup pending condition is in effect ro
Backup_Dev:w=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
Solution
This error was causing due to achlog method. In DB2 after changing archive log method you have to take offline backup else sub sequent online backups are failed.
Find any pending jobs are terminated with out complete
DB2 LIST APPLICATIONS FOR DATABASE SID SHOW DETAIL
terminate all pending backups
DB2 FORCE APPLICATION ALL
brdb6brt
trigger offline backup from command prompt
db2 backup db <SID> to <path- tape address/file system path) compress
db2 UPDATE DB CFG FOR <SID> using LOGARCHMETH1 DISK:/db2/<SID>/archive_log
Procedure of backup
stopsap r3
Login as db2<sid>
db2 backup database <sid> to /dev/rmt0
Monitor backup using command
db2 list utilities show detail
Links useful
Facebook
0 comments:
Post a Comment