DSXchange

Hi,

Best Practice question? If the Oracle database connected to Datstage is recycled, should you always recycle Datastage after the database comes back up? I know it works not to restart Datastage after Oracle is recycled but does that create stale oracle/odbc handles that cause obscure problems later?

I would have searched for this but I wasn't sure what to search for.

... Flash

It shouldn't be necessary but would not do any harm.

DataStage ought not to have any handles to Oracle unless (a) a job is running or (b) a table definition import is occurring. These times, I would suggest, are not good times to re-start Oracle.