mcb
Active Member
Hello List
Rollback segments are creating problems in R8903B11E and R8903B14E
These programs finishes with errors, on the JDE.LOG we can see
29752 Mon Jul 2 16:11:10 2001 dbfetch163
OCI0000056 - Unable to fetch - SELECT * FROM CRPDTA.F03B14 WHERE ( ( RZCO >= :KEY1 AND RZCO <= :KEY2 ) ) ORDER BY RZCO ASC,RZPYID ASC
29752 Mon Jul 2 16:11:10 2001 dbfetch169
OCI0000057 - Error - ORA-01555: snapshot too old: rollback segment number 3 with name "R03" too small
29752 Mon Jul 2 16:11:10 2001 jdb_drvm888
JDB9900172 - Failed to exeute db fetch
Our rollback segments are created correcly. They are setup as:
Number of segments=4
Size 400 MB aprox.
max of 500 extents of 1 MB each
It seems that we may have plenty of space for the conversion Jobs.
Have you encountered such situation??
Thanks.
Rollback segments are creating problems in R8903B11E and R8903B14E
These programs finishes with errors, on the JDE.LOG we can see
29752 Mon Jul 2 16:11:10 2001 dbfetch163
OCI0000056 - Unable to fetch - SELECT * FROM CRPDTA.F03B14 WHERE ( ( RZCO >= :KEY1 AND RZCO <= :KEY2 ) ) ORDER BY RZCO ASC,RZPYID ASC
29752 Mon Jul 2 16:11:10 2001 dbfetch169
OCI0000057 - Error - ORA-01555: snapshot too old: rollback segment number 3 with name "R03" too small
29752 Mon Jul 2 16:11:10 2001 jdb_drvm888
JDB9900172 - Failed to exeute db fetch
Our rollback segments are created correcly. They are setup as:
Number of segments=4
Size 400 MB aprox.
max of 500 extents of 1 MB each
It seems that we may have plenty of space for the conversion Jobs.
Have you encountered such situation??
Thanks.