Search found 224 matches

by attu
Tue Jul 03, 2007 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: shell script for dsjob command
Replies: 5
Views: 3541

shell script for dsjob command

kinda new to shell script and trying to run the following dsjob command from the script..and get jobnames of my project the error i get is script.sh[2]: devtest: not found Invalid arguments: dsjob -ljobs <project> Status code = -9999 DSJE_DSJOB_ERROR *************************************************...
by attu
Tue Jul 03, 2007 1:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSBIN command
Replies: 4
Views: 1251

DSguru2B wrote:Refer here.
Yup.. I sourced the dsenv.. it's working.
Thanks
by attu
Tue Jul 03, 2007 12:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSBIN command
Replies: 4
Views: 1251

Thanks kcbland .

its working...

i want to use dsjob -lprojects command and getting this error.

dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory

whats wrong with it?
by attu
Tue Jul 03, 2007 10:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSBIN command
Replies: 4
Views: 1251

DSBIN command

Hi,
I want to go to the ds engine by typing $DSHOME when I log in to the unix box, i typed this on unix prompt

DSBIN=`cat / .dshome/bin
export DSBIN

then I did $DSHOME and got this message
zsh: permission denied: /edw/Ascential/DataStage/DSEngine
by attu
Thu Jun 28, 2007 2:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: segmentation fault
Replies: 3
Views: 1300

Chulett,

what is the workaround for segmentation fault (core dump)?
Thanks
by attu
Thu Jun 28, 2007 2:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: segmentation fault
Replies: 3
Views: 1300

segmentation fault

Hi, what kind of error is this?


RT_SC19/OshExecuter.sh: line 20: 14944 Segmentation fault (core
dumped) $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1


Any help is appreciated.
by attu
Mon Jun 25, 2007 10:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Tuning
Replies: 3
Views: 1256

Thanks Vijay and Ankita
by attu
Fri Jun 22, 2007 1:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Tuning
Replies: 3
Views: 1256

Performance Tuning

I have a question relating to job performance, one of the job is doing a normal lookup directly from the oracle table to retrieve ID, there are over 9 million records in the table and this lookup causes the performance to decrease.
how can i increase the efficiency of this job?

Thanks
by attu
Fri Jun 22, 2007 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII to Binary
Replies: 6
Views: 2470

Thanks Ray.
by attu
Thu Jun 21, 2007 9:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII to Binary
Replies: 6
Views: 2470

I dont see the vecotr in the native type. how can I change the group to vector?
by attu
Wed Jun 20, 2007 12:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII to Binary
Replies: 6
Views: 2470

prasadduvasi wrote:Do not include group type columns in metadata
Then what should I use in place of Group :roll:
by attu
Wed Jun 20, 2007 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ASCII to Binary
Replies: 6
Views: 2470

ASCII to Binary

I have a sequential file with data in ASCII and would like to convert it into BInary using a CFF stage. In the CFF stage I have some columns whose Native type is Group. I want to map them using a transformer but some of the columns cannot be mapped and I am getting this error... Could not find subre...
by attu
Wed Jun 20, 2007 8:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5279

Thankyou guys.
by attu
Fri Jun 15, 2007 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5279

sun rays wrote:If you are not going to do any iterations then do nothing. The sequence automaticaly stops after the last activity.
So after routine activity stage no out put link....

Mystuff it's Netezza
by attu
Fri Jun 15, 2007 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5279

Craig I dont know why they are using script. :( In the end of my final job activity after the job is processed and runs a script from the command execute stage and after that it goes to routine activity stage for job status. How will I end the whole sequence after all jobs have ran successfully? can...