I was told that jobs designed in 11.3 will continue to run in 11.5. I've discovered that jobs designed with any of the deprecated OCI stages will not run. They compile but in the logs they throw a warning and abort.
Oracle OCI has been DEPRECATED
This deprecated stage is replaced by the Oracle Connector Stage
Using the Connector Migration Tool, jobs using this deprecated component can be converted to use the Oracle Connector
Attempting to Cleanup after ABORT was raised in stage
This interfering with the upgrade schedule I had planned out. I've opened a PMR with IBM but they're being slow to respond. So I thought I'd check to see if anyone has been able to run a job with a deprecated stage?
I'm ok not having the stages available on the palette and I know eventually jobs will need to be updated, but I was hoping to do the in-place upgrade while it's available instead of doing a migration as it's going to take a lot of time to go and modify jobs and I would like to make the other benefits of the 11.5 available sooner rather than later to my developers.
In one of the releases they converted these to the recommended stages as they imported the jobs. You might try exporting and importing and see if it upgrades your jobs. Save you a lot of time fixing them one at a time. IBM might have something to upgrade them as well. Call support.
You want to move away from the OCI stage to the Connector stage because IBM are no longer upgrading and certifying the OCI stages against new versions of databases. If you want to keep up to date with the latest Oracle or SQL Server then it's best to use the Connector Migration Wizard to convert all your jobs across to Connectors. There are some benefits to Connectors, I believe they are a bit faster and they have much better reject handling for things like foreign key or primary key violations.