We have been hitting some issues with Optim jobs abending while Oracle maintenance is being applied. All our Oracle DBs are set up on RACs (ie: clusters) so while one server is being updated, another one is available to accept the DB traffic. "RAC Awareness" is the ability of a tool to understand the error message from Oracle which says essentially "we're doing maintenance now, so please disconnect and reconnect and you'll get routed to another server."
Currently, Optim just abends the job as soon as it gets an 'DB unavailable' error due to the maintenance. It'd be great if there was some setting/option to let Optim retry the connection before issuing an abend. I got nothing from the documentation on this after various searches.
I'm guessing this is wishful thinking, but I figured it was worth posing to the group. Thanks for the input.
-Keith
------------------------------
Keith Tidball
Progressive Insurance
------------------------------
#InfoSphereOptim#Optim