We have a process at work that I developed. We run extracts from the DB2 system on the mainframe for loading into the Data Warehouse which is Oracle based on unix servers.
The final stage of the process is to use Oracle on the mainframe to connect to Oracle on the server and insert a trigger telling the Warehouse that the data files have been ftp'd and are reading for loading.
Not being immune to the credit crunch the company have decided to cut costs by getting rid of unecessary licences and decided Oracle on the mainframe is not needed. So they just switched it off!!
No call, no checking, no nothing. Bang. Off. Done
As it happens the job still ran because it actually just uses the Oracle datasets to establish a connection.
But they were about to delete the Datasets (because they have to as bound by licence) when they finaly noticed those datasets were in use!! I get a phone call from the DBAs asking why my jobs are using datasets that are no longer licenced.
"What do you mean no longer licenced?"
They now gone away to think how they can replace the functinality. We do have some ideas but of course they have to be developed and that has to come from some one's budget…
Steve P
paints some fast cats.
ansi!