DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 5012 matches
Author Message
Resolved
 Topic: How to find the number of users logged into Data Stage?
kcbland

Replies: 5
Views: 2299

PostForum: General   Posted: Thu Apr 16, 2009 10:07 am   Subject: How to find the number of users logged into Data Stage?
Jobs running should have either an osh process or a phantom process. Do a "ps -ef|grep phantom" to see what's out there running. As for connected Clients, look for dsapi as Craig has shown. You'll ...
 Topic: Sequence problem
kcbland

Replies: 8
Views: 3671

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Apr 16, 2009 9:01 am   Subject: Sequence problem
How would the setup impact whether the job was run directly or thru a Sequence? I'm not aware of any difference other than userid and parameters that could be the impact...A trusted connection would ...
 Topic: Sequence problem
kcbland

Replies: 8
Views: 3671

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Apr 16, 2009 8:37 am   Subject: Sequence problem
Running from a Sequence indicates that a parameter issue may be the case. The Sequence must be running the job with other values. Also, if your Sequence is running as a different userid that would i ...
 Topic: Update table directly from a routine
kcbland

Replies: 3
Views: 1338

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Apr 16, 2009 7:26 am   Subject: Update table directly from a routine
We've responded a lot to this question but you are ignoring us. Connecting to a database from a routine requires you to do things not natively supported in the tool. The easiest way to do gain unsup ...
 Topic: conncting a database from a routine
kcbland

Replies: 23
Views: 5667

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 15, 2009 10:02 am   Subject: conncting a database from a routine
Return codes from a routine used in a before/after job/stage call aren't easily accessible. If you're calling from a Sequence a DS BASIC Routine you have access to the return code easily and could pa ...
 Topic: Fault type 11 - Abnormal Termination
kcbland

Replies: 7
Views: 6177

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Apr 15, 2009 7:56 am   Subject: Fault type 11 - Abnormal Termination
Abnormal Terminations can occur when you do math on NULL values. A reference lookup can introduce NULL values on non-found lookup rows. Look at your expressions in column derivations and constraints ...
 Topic: Aggregator performance
kcbland

Replies: 6
Views: 1951

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 14, 2009 12:57 pm   Subject: Aggregator performance
Look at your cpu utilization - if it's at 100% then it means that you are cpu bound. If it isn't, there's a chance you're paging/swapping memory/disk and could improve performance. Sorting first wil ...
Resolved
 Topic: Exporting Project level Director log
kcbland

Replies: 6
Views: 1623

PostForum: General   Posted: Tue Apr 14, 2009 11:42 am   Subject: Exporting Project level Director log
Every job has its own log file, no matter what a loop thru a list of jobs is required to output all of the logs. Plus, you may only wish a limit on the output from the log. The best idea is to integ ...
Resolved
 Topic: Routine returning invalid results
kcbland

Replies: 12
Views: 3087

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Apr 14, 2009 10:26 am   Subject: Routine returning invalid results
Take your Routine and paste the logic into a Batch:: style job. Add DSLogInfo() lines to write output to the job log. For developing long routines or functions this can be a useful device. Once you ...
Resolved
 Topic: Slow Dynamic Hash File
kcbland

Replies: 10
Views: 3543

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 13, 2009 9:20 pm   Subject: Slow Dynamic Hash File
Look at the i/o on the filesystem holding the hashed file and make sure it's not running 100%. Install top and watch the cpu utilization (you could look at DS Monitor and look at cpu usage, but that' ...
Resolved
 Topic: dsjob command not working
kcbland

Replies: 7
Views: 3116

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 13, 2009 5:01 pm   Subject: dsjob command not working
Fully qualify the hostname/userid/password and see if that works...
Resolved
 Topic: Delays between Job Sequences / Calling Next Job
kcbland

Replies: 20
Views: 7457

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Apr 08, 2009 12:48 pm   Subject: Delays between Job Sequences / Calling Next Job
By saying ALL jobs are slower, we can't easily help pinpoint problems. If we could talk about a specific job then we can focus in on exact issues.

For example, if a job runs twice in the same da ...
Resolved
 Topic: Speed up a hash Lookup (Partial Key) created and build index
kcbland

Replies: 13
Views: 4054

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 06, 2009 1:49 pm   Subject: Speed up a hash Lookup (Partial Key) created and build index
Your example clearly shows why hashed files should be used in equi-joins as a first and best choice. I suggest you involve a database and use work tables there.
 Topic: CHAR to TIMESTAMP
kcbland

Replies: 1
Views: 1340

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Apr 06, 2009 1:43 pm   Subject: CHAR to TIMESTAMP
Make sure your CHAR data looks like a TIMESTAMP, if not reformat it to look like a TIMESTAMP. If loading into a database make sure generated SQL correctly casts (like with a TO_DATE) else write your ...
Resolved
 Topic: confusion and request for help setup Windows UNIX datastage
kcbland

Replies: 9
Views: 4096

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 02, 2009 10:09 am   Subject: confusion and request for help setup Windows UNIX datastage
In case I wasn't absolutely clear - you buy a Windoze license and it only installs on Windoze.
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours