restart Datastage after restarting Oracle?

flashgordon · Post by **flashgordon** » Wed Jan 09, 2008 3:03 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Jan 09, 2008 4:35 pm

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.