Hi,
What are the areas in datastage to look upon for tunning job?
Say for upserts what should be the transaction array size?
for insert updates what should be the transaction array size?
If anybody has more suggestions then please let me know?
Also i want to run the job on sun solaris unix.What command should i fire form the shell prompt?
Thanks in advance.
Nilesh
What are the areas in datastage to look upon for tunning job
Moderators: chulett, rschirm, roy
What are the areas in datastage to look upon for tunning job
Nilesh Malekar
please search on "Transaction Array Size" for a lot of posts on this Pubject. The command "dsjob" can be called from the Solaris (and HPUX,AIX,Linux,Windows) command line to start jobs.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When you run the job from Director, select the Tracing tab in the Job Run Options dialog and enable statistics collection for each active stage. The gathered statistics can be used to provide finer detail as to where each stage is spending the majority of its time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.