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
restart Datastage after restarting Oracle?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 99
- Joined: Tue Aug 17, 2004 7:50 am
- Location: Boulder, Colorado
restart Datastage after restarting Oracle?
Flash Gordon
Hyperborean Software Solution
Hyperborean Software Solution
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.