DSXchange

Thanks Paul & Ray,
We initially thought the .profile is more important.
After further checking, we realized we've missed to put the ORACLE_HOME/bin and /lib in the dsenv.
Now it works perfectly fine.
Thanks again...

Cheers..
Endy

Dear Experts, We are scheduling our ETL batch to run every early morning at 2AM. Unfortunately for the past 4 days every time the scheduled sequencer kicks in, the job will failed because one of the scheduled job is calling Oracle SQL Loader, but somehow the Scheduled Job doesn't have the correct Or...

What changes did you make in uvconfig? Shouldn't you supply the new value with the -itag option? (That's from memory, but I recall that -itag ade is needed to reset to ade.) ... When we tried to change the instance to bcb, in uvconfig we changed the parameter value of instancetag to bcb. Then we ch...

After changing the setting back in uvconfig , did you re-run uvregen command? ... Hi Ray, Yes Ray, we rerun the uvregen. The steps that we did: - login as root - cd `cat /.dshome` - . ./dsenv - bin/uv -admin -stop - change the uvconfig - scripts/DSEsettag.sh -force -itag reset - bin/uv -admin -rege...

Hi All, We're having a problem. We tried to change our DS itag to bcb, by changing the uvconfig and running DSEsettag.sh script ( DSEsettag -itag bcb ) but without root access. We had some error messages when DSEsettag was run, but the uv -admin -regen was fine. When we restarted uv -admin -start, i...

Thanks Ray & Ken,

The course is not available in ASEAN, but it's available in Sydney or Melbourne. Any chance that any of you teaching the class? [:D]

Thanks a lot...

Regards

ND

Dear all, I am looking for DataStage Best Practices Class (DS306) schedule in Asia-Pacific region. Can somebody help me? I've tried to look at Ascential Education site, but the class schedules avalable are only in US and UK. Ray or Ken, do you guys know if there is any schedule for the class in Asia...

Kenneth, Actually, previously I tried to write to one sequential file and using the graphic design. But the because then I have to define the same file 40 times in the design, but the output the seq file will only come from the last column that writes to the seq file, so instead of having 40 rows fo...

Dear all, I have a source table with 60 fields and 4.6million rows, 40 fields need to be lookup to one lookup table. If during lookup the values from the source table are not found then write to a reject table. I put the lookup table into a hash file, and then I created a Routine to do a lookup to t...

Thank you all for the detail explanations...
I have never tried the UV stage before, but I am going to try that approach.
Thanks again...

[;)]

Regards

ND

Hi, My Hash File has 2 Keys (Hash.A and Hash.B), I like to do a lookup from a data file with the only 1 key (Data.A). How can I get all value from the hash where the Hash.A = Data.A ? What value should I put in the transformer when looking up to Hash.B ? I tried to put @TRUE or Not(@NULL) or Not(0) ...

Dear all, We are using DS 6, with DB2 7.2 both on AIX. One of our job design is to read from a table, lookup the key values from a hash file, if the keys already in the hash use the value from the hash, if not found write new value to the hash and use the value (from the hash and/or the new value) t...

Hi, One of our jobs has 10 input links to a DB2 Stage. Everytime we tried to run the Job, it failed, with a message: "CIF40TSDSIFM01..Write_STGDB: [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown o...

Dear all, One of our job is using Link Partitioner,Link Collector, and Pivot stage. In order the Link Partitioner/Collector to work properly, the job has to be Inter-Process enabled. But the problem is that it causing the Pivot stage not working at all if it's in Inter-Process. The Pivot stage keeps...

Dear all,

We're using DS 6 on AIX box. We're having problem everytime we try to use the DB2 Plugin (Importing Table Definition, View Data, etc), the message "Unable to initialize Plug-in" keeps coming up.

Anybody can help us? [:I]

ND

Regards

ND