DSXchange

Can you do a quick test to isolate the issue when the job is hanging ( for what ever reason). 1. Identify the processess associated with the job 2. Capture the memory usage and disc usage stats for untill the job stops and a minute after that. 3. Check the number of semophores opened. Gather this in...

Check odbc.ini file in DS engine 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 issu...

Check odbc.ini file in DS engine 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 issu...

Thanks Very much. I shall surely goole core dump.

Can any one explain to be the DS core file back ground: I have a Ds job with a DB extract and a DS sort which land data to a hash file. The job fails after processing 1.5 million records I suspect this failure has to do some thing with the sort stage properties. The jobs while failing is create the ...

Hi I have a Parallel Job which extracts data from SAP which has a UNICODE Data (Chinese,japanese,and different languages) iam using ABAP SAP R/3 PACK 5.2.1 when i run the job the job keeps running for a long time with with this message . 'LOGGING DELAYED METADATA' (For some SAP Tables when i import...

Hi, As you are running your datastage on windows then, write one batch program which calls all your executable jobs and schedule it through WINDOWS Schedular. ------------------------- Hi I need to automate the job such that it can shedule the datastage on every month 2nd ..here i am not going use ...

I have joined two tables with an inner join. Table 1 has 5000 records and table 2 has 5000 records. The expected output cannot be more than 5000 records in this case. But I get way beyond 5000 records. It seems to me that the join is doing a cartesian product of both the tables. Can any one suggest...

Hi, We are facing very strange problem with out greek charector file. Any input of yours would be greatly appreciated. Environment: Datastage 7.5.1 installed on solaris Database : DB2 8.2 installed on AIX . (UTF 8) Job Type: Parallel. we have successfully loaded greek data to one of our tables USING...

Thanks every one for your input. Your advise has got me to th epoint where I was able to fine tune the jobs

DSGuru, Yes I am using join stage as I am dealing with very large volumes. The real bottel neck is in making in the target DB2 API STAGE.
The inserts and updates are happenning very very slow.

No DsGuru

Thanks Buney,
DB2 EE stage cannot be used to connect to a remote Database which is on a different operating system. ex ETL server is solaris and DB server is on AIX. We have turned every page to try to make DB2 EE work.

Thanks ray... but in order to seperate inserts and updates I have to again do a look up on the target to distinguish with between inserts and updates. And there by increasing changes of table scanning since my target would have to also serve as look up. THis has the potential of decreasing performan...

I need few ideas on increasing the performance of my huge volume on time loads. Back ground: We have very huge volumes( 47 M - 2000M) Our database is db2 8.2. it is on a Aix box and Datastage is on a solaris box Due to this hetrogineous environment we cannot use DB2 EE stag ein our PX jobs So we wer...