DSXchange

hi , i just need a small clarification, could any one let me know which sort gives better performance, whether UNIX / data stage. i sorted 25 lakhs records it takes 10 sec in data stage with auto partitioning where as in UNIX it took 2 mins . can any body clarify me why it takes 2 mins time in Unix ...

hi chulett,

./dsjob -lprojects is working thanks for your solution

hi,
is there any possibility to design a job to find out each job runime and elapsed time in the project

hi, am working on migration project, we are migrating the database oracle to db2, now we are in testing phase. we are running the jobs on both databases and testing the record count. so,i need to capture the job start time and elapsed time for more than 800 jobs . so far i captured manually by takin...

When I execute the dsjob command from command line its showing the warning like
[dsadm@krkdatastage4 bin]$ dsjob -lprojects
-bash: dsjob: command not found
Dsengine dir is /opt/IBM/InformationServer/Server/DSEngine/bin

Can any one help out me on this please..

hi,

you can remove that additional characteres at sequential file level by using the vi command like

:%s/[ctrlkey+v and ctrl-key+M]//g
but actual command would be :%s/^V^M//g

Any suggestions?????

hi ,
please see the info mesage below from previous run..

its throwing only one warnng message

Abnormal termination of stage CWLdDimDealer_chk..TrfVend detected
and also info message
DSD.StageRun Active stage starting, tracemode = 0.
previous run it ran succesfully yesterday,today its giving this problem

hi am working with the environment datastage 8.1 server jobs, i have simple job it fetches the data form oracle oci table and load into orabulk stage with a transformer stage, placed between oracle OCI and ORABULK. it ran sucessfully yesterday, but today its giving a warning message Abnormal termina...

hi ,

am working on 8.1 server jobs,loading the data into orabulk stage.
which loads data to two files control file and dat file. dat file contains the actual data.
but job is aborted when the size of dat file is more than 2 gb.
can any one suggest me how to increase this file size..

its working for some other jobs,which are loaded data into oi tables succesfully

Thanks ray,

but my question is whether the problem is in oracle or in datastage job.

hi , i have a job which updates the surrogatkey value and loading into oracle oci table, when the loading time job is aborted and could not load data in to table, its saying error like SurrKeyAgg: ORA-03135: connection lost contact SurrKeyAgg: DBMS.CODE=ORA-03135 At row 1, link "LnKOtUpdtSurrke...

Thanks for your suggestions giving to me, am working on this issue