DB13 backup failed with ABCD error

[Former Member]

Hi All

Im on AIX with DB2 Database. I have scheduled online backup from db13 but it ended with error abcd.

Log

10.07.2012	11:30:51	Job started
10.07.2012	11:30:51	Step 001 started (program RSDBAJOB, variant &0000000000003, user ID AMIT)
10.07.2012	11:30:51	Backup_Dev:Database Backup to Device
10.07.2012	11:30:51	Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE       on server eccqa
10.07.2012	11:30:51	Backup_Dev:Parameter TESTMODE has not been set
10.07.2012	11:30:51	Backup_Dev:Parameter RUNTIME has not been set
10.07.2012	11:30:51	Backup_Dev:Parameter BACKUP_MODE has been set to "ONLINE"
10.07.2012	11:30:51	Backup_Dev:Parameter PARTITION has not been set
10.07.2012	11:30:51	Backup_Dev:Parameter BACKUP_TYPE has been set to ""
10.07.2012	11:30:51	Backup_Dev:Parameter COMPRESS has been set to "COMPRESS"
10.07.2012	11:30:51	Backup_Dev:Parameter INCLUDE LOGS has been set to "INCLUDE LOGS"
10.07.2012	11:30:51	Backup_Dev:Parameter NUMBER_BUFFERS has been set to " 0"
10.07.2012	11:30:51	Backup_Dev:Parameter BUFFER_SIZE has been set to " 0"
10.07.2012	11:30:51	Backup_Dev:Parameter PARALLELISM has been set to " 0"
10.07.2012	11:30:51	Backup_Dev:Parameter UTIL_IMPACT_PRIORITY has not been set
10.07.2012	11:30:51	Backup_Dev:Parameter FILE_PATH has been set to "/db2/GEQ/sapdata4/backup"
10.07.2012	11:30:58	Backup_Dev:Command ' BACKUP DATABASE GEQ ON DBPARTITIONNUM (0 ) ONLINE TO"/db2/GEQ/sapdata4/backup" COMPRESS I
10.07.2012	11:30:58	Backup_Dev:NCLUDE LOGS  'failed
10.07.2012	11:30:58	Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r
10.07.2012	11:30:58	Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 0
10.07.2012	11:30:58	Backup_Dev:  Kernel Error ID:
10.07.2012	11:30:58	Backup_Dev:  WP ID: 13
10.07.2012	11:30:58	Backup_Dev:  WP PID: 9764908
10.07.2012	11:30:58	Backup_Dev:SYSID:
10.07.2012	11:30:58	Backup_Dev:  SY-SUBRC: 1208
10.07.2012	11:30:58	Backup_Dev:  SY-TABIX: 0
10.07.2012	11:30:58	Backup_Dev:  Message: ADBC error
10.07.2012	11:30:58	Backup_Dev:  Database:
10.07.2012	11:30:58	Backup_Dev:caused by
10.07.2012	11:30:58	Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP
10.07.2012	11:30:58	Backup_Dev:line 59
10.07.2012	11:30:58	Backup_Dev:  Kernel Error ID:
10.07.2012	11:30:58	Backup_Dev:  WP ID: 13
10.07.2012	11:30:58	Backup_Dev:  WP PID: 9764908
10.07.2012	11:30:58	Backup_Dev:  SYSID: GEQ
10.07.2012	11:30:58	Backup_Dev:  SY-SUBRC: 1208
10.07.2012	11:30:58	Backup_Dev:  Message: ADBC error
10.07.2012	11:30:58	Backup_Dev:  Command:BACKUP DATABASEGEQ ON DBPARTITIONNUM ( 0 ) ONLINE TO"/db2/GE
10.07.2012	11:30:58	Backup_Dev:  Q/sapdata4/backup" COMPRESS INCLUDE LOGS
10.07.2012	11:30:58	Backup_Dev:  Database:
10.07.2012	11:30:58	Backup_Dev:caused by
10.07.2012	11:30:58	Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
10.07.2012	11:30:58	Backup_Dev:  Kernel Error ID:
10.07.2012	11:30:58	Backup_Dev:  DB Error: Yes
10.07.2012	11:30:58	Backup_Dev:  SQL Code: 2413-
10.07.2012	11:30:58	Backup_Dev:  SQL Message: SQL2413N Online backup is not allowed because the dat
10.07.2012	11:30:58	Backup_Dev:  abase is not recoverable or a backup pending condition is in effect ro
10.07.2012	11:30:58	Backup_Dev:w=1
10.07.2012	11:30:58	Backup_Dev:  DB Object Exists: No
10.07.2012	11:30:58	Backup_Dev:  Duplicated Key: No
10.07.2012	11:30:58	Backup_Dev:  Internal Error: 1
10.07.2012	11:30:58	Backup_Dev:  Invalid Cursor: No
10.07.2012	11:30:58	Backup_Dev:  Unknown Connection: No
10.07.2012	11:30:58	Backup_Dev:  Connection Closed: No
10.07.2012	11:30:58	Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method  line 40
10.07.2012	11:30:58	Backup_Dev:terminated with error
10.07.2012	11:30:58	REASON=ADBC error
10.07.2012	11:30:58	Job finished

SM21 Log

11:30:58 BTC  013 200 AMIT                BY  2 Database error -2413 at OPC

11:30:58 BTC  013 200 AMIT                BY  0 > SQL2413N Online backup is not allowed because the database

11:30:58 BTC  013 200 AMIT                BY  0 > is not recoverable or a backup pending condition is in effec

11:30:58 BTC  013 200 AMIT                BY  0 > row=1

11:30:58 BTC  013 200 AMIT                BY  1 Database error -2413

Can any one help me to solve this issue

[sunny_pahuja2 · Accepted solution]

Hi,

11:30:58 BTC  013 200 AMIT                BY  0 > SQL2413N Online backup is not allowed because the database

11:30:58 BTC  013 200 AMIT                BY  0 > is not recoverable or a backup pending condition is in effec

It looks you have activated archive log mode and after that you have not taken offline backup. Please schedule offline backup then system will come out of backup pending mode. After that you can schedule online backup.

Thanks

Sunny

[Former Member · Accepted solution]

Thank You Sunny,

Could you please tell me how can i take offline backup in db2. Im very new to db2. I have mounted tape to /dev/rmt0. Any command to use?

do i need to take the instance down? Will be happy if u can provide me detailed steps

Thanks in advance

[former_member189725 · Accepted solution]

No you do not need to bring the instance down

Login as db2<sid>

Issue the following command

db2 backup database <sid> to /dev/rmt0

This database manager  deactivate the database , take an offline backup and activate the database.

Regards

Ratnajit

[Former Member · Accepted solution]

Hi Ratnajit i have used the command

# su - db2geq

eccqa:db2geq 1> db2 backup database GEQ to /dev/rmt0

SQL1035N  The database is currently in use.  SQLSTATE=57019

[former_member189725 · Accepted solution]

Bring down the SAP system as geqadm.

stopsap r3

Then login as db2geq.

execute

db2 force application all.

Then take the backup.

Regards

Ratnajit

[former_member189725 · Accepted solution]

Once the backup starts , you can check the progress by issuing the command

db2 list utilities show detail

Regards

Ratnajit

[Former Member]

Hi Sunny and Ratnajit,

Thanks for the help. I have taken offline backup and its successful. After that i have scheduled online backup from db13 > database backup to device> Execute.

This online backup ended with same ABCD error.

Thanks for ur time...

[former_member189725]

This is because the database is in circular archiving mode.

You need to change the db2 database configuration parameter LOGARCHMETH1 to a location say for example /db2/<SID>/archive_log

Login as db2<sid>

db2 connect to <SID>

db2 UPDATE DB CFG FOR <SID> using LOGARCHMETH1 DISK:/db2/<SID>/archive_log

Then take an offline backup again as you did .

After the offline backup is done , then once the database comes up , it will start generating the archive logs in the location specified above and you can take online backup from now on.

Regards

Ratnajit

[Former Member]

eccqa:db2geq 3> db2 update db cfg for GEQ using logarchmeth1 /db2/GEQ/log_archive

SQL5099N  The value "/DB2/GEQ/LOG_ARCHIVE" indicated by the database

configuration parameter "LOGARCHMETH1" is not valid, reason code "16".

SQLSTATE=08004

[former_member189725]

db2 update db cfg for GEQ using logarchmeth1 DISK:/db2/GEQ/log_archive

Please ensure the directory /db2/GEQ/log_archive has enough space to hold archive logs.

Regards

Ratnajit

[sunny_pahuja2]

Hi,

Please check first whether LOGARCHMETH1 is set or not because earlier your database was in backup pending mode and it generally happens when you change archive log path.

Please also make sure that block size on your tape should not be zero because db2 does not support variable block size.

Thanks

Sunny