DSXchange

I Think the coolest one is, DataStage is Easy-To-Use, any new developer can be productive with minimal training.

Ray,

It was not enabled in 7.5

Thanks,
Nitin Swarnkar

Hi All, The IBM suggested to disable the NLS settings and that does improve the performance. In Datastage 7.5, job was processing 11000 rows/second. In Datastage 8.5, with NLS enabled it was processing 4500 rows/sec and after desabling NLS, it become 8500 row/sec. Admins are still in touch with IBM....

UPDATE /*+ INDEX ACCOUNTS_TEST.ACC_PRIMEE*/ Hi Kamesh, Oracle hints needs to be given in exact syntax, and it requires a white space after the + sign at left side and before * at right side. Here we can see there is no space between index name and comment sign. So try this syntax and see if it help...

Thanks Ray, Thanks kamtammystuff

The Admins are working with Parameters like MFILES,TFILES,ULIMIT. Array Size and Transaction Size. And also opened a ticket with IBM.

Thanks,
Nitin Swarnkar

Hi All, We have recently migrated Datastage Project from 7.5 to 8.5, But we are facing performance issues, The old project and new project, both are on same UNIX box. There are some jobs in new project taking as much as double the time of what they were taking in old project. We have taken a job, ha...

ray.wurlod wrote:The order of columns is irrelevant. They are accessed by name. ...

Is it true, While reading data from sequential file using "File Stage" ?

Thanks a lot,
Nitin Swarnkar

So... this is a Metadata Workbench issue? :? We are facing this problem in parallel jobs. When we have big user defined sql in Oracle connector (with some 300-400 lines of sql) or while we are reading file through File Stage then the order of columns are getting changed automatically. Thanks, Nitin...

Hi All, We are facing a strange problem with column definitions of "Oracle Connector Stage" and "File Stage", and that is, If we alter the sequence of the columns and save, compile and run the job, after sometime (like few hours or days) it automatically reverted back to original...

Thanks Ray and Thanks Gregg.

Regards,
NItin Swarnkar

Hi All, We have started a new Datastage Project 6 month back, There we have decided to you Parameterized the Table Name/File_Name along with DB COnnection Name, User_Name,Password and Schema in entire Project. We are using a Parameter_Set to keep all the Parameters. Now, as the number of Tables (Sou...

You can pass your source file through a simple script where you can replace enter character with comma or some other delimiter and then
blank lines with enter chacter and change.

Thanks,
Nitin Swarnkar

Program "DSP.Open": Line 122, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage Merge..Merge_0 DataStage Phantom Aborting with @ABORT.CODE = 3 Hi, It seems that DataStage is not able to find the file, so check the path of the files tha...

Hi All,

We have installed clients of both versions locally, now we are able switch between 7.5 and 8.1 versions using Multi-Client-Manager.
But System Admin group is still working on the solution to, switch when both versions are intalled virtually.

Thanks EveryOne.

Regards,
Nitin Swarnkar

Ray, I don't know much about accessing softwares virtually, but In our installation they have created a WAP (package) and installed it to some remote machine, and there is a user group who has the access to that machine, So whosoever is the memebr of that group, has access to the applications of the...