DSXchange

When IIS is up and running on the primary host it is all good and doesn't consume much memory (about 5 GB out of available 48GB). We are trying to switch to the secondary server to complete a maintenance activity on the primary host and not because of a broken process. When we failover, we are movin...

Yes. Our start order is always DB2, WAS, NodeAgent and Engine. Also once all of these tiers startup, I am able to login to datastage also. But the number of connections increase drastically after 5 minutes and the failover server crashes due to memory and paging space issue. We have 48 GB of memory ...

Yes. another thing that I forgot to mention is that the repository was installed first IBM DB2 and the databases and objects were created with the scripts provided by IBM. The Engine and services were installed from the IIS installation pkg after HACMP was setup.

Hi, We have IIS 11.5 is installed on active / passive cluster (Power HA Version 7). When the application fails over to secondary host, and engine starts up more than 45k DB connections are opened to XMETA (sample below) and server crashes due to memory spike to 100% and swap to 99%. The application ...

Hi, We have multiple datastage SDLC regions (Dev, SYSi, QA and Prod) and we have had multiple releases over 5 to 6 years. In the process all our regions have accumulated lots of parallel jobs and sequences that are obsolete. We are trying to automate the process of cleaning up the jobs from datastag...

Hi, We are facing the same issuse when multiple inctances of the same job runs, one instance fails. We have the auto commit set to off and it used to run fine. After the servers were relocated, we are facing this issue. Also the job is failing in 16 seconds when we are trying to load just 1 record. ...

Hi,

Was this issue resolved? I am able to see the same issue. Would be grateful if you could help me out.

Hi Ray,

Thanks for the clarification. I need to use the State, Zip and phone numbers for narrowing down the matches in case of duplicates in name match and for validation if there is a single match.

Hi All, I have designed a Reference Match job where the Data will contain around 10k - 100k records and my reference set right now contains around 3 million and is expected to grow. The match is being done on the first and last names and the blocking is on the NYSIIS values of the first and last nam...

Hi All, I am currently developing a Match specification to match First Name, Middle Name, Last Name, State, ZIP and Phone Number. I have some queries regarding the actual implementation: 1. This is going to be a reference Match and the both the data as well as the reference set keep getting refreshe...

Bang on... I didnt notice these fixes were out. This is our problem. Will ask our admins to do the needful.
Thank you so much Ramesh.

Hi Ramesh, Following is the synatx we are using: DSXImportService.sh -ISFile /opt/IBM/IS/InformationServer/ASBNode/conf/dsimportconnection.conf -DSProject <PROJ_NAME> -DSXFile <File>.dsx -Overwrite -Verbose Sometimes it imports all the jobs in compiled state but sometimes it doesnt. The export file ...

Thanks Boss for that note! What I gave you is my current situation and how the environment and process was and is in the projects I have been in. I did not generalize and neither did i say that no one is fixing code in PROD. When your Murphy's law does come into action it is handled differently. Any...

Im really concerned if a PROD environment doesn't have a compiler installed , and the operations team need to make a quick fix on a transformer stage issue or a custom operator/build op issue. All environments I have worked have at least a single user compiler license for non Development environmen...

Thanks Ray,

We are also doing the exact same thing. We are importing individual jobs and using a unix script to loop through and import each element. We also ensure we run a multi job compile before we export from dev. Still the jobs get imported in uncompiled state.