End Of Support For IBM InfoSphere 9.1.0

End of Support for IBM InfoSphere Information Server 9.1.0 IBM InfoSphere Information Server 9.1.0 will reach End of Support on 2018-09-30.  If you are still on the InfoSphere Information Server (IIS) 9.1.0, I hope you have a plan to migrate to an 11-series version soon.  InfoSphere Information Server (IIS) 11.7 would be worth considering if you … Continue reading End Of Support For IBM InfoSphere 9.1.0

Infosphere Information Server (IIS) – Where you can view DataStage and QualityStage Logs?

During the course of the week, the discussion happened regarding the different places where a person might read the DataStage and QualityStage logs in InfoSphere. I hadn't really thought about it, but here are a few places that come to mind: IBM InfoSphere DataStage and QualityStage Operations Console IBM InfoSphere DataStage and QualityStage Director client IBM InfoSphere … Continue reading Infosphere Information Server (IIS) – Where you can view DataStage and QualityStage Logs?

Essbase Connector Error – Client Commands are Currently Not Being Accepted

While investigating a recent Infosphere Information Server (IIS), Datastage, Essbase Connect error I found the explanations of the probable causes of the error not to be terribly meaningful.  So, now that I have run our error to ground, I thought it might be nice to jot down a quick note of the potential cause of … Continue reading Essbase Connector Error – Client Commands are Currently Not Being Accepted

Parallel jobs on Windows fail with APT_IOPort::readBlkVirt;error

This a known error for windows systems and applies to DataStage and DataQuality jobs using the any or all the three join type stages (Join, Merge, and Lookup). Error Message <<Link name>>,0: APT_IOPort::readBlkVirt: read for block header, partition 0, [fd 4], returned -1 with errno 10,054 (Unknown error) Message ID IIS-DSEE-TFIO-00223 Applies To Windows systems … Continue reading Parallel jobs on Windows fail with APT_IOPort::readBlkVirt;error

DataStage – How to Pass the Invocation ID from one Sequence to another

When you are controlling a chain of sequences in the job stream and taking advantage of reusable (multiple instances) jobs it is useful to be able to pass the Invocation ID from the master controlling sequence and have it passed down and assigned to the job run.  This can easily be done with needing to … Continue reading DataStage – How to Pass the Invocation ID from one Sequence to another

DataStage – How to use single quoted parameter list in an Oracle Connector

While working with a client’s 9.1 DataStage version, I ran into a situation where they wanted to parameterize SQL where clause lists in an Oracle Connector stage, which honestly was not very straight forward to figure out.  First, if the APT_OSL_PARAM_ESC_SQUOTE is not set and single quotes are used in the parameter, the job creates unquoted … Continue reading DataStage – How to use single quoted parameter list in an Oracle Connector

How to know if your Oracle Client install is 32 Bit or 64 Bit

  How to know if your Oracle Client install is 32 Bit or 64 Bit Sometimes you just need to know if your Oracle Client install is 32 bit or 64 bit. But how do you figure that out? Here are two methods you can try. The first method Go to the %ORACLE_HOME%\inventory\ContentsXML folder and … Continue reading How to know if your Oracle Client install is 32 Bit or 64 Bit