DSXchange

I am currently upgrading our AIX 5.3 Dstage 7.5.2 environment to use PAM authentication and cannot log into Dstage anymore. Our AIX server are already configured for LDAP and is working fine at a system level. I have followed all steps in Ascential Documentation and no success. It looks like Dstage ...

I am trying to implement Kim D. script to export job HTML reports but cannot located the dsjob.exe. The only existence of the script is on the AIX DataStage server. Am I missing something? Is their a way to export this information from the client?

I have an issue where I need to search all jobs that use a specific table name and database. I am currently dumping out the dsx file and manually searching through using the grep command. I would like the ability to load the dsx file into a database table but have not had much luck. Found a tool bui...

I am doing some research and noticed that our hdisk mount with the /tmp allocation is getting hammered during job runs. We have allocated our scratch/sort to another hdisk and know that it is not the contender. I do know that the uv uses the /tmp for workspace but after looking found a lot of dynLUT...

I am trying to revise our Datastage file system backup strategy. To ensure a clean backup we are following the steps below. Unforuntely when a client connection exists when stopping dstage process they are put into a "CLOSE_WAIT" state. When restarting dstage after backup the dsrpc process...

We are running into performance I/O issues with our 7.5.2 install and need to determine recommended IOPS for Datastage. We are running on an Hitachi SAN and the storage team is asking for this number to size the disk arrays correctly. Any ideas on how to caluclate or does IBM have a minimum recommen...

I am trying to submit a block of sql to Teradata and not sure how to correctly submit the SQL. I tried using the Teradata Enterprise stage using MLOAD but does not like it since the submitted SQL includes joins. I also am going to try to us the DRS stage but do not have the Teradata ODBC installed o...

I have a project that needs to read user specific information from Tivoli Identity Access Management and wondered if IBM has a stage for integration. I can have our Tivoli group write an extract to a flat file but wanted to lesson the failure points by using direct access. I know both products are I...

I was able to get the masking to work for the Item node and the Division node but still cannot get it to mask over both nodes to allow me to choose one repetition key. All transaction will have either a LineItem\Item\POSIDdentity\POSItemID node or a LineItem\Division\Item\POSIDdentity\POSItemID node...

Sorry for lack of detail!!

This field is an attribute of all columns on the XMLInput stage "Output" tab. It is located between the column_name and derivation attributes.

This is being used in a parallel job.

I cannot find any documentation on the usage of the "Group" column for the Output column definitiions. Can someone please explain the usage.

I am trying to code the XML Input stage repetition element and not having much luck. The issue is that my repetition element will change based on the data being sent. In the example below my repetition element could be either of the following: 1) POSLog/Transaction/RetailTransaction/SaleForPickup/Li...

I am submitting an update/insert query to a Netezza 4.0 dbase and was wondering if the DRS stage had a way to output row affected that are returned from the update/insert statement. I can always retrieve this information from the dbase log but want it to be written to the Datastage Log. Any help wou...

Unfortunately it did not work... See below for column layout... Any more ideas??? I even switched to gridview mode of the XMLOutput stage and changed the "Trigger Column" field to RESTID. I could not locate the Trigger Column field in the regular view. Column name Key SQL type Extended Len...

Unfortunately it did not work... See below for column layout... Any more ideas??? I even switched to gridview mode of the XMLOutput stage and changed the "Trigger Column" field to RESTID. I could not locate the Trigger Column field in the regular view. Column name Key SQL type Extended Len...