DSXchange

I recently installaed IBM IIS 8.1 in an AIX box (AIX 5.3). I have followed all the pre-requiste's but forgot only this c++ installtion. The installation gone fine. All the processes were up and I could create the datastage jobs and everything is fine. But just one thing is not working that is Transf...

I am posting this blog after a lot of search on the net and dsexchage. I am getting java out of memory exception while installing 8.0.1 Fix pack 2. I could see a known issue in the Release note that sometimes it may throw out of memory exception but to resolve that they have given some steps. Even a...

Ray...Thanks a lot for the suggestions but you know the mistake was very funny. Let me elaborate. A. The driver I chose was "Microsoft Excel Driver(.xls), I changed that to another driver called "driver do Microsoft Excel (.xls) to create system dsn. Ya I knw this is not funny but see the ...

I used that.. not working still

Hi, I have an excel workbook with many worksheets in it. The e.g. names of the worksheets are Share, Company etc I have to read from the Share worksheet and load into the DB2 target. The steps I did is as follows. 1) Created a system DSN named as RprtSysDsn to the source excel sheet 3) Using datasta...

Hi... I thought I will ask your advise before investing my time on this connectivity issue. Sorry for not reading enough docs before posting this question. 1. Can we connect Datastage (Unix installation) to a Teradata (Windows installation) through ODBC connectivity. 2. Can someone direct me to a do...

Ray... In sucha situvation like this PID Ordercount SalesTeamMember 100 2 John_stigmata 200 7 Luka_orange 100 1 Mary_stigmata In such a situvation I want just the sum based on PID and pick any of the SalesTeamMember for that group. How can I make use of Remove duplicate... My output should be... PID...

Hi I am using aggregate stage to do some calculation. I can find that First, Last options are missing in the parellel Aggregate stage which was present in the Server version. Can you tell me to get the equivalent here. Min and Max is there but in my case my datatype is varchar so it is resulting 0 f...

Does the db2nodes configuration file have the same number (and names) of nodes as does the parallel execution configuration file? Are you working in a DPF environment? spot on ... that was the issue db2nodes.cfg , I was missing the dbserver entry. Sad that Datastage should have thorwn some meaningf...

Hi... I am getting a very unusual error and the error is throwing from main program not from any stage I used in the job. Let me explain what I am doing in my job 1. DS --------> DB2 EnterpriseStage. 2. My target table is a partitioned table. The data from my DS is correct and all are with in the pa...

thanks....that really helps

Thanks ray. That helps.

I increased the /tmp space and my job is not getting aborted anymore.

Thanks.

What kind of files have been written into /tmp directory recently? Did you analyze that? I remember database related load statistics, log files based on your scheduler and many other log files also would go into the /tmp directory based on the environment settings. Yea..there is a big file is creat...

Hi My job getting aborted without any proper warning in the director. I did all I could to see the problem but nothing find wrong in job. I observed that /tmp directory getting full suddnly from 80% 100% and when it reach 100% it is getting full. I am not directly creating /reading any file from /tm...