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.