DSXchange

Our default nodes is 4.A senior developer who worked on EE longer than me will be helping me.I still doubt perfomance can be increase.I will post the results as soon we done.

Thanks

Thank you,i needed a second person to say this,i told our developers that this job is actually designed very well and is running fast for these records.Most people who complain about poor perfomance in Dsxchange they are talking less than 80 000 000 with simple tranformation.My case is even worse ge...

Tried using 6 nodes,other developers couldnt log on to Datastage Designer and was told not to increase the nodes ever again. I will keep on trying other ways.

Thanks,

I will try that now and reply when the job is done.

The existing job that need improvement does selects from a view that is created in Sybase IQ and the job takes 2 hours.The view does the whole removing the middle number in col1 and get the max (num) to remove dumplicate. Doing this in datastage i first use stage variables to remove the middle numbe...

Hi Please suggest a way to make the job run faster on EE.This is the sql on a server job.Our database is Sybase IQ.SELECT MAX(KEY) KEY, Num, case when substring(trim(col1),1,locate(trim(col1),' ',1)-1)='0' then '' else substring(trim(col1),1,locate(trim(col1),' ',1)-1) end||' '|| case when substring...

Product: Datastage Version: 7.5 OS: HP-UX tcenh149 B.11.11 U 9000/800 3530963663 unlimited-user license Error description: When loading data from Datastage into oracle using the bulk loader, the following error occurs: BIL_PAY_MEANS3010..AfterJob (BulkLoad): CMD Output = /usr/lib/pa20_64/dld.sl: '/d...

No,i didnt have problem installing and i dont have any unix window session. This is the output of the command you suggested: etlprd01:$ list_readu EVERY Active Group Locks: Record Group Group Group Device.... Inode.... Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX 57933829 51109 0 60707 2 ...

Hi Created new project File/New Server Job Drag a SEQ stage to canvas and this appears: "Record CSeqFileStage in file DS_STAGETYPES is locked by another user" I cant create a new job. Error 2: Imported dsx to new project. Can see jobs but cannot open stages. Errors like "Record DRS in...

Thank you,

Thank you,

I would like to know whether it is possible to write an IXF file using DataStage. All I know about this type of file is that it is a file used by IBM, for loading into DB2.

Thank you,

I dont think is the same issue since the error saiys DSR_SELECT but
I will find out from the person i am trying to help if they omit in connection.Will let you know tomorrow.

What do you mean?

Exporting from one project and importing jobs to another project to the exact same server using manager . Nothing different about the server .

The error is :
Error calling subroutine *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project PRE PROD
(Internal Error (81021))