on 12-19-2008 10:25 PM
Hello Experts,
I'm running a job Check Db and it is failing continuously.
Here is the log that I'm getting in SM37:
Job started
Step 001 started (program RSDBAJOB, variant &0000000000000, user ID BATCHUSER)
ABAP/4 processor: CONNE_IMPORT_WRONG_FIELD_TYPE
Job cancelled
I also have warnings in DB16:
Table: SAPR3.BSIS, value: 1310720 KB * 2 / PSAPBSISD (> 2088944/778224/313304/307184/122864 KB) # Segment can cause tablespace o
Table: SAPR3.ACCTIT, tablespace: PSAPACCTITD # Table or index in wrong tablespace
Table: SAPR3.ZSDCOOP # Table or index has no optimizer statistics
Operation: sdzmplea.tse, time: 2008-12-17 09.57.00 failed with rc = 4 # Last 'tse' operation failed with rc = 4
Operation: cdzkbhwh.chk, time: 2008-12-03 23.06.15 older than 10 days # Last successful 'chk' operation older than 10 days
Time: 2008-12-03 23.16.16, line: Checkpoint not complete
Value: 14505984 (>< 4096,512 KB) # Size of redo log buffer in bytes
Value: 20 (set in parameter file) # Optimizer index cost adjustment
Value: 0 (< 400 MB) # Size of Oracle shared pool
Value: TRUE (set in parameter file) # Maintain internal timing statistics
Can anybody tell me what the problem is and how to solve it.
Thanks in advance.
you have a lot of error messages. the fact that the job is failing is not related to the warnings in DB16.
*Table: SAPR3.BSIS, value: 1310720 KB * 2 / PSAPBSISD (> 2088944/778224/313304/307184/122864 KB) # Segment can cause tablespace o*
increase size of PSAPBSISD
Table: SAPR3.ACCTIT, tablespace: PSAPACCTITD # Table or index in wrong tablespace
supply contents of tables TAORA, IAORA and TSORA.
Table: SAPR3.ZSDCOOP # Table or index has no optimizer statistics
recalc DB stats from DB13 or run:
brconnect -c -u / -f stats -t missing
Operation: sdzmplea.tse, time: 2008-12-17 09.57.00 failed with rc = 4 # Last 'tse' operation failed with rc = 4
last time you tried to extend a tablespace , process failed.
Operation: cdzkbhwh.chk, time: 2008-12-03 23.06.15 older than 10 days # Last successful 'chk' operation older than 10 days
DBA job CHECKDB was not successful in over 10 days.
Time: 2008-12-03 23.16.16, line: Checkpoint not complete
search SAP notes about this one.
Value: 14505984 (>< 4096,512 KB) # Size of redo log buffer in bytes
check SAP note 830576
Value: 20 (set in parameter file) # Optimizer index cost adjustment
check SAP note 830576
Value: 0 (< 400 MB) # Size of Oracle shared pool
check SAP note 830576
Value: TRUE (set in parameter file) # Maintain internal timing statistics
check SAP note 830576
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.