error while taking online backup

[former_member836181]

Hi,

ours is DB2 + suselinux 10.3 > ECC 6 ehp4

while i am trying to take online backup to disk from DB13, first i selected india in calender id & chose "backup to device",

i assigned Number of Buffers , Buffer Size 0 Pages, Parallelism 0, Priority 100

Device/Directory /99dump/HMD_15FEB11_ONLINE (my destination directory. but i am getting error. kindly help me.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000005, user ID HMBASIS)

Backup_Dev:Database Backup to Device

Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE on server HMDEVSOL

Backup_Dev:Parameter TESTMODE has not been set

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

Backup_Dev:Parameter COMPRESS has been set to ""

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 been set to "UTIL_IMPACT_PRIORITY 100"

Backup_Dev:Parameter FILE_PATH has been set to "/99dump/HMD_15FEB11_ONLINE"

Backup_Dev:Command ' BACKUP DATABASE HMD ON DBPARTITIONNUM (0 ) ONLINE TO"/99dump/HMD_15FEB11_ONLINE" UTIL_IMP

Backup_Dev:ACT_PRIORITY 100 INCLUDE LOGS '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 SSV_BACKUP

Backup_Dev:line 66

Backup_Dev: Kernel Error ID:

Backup_Dev: SYSID: HMD

Backup_Dev: SY-SUBRC: 1208

Backup_Dev: Message: ADBC error

Backup_Dev: Command:BACKUP DATABASEHMD ON DBPARTITIONNUM ( 0 ) ONLINE TO"/99dump

Backup_Dev: /HMD_15FEB11_ONLINE" UTIL_IMPACT_PRIORITY 100 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: 2413-

Backup_Dev: SQL Message: SQL2413N Online backup is not allowed because the dat

Backup_Dev: abase is not recoverable or a backup pending condition is in effect ro

Backup_Dev:w=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

[nirmal_konchada]

Hi,

It seems to be a new installation and if you have not activated archive logs then follow below steps :

Log in to your database server and issue the following commands:

db2 update db cfg for SID using LOGARCHMETH1 DISK:/db2/SID/log_archive

take a offline backup

Afterwards you have to restart the instance through db2stop force and db2start.

During the restart the log files are copied by DB2 to the log_archive

Regards,

Nirmal.K