DSXchange

Hi,

Two questions:

1. Can we track lineage with Mainframe Application in Information Governance Catalog using DataStage? If yes, how?
2. Can we connect to the IIS Server to Visualization tool like Tableau or MicroStrategy? if yes how?

[Note: title changed to be more descriptive - Andy]

Thanks, Ernie. We have involved support now.

Meanwhile, we pointed to the PROD source from non-prod region and triggered the job. It ran fine without any issues. This makes us think that there is something missing in the PROD IIS server.Your thoughts too, please.

Hi, We are testing a datastage job with Hierarchical stage in it which generates an XML. In the Dev regions, we never faced the below error. But it is happening in higher environments. Tested with same data in both regions. Can some patches help? Kindly advise. Message: hd_cust_reg_loc_loctp,0: Fata...

We are using the hierarchical stage to generate the XMLs.There are 5 XMLs getting generated by 5 separate jobs running in parallel. When we ran the master sequencer last time (this sequencer runs these jobs in parallel) , the number of records generated were 0. But source tables had data. No error l...

Hi, This is regarding AVI - Address verification interface. We are using this stage to enrich our address information. The address in our system is free form and there are no proper order/pattern of address. There are address information of more than 200 countries. We are using verification level pr...

Thank you all.
The issue was finally fixed by increasing the number of bytes in target database and changing data type to unicode from varchar in jobs. Thanks again!

Hi,
Any thoughts, please...

Hi, We have a job which extracts records from Oracle table and loads to a DB2 table. No transformations. The issue is with a NAME field where in Oracle and DB2 it is varchar (80). one of the names has a non English character such a cross sign, a star etc (My keyboard does not have them, sorry) So wh...

Done, thanks!!

Thanks, Ray. Got it.

Never mind.
It was an issue with the user ID used. When tried with admin user, export and import works - but still only for candidate rules. Thank you.

We have around 50 Information analyzer rule definitions created, that are being used in datastage jobs. Now we are in development region. We want to migrate these rules to QA. So, we tried to export these "Accepted" rule definitions from console. Even though the console said exported succe...

Thanks for the responses.
The user ID has full permissions. So it could not be an issue.

Meanwhile, we tried to a wait command in between and the file is getting transferred now. Thanks again!

Hi, We are calling the scp command using expect utility from our unix server to transfer a file to MDM server. The command works fine while running from unix. But when calling from after job sub routine/ Execute shell stage, the file is not getting transferred. There are no error messages too. The j...

Thanks again, Ernie and Craig.
Yes, we will reach out to IBM support team on this.