Search found 4605 matches

by kduke
Tue Oct 25, 2005 4:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Profile all Jobs end-to-end
Replies: 16
Views: 10936

Ken Bland ... Kim Duke. My name is KIM.
by kduke
Tue Oct 25, 2005 4:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Profile all Jobs end-to-end
Replies: 16
Views: 10936

Instead of posting this much code why not have a link to your web site. It is really hard to cut and paste of these types of posts. I have also tried to do these types of posts and people complained. Zip them up into one complete download on your site and add a readme.txt to use it. I think you will...
by kduke
Mon Oct 24, 2005 5:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Improving Performance
Replies: 9
Views: 2786

Rajeev

This is a server question. Nodes are only on Parallel Extender jobs.
by kduke
Mon Oct 24, 2005 5:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job process id
Replies: 4
Views: 2044

There are also DataStage Engine commands to also deal with these processes. These are called TCL commands. Do a search. Most are easily accessed by using the DS.TOOLS menu.
by kduke
Mon Oct 24, 2005 5:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job process id
Replies: 4
Views: 2044

If you run a process in UNIX then it assigns a process id or PID that it is unique at the time of the run. These numbers are reused at some point. So tomorrow or next week you could get the same number but no 2 processes will have the same PID at the same time. UNIX gives you several commands to vie...
by kduke
Sat Oct 22, 2005 10:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dynamic hashed files and Static hashed files - pros and cons
Replies: 7
Views: 1474

If I plan on being at a site for awhile then static is fine otherwise I do not trust the developers to know how to resize a file or even know if it is bad. So few people even monitor stats as to rows per second or anything of that nature. Take a poll and you will see how few have statistical data on...
by kduke
Sat Oct 22, 2005 10:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityHashLookup calling
Replies: 10
Views: 2433

It will not search for something. It will only read something if you give it a key value and either key exists or it does not exist.

Why are you using this instead of a hash file lookup?
by kduke
Fri Oct 21, 2005 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UtilityHashLookup calling
Replies: 10
Views: 2433

Null means it does not exist. What do you want it to do?

You can copy this routine and make your own version and return @TRUE if found or @FALSE if not.
by kduke
Fri Oct 21, 2005 5:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: improve performance in Transaction Handling tab
Replies: 6
Views: 1673

This is a server job topic. You are talking about a PX job config file. This is also an old topic. Please do not post to old topics.
by kduke
Mon Oct 17, 2005 7:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Releasing Read only
Replies: 6
Views: 1307

All TCL commands work in one account only. A project is an account. There are ways to create links called q-pointers to other accounts. Look it up if you need this feature.

You need to

LOGTO account

To switch accounts or projects if you will.
by kduke
Sat Oct 15, 2005 5:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Returning stage variable value to Control job
Replies: 5
Views: 1491

You have to output it to a hash file or a sequential file. You could write it to the log every time it changes.
by kduke
Fri Oct 14, 2005 5:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job dependency list
Replies: 2
Views: 1153

When you use job add then the jobs in the dependecy list on the job properties.
by kduke
Thu Oct 13, 2005 4:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: copy of jobs
Replies: 2
Views: 696

If you know TCL then READONLY is a field in most of the repository tables. It needs to be 'NRO' for not read only.
by kduke
Wed Oct 12, 2005 6:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: get the job status on UNIX cmd-line ?
Replies: 11
Views: 4112

0,1,2,3 should be correct. Fit it if it does not work like you want it to.