DSXchange

Hello Experts, i want to know if somebody has nice techniques to export DataStage project environment variables from the command line which could then be imported into a target datastage project? Our team is currently in a phase of migrating DataStage projects from 11.5 to 11.7 version and we do not...

Greetings Experts!
Can the password of dsadm(OS User) be changed after credential mapping is done in the administration console. I mean do i have to update the password each time it changes ?

This could help

https://www.ibm.com/support/knowledgece ... ement.html

There is no such pattern that i could recognize..

Hello Experts, I have a slight problem with the table definitions that i have imported from the database. When i view the columns in the table definition itself, the order is fine. But when i try to import it into a Netezza connector, the order of the columns completely randomizes. Does anyone know ...

You could also check if port 31538 (for RPCd) is open

I think via the command line jobs can only be compiled from the Client machine and not from the Engine

dscc.exe is the utility but as far as i know it is only present on the Client machine. So you have to figure things out.

Apparently i ran into the same situation. I was making IGC rest-api calls to the services tier. What i did not realize is that if i do not make proper use of cookies and sessions, each rest call would initiate a new session which shows as UNKNOWN in the admin console. I made 1000 rest api calls and ...

Thanks Ray for your response.

Unfortunately i couldnt do it, or not allowed to do it.

I wanted to know how other people do it ? Do they use XMI's ?

You dont need to edit the dsenv Depends which operating system you have. For RHEL, you can edit /etc/security/limits.conf dsadm soft nproc 10000 dsadm hard nproc 10000 After doing this, logout, relogin as dsadm (or whatever user you use for datastage) Execute the shell command: ulimit -a check if ne...

Hi Gurus, i am seeking a suggestion on IGC (11.5.0.2) on moving glossary assets from one IGC instance to another Scenario: We have terms assigned to technical assets Environment1: Term1 --> HOST1>DB1>SCHEMA1>TABLE1 If we want to export this term from Environment1 and import it into Environment2 and ...

Andy, can i ask you a question, are you able to connect to Hive Server2 using ISHive.jar that is shipped with IIS itself? I also have a kerberos setup. I get this error. java.sql.SQLException: [IBM][Hive JDBC Driver]THRIFT protocol error. This is the jdbc URL is use: jdbc:ibm:hive://hivehostname:218...

Yeah i also think that you need to import the metadata from your source database via IMAM first. The connection that you specify in IMAM would be used to fetch the data from the source database

And also, an imam import area for IADB should be there.

Did you manage to solve this problem ?

Ok i got it working. Some jar files under istools/cli/plugins directory related to ia had permission problems. dsadm did not have read and execute permissions on them. I re-configured the permissions, and also cleaned up the istoolcache. After doing so, my istool works now with the -ia option. I'l m...