Online Full & Incremental backup's are getting failed

[Former Member]

Hi friends,

when i am scheduling backups on db13 i am getting this error, please check this log and help me where is the issue ( os-Windows , DB2, )

01.02.2015    16:00:13    Job started

01.02.2015    16:00:13    Step 001 started (program RSDBAJOB, variant &0000000000033, user ID BASIS)

01.02.2015    16:00:14    Backup_Dev:Database Backup to Device

01.02.2015    16:00:14    Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE       on server ajaxcrm1

01.02.2015    16:00:14    Backup_Dev:Database connection +++DB6ADM established successfully

01.02.2015    16:00:16    Backup_Dev:Parameter TESTMODE has not been set

01.02.2015    16:00:16    Backup_Dev:Parameter RUNTIME has not been set

01.02.2015    16:00:16    Backup_Dev:Parameter BACKUP_MODE has been set to "ONLINE"

01.02.2015    16:00:16    Backup_Dev:Parameter PARTITION has not been set

01.02.2015    16:00:16    Backup_Dev:Parameter BACKUP_TYPE has been set to ""

01.02.2015    16:00:16    Backup_Dev:Parameter COMPRESS has been set to "COMPRESS"

01.02.2015    16:00:16    Backup_Dev:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS"

01.02.2015    16:00:16    Backup_Dev:Parameter NUMBER_BUFFERS has been set to " 0"

01.02.2015    16:00:16    Backup_Dev:Parameter BUFFER_SIZE has been set to " 0"

01.02.2015    16:00:16    Backup_Dev:Parameter PARALLELISM has been set to " 0"

01.02.2015    16:00:16    Backup_Dev:Parameter UTIL_IMPACT_PRIORITY has not been set

01.02.2015    16:00:16    Backup_Dev:Parameter FILE_PATH has been set to "D:\full_bkp"

01.02.2015    16:00:18    Backup_Dev:Command ' BACKUP DATABASE ACP ON DBPARTITIONNUM (0 ) ONLINE TO"D:\full_bkp" COMPRESS INCLUDE LOGS

01.02.2015    16:00:18    Backup_Dev:'failed

01.02.2015    16:00:18    Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r

01.02.2015    16:00:18    Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 0

01.02.2015    16:00:18    Backup_Dev:  Kernel Error ID:

01.02.2015    16:00:18    Backup_Dev:  WP ID: 25

01.02.2015    16:00:18    Backup_Dev:  WP PID: 5504

01.02.2015    16:00:18    Backup_Dev:SYSID:

01.02.2015    16:00:18    Backup_Dev:  SY-SUBRC: 1208

01.02.2015    16:00:18    Backup_Dev:  SY-TABIX: 0

01.02.2015    16:00:18    Backup_Dev:  Message: ADBC error

01.02.2015    16:00:18    Backup_Dev:  Database:

01.02.2015    16:00:18    Backup_Dev:caused by

01.02.2015    16:00:18    Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP

01.02.2015    16:00:18    Backup_Dev:line 59

01.02.2015    16:00:18    Backup_Dev:  Kernel Error ID:

01.02.2015    16:00:18    Backup_Dev:  WP ID: 25

01.02.2015    16:00:18    Backup_Dev:  WP PID: 5504

01.02.2015    16:00:18    Backup_Dev:  SYSID: ACP

01.02.2015    16:00:18    Backup_Dev:  SY-SUBRC: 1208

01.02.2015    16:00:18    Backup_Dev:  Message: ADBC error

01.02.2015    16:00:18    Backup_Dev:  Command: BACKUP DATABASEACP ON DBPARTITIONNUM (0 ) ONLINE TO"D:\ful

01.02.2015    16:00:18    Backup_Dev:  l_bkp" COMPRESS INCLUDE LOGS

01.02.2015    16:00:18    Backup_Dev:  Database: +++DB6ADM

01.02.2015    16:00:18    Backup_Dev:caused by

01.02.2015    16:00:18    Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT

01.02.2015    16:00:18    Backup_Dev:  Kernel Error ID:

01.02.2015    16:00:18    Backup_Dev:  DB Error: Yes

01.02.2015    16:00:18    Backup_Dev:  SQL Code: 2048-

01.02.2015    16:00:18    Backup_Dev:  SQL Message: SQL2048N An error occurred while accessing object "0"

01.02.2015    16:00:18    Backup_Dev:  . Reason code: "6 row=1

01.02.2015    16:00:18    Backup_Dev:  DB Object Exists: No

01.02.2015    16:00:18    Backup_Dev:  Duplicated Key:No

01.02.2015    16:00:18    Backup_Dev:  Internal Error: 1

01.02.2015    16:00:18    Backup_Dev:  Invalid Cursor: No

01.02.2015    16:00:18    Backup_Dev:  Unknown Connection: No

01.02.2015    16:00:18    Backup_Dev:  Connection Closed: No

01.02.2015    16:00:18    Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method  line 40

01.02.2015    16:00:18    Backup_Dev:terminated with error

01.02.2015    16:00:18    REASON=ADBC error

01.02.2015    16:00:18    Job finished

Regards,

Harish.ankam

[Former Member · Accepted solution]

Hi friends,

I have taken offline backup and next day i have scheduled online backups now they are successfull.

Thanks,

Harish

[Former Member · Accepted solution]

Hi Harish,

Could you please share how did you resolve the problem, what fix worked for you?

It will help us all to resolve similar problem in future.

Thanks

[Former Member · Accepted solution]

Hi Sharma,

My backups got failed due to previous online backups are in pending status,.so i had taken offline backup and once i restarted the instance .then i scheduled online backups now they are fine.

Regards,

Harish

[Former Member]

Hi,

I like to point out the below log lines. Could  you check if the target path is mounted and all the tablespaces of the system are in online status.

--------------------------------------------------------------------------------------

01.02.2015    16:00:18    Backup_Dev:  SY-SUBRC: 1208

01.02.2015    16:00:18    Backup_Dev:  Message: ADBC error

01.02.2015    16:00:18    Backup_Dev:  Command: BACKUP DATABASEACP ON DBPARTITIONNUM (0 ) ONLINE TO"D:\ful

01.02.2015    16:00:18    Backup_Dev:  SQL Code: 2048-

01.02.2015    16:00:18    Backup_Dev:  SQL Message: SQL2048N An error occurred while accessing object "0"

01.02.2015    16:00:18    Backup_Dev:  . Reason code: "6 row=1

01.02.2015    16:00:18    Backup_Dev:  DB Object Exists: No

01.02.2015    16:00:18    Backup_Dev:  Duplicated Key:No

--------------------------------------------------------------------------------------

RC 6 means its related to table space. please check the below link for the error code details

_http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.messages.sql.doc/doc/msql...

Regards,

Nikhil

[former_member182657]

Hi,

Have you followed SAP KBA which i mentioned earlier in my reply ? if possible try to import SPS 14 into your SAP system and retry the process.

Hope this will help you.

Regards,

[former_member182657]

Hi,

Could you share DB2 version ? Also you're using compress method

Backup_Dev:Parameter COMPRESS has been set to "COMPRESS"

For that i would suggest you to follow SAP KBA  1074866 - DB6: COMPRESS option not working in DB13 backup job

Regards,

[Former Member]

database is DB9.7...

Thanks for reply ..

[manumohandas82]

Hi Ankam ,

Have you tried a full online backup from the command line . If not try the same and let us know the results

Thanks ,

Manu

[Former Member]

Hi Manu,

i am trying offline backup then i will try online backup and i will let you know the result.

Thanks,

Harish

[Former Member]

Is there any other backup running...?... did u tried it again ..?

[Former Member]

last week  also i scheduled , they are successfull . but past 3days they are getting failed .no backups are running . after getting backups failed once again i rescheduled then also they got failed