Database Backup Finished with ADBC error, How to solve this issue?

[former_member222381]

Dear Experts,

Please suggest me as our production server Database backup has finished with ADBC error.

10.10.2015	14:28:01	Job started
10.10.2015	14:28:01	Step 001 started (program RSDBAJOB, variant &0000000001023, user ID XIPADM)
10.10.2015	14:28:03	Backup_Dev:Database Backup to Device
10.10.2015	14:28:03	Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE       on server XSLKSPRD
10.10.2015	14:28:03	Backup_Dev:Parameter TESTMODE has not been set
10.10.2015	14:28:03	Backup_Dev:Parameter RUNTIME has not been set
10.10.2015	14:28:03	Backup_Dev:Parameter BACKUP_MODE has been set to "ONLINE"
10.10.2015	14:28:03	Backup_Dev:Parameter PARTITION has not been set
10.10.2015	14:28:03	Backup_Dev:Parameter BACKUP_TYPE has been set to ""
10.10.2015	14:28:03	Backup_Dev:Parameter COMPRESS has been set to ""
10.10.2015	14:28:03	Backup_Dev:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS"
10.10.2015	14:28:03	Backup_Dev:Parameter NUMBER_BUFFERS has been set to " 0"
10.10.2015	14:28:03	Backup_Dev:Parameter BUFFER_SIZE has been set to " 0"
10.10.2015	14:28:03	Backup_Dev:Parameter PARALLELISM has been set to " 0"
10.10.2015	14:28:03	Backup_Dev:Parameter UTIL_IMPACT_PRIORITY has not been set
10.10.2015	14:28:03	Backup_Dev:Parameter FILE_PATH has been set to "J:\Daily_Backup"
10.10.2015	14:28:16	Backup_Dev:Command ' BACKUP DATABASE XIP ON DBPARTITIONNUM (0 ) ONLINE TO"J:\Daily_Backup" INCLUDE LOGS 'fail
10.10.2015	14:28:16	Backup_Dev:ed
10.10.2015	14:28:16	Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r
10.10.2015	14:28:16	Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP
10.10.2015	14:28:16	Backup_Dev:  Kernel Error ID:
10.10.2015	14:28:16	Backup_Dev:SYSID:
10.10.2015	14:28:16	Backup_Dev:  SY-SUBRC: 1208
10.10.2015	14:28:16	Backup_Dev:  SY-TABIX: 0
10.10.2015	14:28:16	Backup_Dev:  Message: ADBC error
10.10.2015	14:28:16	Backup_Dev:  Database:
10.10.2015	14:28:16	Backup_Dev:caused by
10.10.2015	14:28:16	Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP
10.10.2015	14:28:16	Backup_Dev:line 66
10.10.2015	14:28:16	Backup_Dev:  Kernel Error ID:
10.10.2015	14:28:16	Backup_Dev:  SYSID: XIP
10.10.2015	14:28:16	Backup_Dev:  SY-SUBRC: 1208
10.10.2015	14:28:16	Backup_Dev:  Message: ADBC error
10.10.2015	14:28:16	Backup_Dev:  Command:BACKUP DATABASEXIP ON DBPARTITIONNUM ( 0 ) ONLINE TO"J:\Dail
10.10.2015	14:28:16	Backup_Dev:  y_Backup" INCLUDE LOGS
10.10.2015	14:28:16	Backup_Dev:  Database:
10.10.2015	14:28:16	Backup_Dev:caused by
10.10.2015	14:28:16	Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
10.10.2015	14:28:16	Backup_Dev:  Kernel Error ID:
10.10.2015	14:28:16	Backup_Dev:  DB Error: Yes
10.10.2015	14:28:16	Backup_Dev:  SQL Code: 2048-
10.10.2015	14:28:16	Backup_Dev:  SQL Message: SQL2048N An error occurred while accessing object "0"
10.10.2015	14:28:16	Backup_Dev:  . Reason code: "6 row=1
10.10.2015	14:28:16	Backup_Dev:  DB Object Exists: No
10.10.2015	14:28:16	Backup_Dev:  Duplicated Key:No
10.10.2015	14:28:16	Backup_Dev:  Internal Error: 1
10.10.2015	14:28:16	Backup_Dev:  Invalid Cursor: No
10.10.2015	14:28:16	Backup_Dev:  Unknown Connection: No
10.10.2015	14:28:16	Backup_Dev:  Connection Closed: No
10.10.2015	14:28:16	Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method  line 40
10.10.2015	14:28:16	Backup_Dev:terminated with error
10.10.2015	14:28:16	REASON=ADBC error
10.10.2015	14:28:16	Job finished

Please suggest me step by step, Need to solve the issue.

DB2 is DB,

Regards

Rajkumar R

[former_member222381]

Thank You  So much issue is solved by moving and deleting history file.

Regards

Rajkumar R

[maria_shen]

Hello Rajkumar,

As per IBM info center , SQL2048N with RC =6:

This message is returned with reason code 6 when a table space cannot be accessed for one of multiple reasons, including the following reasons:

o The state of the table space does not support the type of access attempt. Some examples of database states that can prevent some types of database access include: quiesced, offline, and backup in progress.
 
o One or more of the table space containers are not available

Therefore, please check the state of the tablespace 0. You can use command:
db2 get snapshot for tablespaces on <db2sid> > snap_tbs.out

Kind regards
Maria

[Former Member]

Hi Rajkumar,

check below SAP Note may it will help you.?

2158234 - Backup taken using the DBA Planning Calendar in transaction DBACOCKPIT finishes with error...

Regards

[Former Member]

Hello Rajkumar,

For sqlcode error 2048- explanation and probable causes refer below link

IBM Knowledge Center

Also check db2diag.log for detail error .

Below SDN link state your issue ,please check if it works for you.

backup failed in DB6 | SCN

Br, Vaibhav

[Former Member]

Dear Rajkumar

Please check Your DB2 history file is corupted just move it to another location

Regards

Lukasz Krupa