If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL0902C A system error (reason code = "119") occurre

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-30-09, 05:26
manikandank_1984 manikandank_1984 is offline
Registered User
 
Join Date: Oct 2008
Posts: 65
SQL0902C A system error (reason code = "119") occurre

Hi,

I try to take onlone backup it gets failed.I given the job log below.

Job started
Step 001 started (program RSDBAJOB, variant &0000000000009, user ID IBM_BASIS)
Backup_Devatabase Backup to Device
Backup_Dev:started by CL_DB6_JOB_BACKUP_DEVICE on server xxxxbwp
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 "/db2/BWP/sapbackup"
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_DevYSID:
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: BWP
Backup_Dev: SY-SUBRC: 1208
Backup_Dev: Message: ADBC error
Backup_Dev: Command: BACKUP DATABASE BWP ONLINE TO"/db2/sid/sapbackup" COMPRESS
Backup_Dev: INCLUDE LOGS
Backup_Dev: Database:
Backup_Dev:caused by
Backup_Dev:Exception CX_SQL_EXCEPTION inclass CL_SQL_STATEMENT
Backup_Dev: Kernel ErrorID:
Backup_Dev: DB Error: Yes
Backup_Dev: SQL Code: 902-
Backup_Dev: SQL Message: SQL0902C A system error (reason code = "119") occurre
Backup_Dev: d. Subsequent SQL statements cannot be processed. SQLSTATE=58005 row
Backup_Dev:=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

Regards,
Javith
Reply With Quote
  #2 (permalink)  
Old 04-03-09, 05:09
sgmane sgmane is offline
Registered User
 
Join Date: Jul 2005
Posts: 19
Did you check the log/trace files?
Do post the information about the same.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On