Tag: Infosphere

How to get a list of installed InfoSphere Information (IIS) Server products

Which File contains the list of Installed IIS products? The list of installed products can be obtained from the Version.xml file. Where is the Version.xml file located? The exact location of the Version.xml document depends on the operating system in use and where IIS was installed to, which is normally the default location of: For Linux, Unix, or AIX /opt/IBM/InformationServer For Windows C:IBMInformationServer

Continue reading

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 the ‘Client Commands are Currently Not Being Accepted’ error, which I gleaned from the process. Error Message Id IIS-CONN-ESSBASE-01010 Error Message An error occurred while processing the request on the server. The error information is 1051544 (message on contacting or from application:[<<DateTimeStamp>>]Local////3544/Error(1013204) Client Commands are

Continue reading

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 join data based on the values of identified key columns. Related References IBM Knowledge Center, InfoSphere Information Server 11.7.0, InfoSphere DataStage and QualityStage, Developing parallel jobs, Processing Data, Lookup Stage https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/c_deeref_Lookup_Stage.html IBM Knowledge Center, InfoSphere Information Server 11.7.0, InfoSphere DataStage and QualityStage, Developing parallel jobs,

Continue reading

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 only Parallel Engine Jobs the three join type stages (Join, Merge, and Lookup). It does not apply to Server Engine jobs. Infosphere Information Server (IIS), Datastage and DataQuality 9.1 and higher The Fix Add the APT_NO_IOCOMM_OPTIMIZATION in project administrator and set to blank or 0.

Continue reading

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 manual enter the values in each of the sequences, by leveraging the DSJobInvocationId variable.  For this to work: The job must have ‘Allow Multiple Instance’ enabled The Invocation Id must be provided in the Parent sequence must have the Invocation Name entered The receiving child

Continue reading

Oracle – How to get a list of user permission grants

Since the Infosphere, information server, repository, has to be installed manually with the scripts provided in the IBM software, sometimes you run into difficulties. So, here’s a quick script, which I have found useful in the past to identify user permissions for the IAUSER on Oracle database’s to help rundown discrepancies in user permissions. SELECT * FROM ALL_TAB_PRIVS WHERE  GRANTEE = ‘iauser’ If we cannot run against the ALL_TAB_PRIVS view, then we can try the ALL_TAB_PRIVS view: SELECT * FROM USER_TAB_PRIVS WHERE  GRANTEE = ‘iauser’ Related References oracle help Center > Database Reference > ALL_TAB_PRIVS view http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2099.htm

Continue reading