DSXchange

Hi Experts, Wish you and your families a happy and prosperous new year ahead! We have a hierarchy stage job that processes a large volume data file and put the modified records in to a DataSet. The problem we face is it is dropping the records whenever there are any free form texts within the incomi...

Happy Friday, dear experts! I was wondering if there is any way to invoke the XML Meta Data Importer utility, to update an existing XML Table definition. Apart from the default Properties dialog, I am not able to find any other way. I can recreate it, however the XSD is having ~3000 elements and hen...

Thanks Paul. Will check and let you know.

Dear Experts, We have a XML hierarchy job failing in PROD environment with a XML_stage,0: JVMDUMP030W Cannot write dump to file /home/runtimeuser/heapdump.20210708.123556.35873.0002.phd: No space left on device error. We can further diagnose the issue by directing the dump files to a different path ...

Hi Earny or other experts,

Is there any way to capture the problematic records from the XML hierarchy stagy by directing them to a flat-file as in other processing stages?

Cheers!

Chanaka

Dear Experts, I am also facing a similar issue. When I do the dsrecords, it lists the number of records properly. However in the dump file I am getting columns out of the order. The challenge I am facing is, it is not giving me any output for orchadmin describe -c -s <data set name>. Any help is ver...

Dear Experts, I have a multi-instance DataStage PX job that uses RCP to populate an oracle table from a dataset. We do not have any keys/columns defined. However the DataSet is having duplicate records (whole record duplicates) due to source system issues. Is there anyway for us to get the duplicate...

Hi UCDI,


By any chance, were you able to resolve it? I am faced with a situation where we have to let the MQ connector to pick up the MQ Manager from the tab file. Seems like it is impossible.

Cheers!

Chanaka

This link seems to be moved.

https://www-304.ibm.com/support/entdocv ... wg1JR52899

Thanks for the reply Craig. I was told that the support for DS 9.1.2 on AIX was already reached the contract end time. Only help available is from the local unix SAs. BTW, I did try to compile a sample c++ program through the command line. That is also giving the same error. Unfortunately, still una...

Hi Experts, Recently we have upgraded the OS from AIX 6.1 to AIX 7.1. We are using IBM Information Server v 9.1.2. While compiling PX jobs, it started giving below errors. We are certain that this is due to a compiler problem. However, wondering how to resolve the issue. Diagnostic details: > /usr/X...

Thanks a lot for sharing this. It really helped.

Hi Experts,

Has anyone used the lumask setting while using datastage SFTP stages? Is it supported?

Hi Experts, If my DataStage is installed without NLS, what would be the default character set? Current OS: Red Hat Enterprise Linux Server release 6.3 (Santiago) Locale settings:: LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_...

Hi,

I tried playing around with the same for a different reason. Maybe this post help you.