DSXchange

Hi, I have an ETL environment where i installed DataStage 7.5.3 version and configured remore DB2EE as per IBM guide. As part of DB2EE enable exported datastage specific file systems and px file systems to database nodes. Create a configuration with ETL nodes + remote db2 server nodes, executed job ...

Hi, We have a requirement - where we receive source files in multiple formats like Delimited (csv, pipe), Fixed length, xml. looking for a common process where it reads different kind of source files and map to a specific schema file format - like format to target format based, target formats also c...

Thanks for the info Ray, Now ODBC stage is working after adding a user variable called DB2INSTANCE = '2nd instance' name, I could able to point to DB2 database and extract data but when i try to import meta data using ODBC or Plug-in methods getting SQL1013N error. Today I updated LIBPATH and PATH f...

Hi Ray,

Can't it be done with out use of environment variables per job basis in job parameters?

for example if i want to import ODBC metadata - how does job level parameters works?

Thanks,

yes, I did set APT_DB2INSTANCE_HOME to "2nd db2 instance" 1st db2 instance is set in dsenv file. I am overriding 2nd db2 instance in DS Admin for specific to this project only. But some how when i log to this specific project APT_DB2INSTANCE_HOME is not reflecting to 2nd db2 instance. DB2E...

database entry is already been in .odbc.ini file.

Hi,

As long as i pass DBname, Instancename, Id and Password ETL job works fine. But when i try to log to Designer and try to import Metadata via ODBC or Plug in metadata options it is throwing SQL1013N error. Any idea what else needs to be done to over come this issue.

Thanks,

Hi Ray,

You are suggesting to DB2 environment variables like instance information in dsenv file? if so, how do we flip dsenv db2 environment variables for different project?
appreciate your input.

Thanks,

Hi, We have 2 ETL applications running on same application server - each uses different DB2 instances. Requirement is both applications needs to write data using DB2EE stage,where are currently one DB2 instance is cataloged and it has needed db server information in db2nodes.cfg file. Is there any o...

This is also related to TMPDIR in DataStage Administrator - check TMPDIR value and permissions on that path.

Create necessary permissions and compile.

Thanks,

Thanks, just want to make sure - I got the feed back from other people, they said it is total refresh.

Hi,

We are planning to upgrade our ds environment from 7.5.2 to 7.5.3 version. By doing this are we going to loose all the job logs what we have currently? can some one provide me the information who did upgrade to 7.5.3 from earlier version?

Thanks,

Hi eostic, so RTI and WebServices are different? the reason i am asking is - recently i installed WebServices package on DS 7.5.2 where we have XML Input, XML Output and Webservices transformer stage.. How this is different from RTI? If we want to RTI - i think we need to pay extra license cost is i...

Yes, and this is the right forum to ask. Using the SOA components you can publish a DataStage job as a web service that the other tools can invoke. Only a small amount of extra work (adding RTI Input and RTI Output stages) is required to make your job "RTI aware"). RTI = "real time i...

Thanks Ray,

so if i start counting from 0 in my config file - when i reached to number 9 node - that is the problem one...

deleted few tempfiles from that scratchdisk area - hopefully job completes now....

thanks again....