DSXchange

I have a DataStage Sequence Job which executes 4 DataStage jobs in it. All the 4 DataStage jobs run parallel to each other. All these 4 jobs have same ParameterSet defined in them. My requirement is that I want to pass a different set of values for these 4 different jobs but using the same Parameter...

Sorry, a small correction the requested length is not 107732. It is actually greater than the range i.e. 1077732. We modified the APT DEFAULT TRANSPORT BLOCK SIZE to 1077733 and the job executed successfully. I just want to know if there is any issue to specify the value greater than the range provi...

Hi, In our DataStage job we are receiving the error "the record is too big to fit in a block; the length requested is: 107732, the max block length is: 1048576" As per the IBM website, for DataStage Version 8.7 the range which can be specified for ENV Variable APT DEFAULT TRANSPORT BLOCK S...

Hello, We have huge files (approx 48) each with a size of around 2GB. We are trying to read these files in a single job using 4 separate Sequential Stages and each stage reading around 12 files. The job when executed takes too long to run but never finishes. We tried multiple options of Config File ...

Thank You for your reply and Information details !!

I will check with my Linux Admin team to trace this particular Process.

Is it normal that a DS Client process is consuming almost 99% of CPU even to view the DataStage jobs as there were no running jobs.

Hello, I observe by running "top" command on Linux server that the dsapi_slave process is consuming 99% CPU but at the same time when I check in operations console I do not see any jobs running. Any idea which is this process that is consuming so much of CPU. I observed it for whole day an...

Thank You Craig and Ray !!!
I will check with my support provider and get back with the pointers.

Hello, When I try to connect DB2 using DB2 connector, I get the below error: Failed to receive the response from the handler: Error unmarshaling return header; nested exception is: java.io.EOFException Kindly request you to provide some pointers as to why exactly I am receiving this error. Thank You...

Hi Craig, Yes, thats the default path but I was more focusing on trying to bring the TNS_ADMIN env variable to be seen in DS Director logs in the Environment Lists. Also the tns entry is proper, I will check further on it but I was concerned why that parameter is not shown in DS Environment list logs.

This is what is written in the dsenv file TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN I have added the TNS entry in the file tnsnames.ora at this location but somehow it is still not showing in the DS Director log and the job is aborting giving the error Exception thrown from CC_OraConnec...

Hi, I need to store the tnsnames.ora file in other location and let DS use the same from there. When my Job executes I am not able to see this parameter in the Environment Variables list in DS Director logs. I added this $TNS_ADMIN in dsenv with the new path where I want this file to be but after i ...

Thank You Mike for your detailed reply !!

I will go through all of your points in detail and have a discussion regarding the same in my project to finalize a particular strategy.

I will keep you all updated as to what solution we have finalized.

Thank You !!

I am sorry to say but I don't see any relation between your post and the questions which I posted.

As far as your question is concerned, the answer is in the Subject Line itself. Wondering how you missed reading the subject line.

The Problem here is that once a code is baselined and stored in the VC tool, further development on that code in Dev will still continue. So we cannot directly move the code from Dev to QA and so on using istool package options. We have to import the baselined code from VC tool only. Regarding optio...

Because in future we are planning to automate our deployment process to move the code between various environments through scripts instead of Information Server Manager tool.