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

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

What Are The DataStage / QualityStage Join Stages?

While chasing an error to which only applied to join type stages, I thought it might be nice to identify what the InfoSphere Information Server DataStage / QualityStage are.  There are three of them, as you can see from the picture above, which are the: Join Stage, Lookup Stage, And, Merge Stage. All three stages that … Continue reading What Are The DataStage / QualityStage Join Stages?

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