SAP Knowledge Base Article - Preview

2495367 - SQL2413N Online backup is not allowed

Symptom

Schedule online backup from DB13 with option 'Backup_vendor'

Job logs shows below error
===================
26.06.2017 21:01:03 Backup_Vend:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
26.06.2017 21:01:03 Backup_Vend: Kernel Error ID:
26.06.2017 21:01:03 Backup_Vend: DB Error: Yes
26.06.2017 21:01:03 Backup_Vend: SQL Code: 2413-
26.06.2017 21:01:03 Backup_Vend: SQL Message: SQL2413N Online backup is not allowed because the dat
26.06.2017 21:01:03 Backup_Vend: abase is not recoverable or a backup pending condition is in effect ro
26.06.2017 21:01:03 Backup_Vend:w=1
26.06.2017 21:01:03 Backup_Vend: DB Object Exists: No
26.06.2017 21:01:03 Backup_Vend: Duplicated Key: No
26.06.2017 21:01:03 Backup_Vend: Internal Error: 1
26.06.2017 21:01:03 Backup_Vend: Invalid Cursor: No
26.06.2017 21:01:03 Backup_Vend: Unknown Connection: No
26.06.2017 21:01:03 Backup_Vend: Connection Closed: No
26.06.2017 21:01:03 Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 40
26.06.2017 21:01:03 Backup_Vend:terminated with error
26.06.2017 21:01:03 REASON=ADBC error
26.06.2017 21:01:03 Job finished

dbdiag.log will show errors like below:
===================

2020-01-01-01.01.01.890692-360 E7420070A996 LEVEL: Severe
PID : 35061832 TID : 73253 PROC : db2sysc 0
INSTANCE: db2sid NODE : 000 DB : SID
APPHDL : 0-1234 APPID: *LOCAL.db2sid.201110152606
AUTHID : SIDADM HOSTNAME: sidhostname
EDUID : 73253 EDUNAME: db2agent (SID) 0
FUNCTION: DB2 UDB, database utilities, sqlubInitCheck, probe:846
MESSAGE : SQL2413N Online backup is not allowed because the database is not
recoverable or a backup pending condition is in effect.

If logarchmeth1 has already been updated, you may also see
===================

MESSAGE : ZRC=0x801000A1=-2146434911=SQLP_BACKPEND
"Backup pending. Database has been made recoverable. Backup now required."
DIA8168C Backup pending for database .


Read more...

Environment

  • DB2 LUW 9.5 and above
  • DB2 LUW (Linux, Unix and Windows)

Product

SAP ERP 6.0

Keywords

LOGARCHMETH1, CX_SQL_EXCEPTION, CX_DB6_ADMINCMD, BACKUP DATABASE, CL_DB6_JOB_BACKUP, ADBC, offline, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.