Backup errỏ

[former_member378357]

Hi all

Hi All

Im on Windows server 2008 R2 with DB2 Database. I have scheduled online backup from db13 but it ended with error, please help me.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000152, user ID DN-IT02)

Backup_Dev:Database Backup to Device

Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE       on server dianasap6

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 "INCREMENTAL"

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 "\\192.168.50.131\Backup\DIP"

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: DIP

Backup_Dev:  SY-SUBRC: 1208

Backup_Dev:  Message: ADBC error

Backup_Dev:  Command: BACKUP DATABASE DIP ON DBPARTITIONNUM ( 0 ) ONLINE INCREMEN

Backup_Dev:  TAL TO"\\192.168.50.131\Backup\DIP" 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: 2048-

Backup_Dev:  SQL Message: SQL2048N An error occurred while accessing object "DM

Backup_Dev:  S.TABLESPACE.DATA". Reason code: "5 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

[Former Member]

Hi Harry,

Same issue i am also facing ,but my issue got resolved by   :

Solution:

The object is db2rhist.asc, make sure that the db2rhist file is accessible by the instance owner.   (OR) db2rhist file may be corrupt. Move the existing file from its existing location, or delete it. DB2 will create a new db2rhist file the next time it needs to access it.

I had renamed the two files db2rhist.asc and db2rhist.bkp,

and i have scheduled online backup now they are finished successfully .. My issue got solved.

Regards,

Harish.

[former_member213250]

Hi James

I would say, you may need to run db2dart to check if any bad pages existing on your system.
Make sure that there aren't any bad pages on your DB. You can also check if you have any bad page errors on db2diag.log

Regards
Venkat

[Former Member]

Hello Harry,

IBM explains some solutions for that error code:

1-Recreating the corrupted table:

IBM DB2 Backup fails with SQL2048N RC 4 when the recovery history file is corrupted. - United States

2-Rename or move the corrupted history file:

IBM DB2 Backup fails with SQL2048N RC 4 when the recovery history file is corrupted. - United States

Have a look on those solutions.

Regards,

Serhat