Skip to Content
0
Former Member
Nov 25, 2008 at 10:18 AM

Backup of solution manger system on DB2 and windows.

80 Views

Hello Gurus,

I am new to this DB2 database. I have newly installed the Solution Manager 7.0 on windows 64 bit EE and DB2 V9.5 UDB. I am not able to take full backup by choosing the action 'Database Backup to Device'. I am also confused for what value to be entered for Number of Buffers,Buffer Size,Parallelism,Priority in Action details. I am getting the following error in Action log tab.

Message

Job started

Step 001 started (program RSDBAJOB, variant &0000000000000, user ID BASIS)

Backup_Dev:Database Backup to Device

Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE on server SOLMAN

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

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 "H:\BKUP_251108"

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 return code = 1.208

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

Backup_Dev: SY-SUBRC: 1208

Backup_Dev: Message: ADBC error

Backup_Dev: Command: BACKUP DATABASE SMS ONLINE TO"H:\BKUP_251108" COMPRESS INCL

Backup_Dev:UDE 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

Please suggest me what to to resolve this problem. Is there I need to set the perticular db parameters settings by changing default one. Also please tell me any special post installation activity required for DB2 database after installation unlike Oracle or SQL server.

Please Reply.