DSXchange

Hi Expetrs, I had problem in Oracle Enterperise PX stage, load tables very slow, have to improve performance. I would like to get more picture in Oracle Tuning (table loading) in PX 8.1 ,UNIX env. could you let me know what env. variables need to tune and what are best steps in Enterprise Stage tuni...

HI, here i have millions of records in my source data with duplicate records. i need to assign key values for all records, same key values for duplicate recods. One ID for ONE name , no matter of address it should be done in one job. could you let me know how it is possible. her is the source data N...

use UNIX shell scripts and add in Before jobsubroutines.

Thanks
Rama

metaData Missmatch, correct your metadata according to source file.

Thanks
Ram

Hi Experts,

could you explain the differences/enhancements in Infosphere DS to Websphere DS.

Thanks Advance.


Thanks
Dev

Hi Experts,

What is the difference between IBM Websphere DataStage 8.X and Infosphere DataStage.

i heard new version 8.x running on Websphere, but i don't know what's Infosphere DataStage.

Could you explain me more about this diff.

Thanks
Dev

Hi Experts,


I had a req to find member_Age using his DateOfBirth and currrentDate()
finally a need to get Age in years.

i am using 7.5 Parallel in AIX env.

Hi Experts,

could you explain about schema files and usage in production environment.
how we use schema files to import and export variables ?

Thanks
Nag

Hi Experts,

i would like to know more info on multistage variables & where they are using.

Thanks
Devi

HI is your problem solved ,

We also having same issues with DS v8.0 connection issue with DB2 .


is there any updates with IBM.

Thanks
Rama

here is the unix shell script for archival & compress the data files. #!/bin/ksh filename=/../../LocationFileList.txt ## this file containg files names wich need to archive & compress filedir=/directory location backupdir=/ ## where you want to put your archived files ## *** ARCHIVING Proces...

Hi Thanks for reply,

i am in US central, using Mainframe jobs as well as server jobs, issue with DB2 compatability with DS8.0 for mainframe jobs.

Thanks
Rama

Hi Experts, we had an issues with IBM DS 8.0 on Mainframe & DB2 when running jobs getting hang on weekly then need to reboot every week. IBM applied 2 fixes but there is no use. then We stopped migration 7.0 to 8.0. any of you guys having same issues with 8.0 . if u , let me know how is was fixe...

Hi Experts, We are doing DS migration from 7.0 to 8.0 , useing unix, oracle & DB2 V8. we had a problem in dev box, while running these jobs (with DB2) server getting hanging , many times we need to reboot the server. is there any known issues with DS 8.0 Issues either with oracle or DB2, is ther...

HI Experts, i am running a job using on AIX shell script. DS v8.0, AIX . job desc : DB2 to Hash file .... data retrived from DB2 then loading into hash file , there are no other stages. job is running for few secs then aborted with the following error s : SPM016FilterDuplicatesHash..Src_OLETMSTR: [I...