snapshot too old

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pxraja
Participant
Posts: 142
Joined: Fri Mar 14, 2008 10:22 am

snapshot too old

Post by pxraja »

Hi all,

my job got aborted and the log view is given below,

.Transformer_2.DSLink7: DSD.BCIGetNext call to SQLFetch failed.

SQLSTATE=S1000, DBMS.CODE=1555
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small

please give suggestions on how to resolve this issue.

thanks in advance
Top
Ultramundane
Participant
Posts: 407
Joined: Mon Jun 27, 2005 8:54 am
Location: Walker, Michigan
Contact:
Contact Ultramundane

Re: snapshot too old

Post by Ultramundane »

pxraja wrote:Hi all,

my job got aborted and the log view is given below,

.Transformer_2.DSLink7: DSD.BCIGetNext call to SQLFetch failed.

SQLSTATE=S1000, DBMS.CODE=1555
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8$" too small

please give suggestions on how to resolve this issue.

thanks in advance
Contact your Oracle DBA and have them increase the rollback segment for your database and or seek their advice if they want other.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes, definitely chat with your DBA. How long did the job run before it blew? How busy was the database with other processes at the time it was running?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”