Search found 4992 matches

by kcbland
Fri Oct 06, 2006 2:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Increasing user limit
Replies: 10
Views: 3293

Each citrix seat still counts as only one. Also, last I heard citrix is NOT supported, even if it does work for you.
by kcbland
Fri Oct 06, 2006 11:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: running datastage job from a datastage routine
Replies: 5
Views: 3242

I don't like to use these SDK functions as they are not performant, and even the versions that allow simultaneous usage are worse. I've written my own to manage this situation. What I can suggest to you is to add a second output link to your job at the same place where the assignment is occuring. Us...
by kcbland
Fri Oct 06, 2006 11:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Repository....
Replies: 8
Views: 2515

Hi.. I was asked this question in interview..Cleaning in the sence without deleting the project but the content of the project(i.e the temporary files that support the project content). Thanks, Jagan. If you don't know the answer to a basic question like this, you must have little or no practical e...
by kcbland
Fri Oct 06, 2006 10:06 am
Forum: General
Topic: Server setting problem
Replies: 17
Views: 9901

DataStage is simply executing the Unix sort command on a file. Try writing a shell script to do the sort. If you can get that shell script to work, then just put that shell script into the Sequence Command stage.

Your problem is with the unix sort command and the file it is sorting. Fix that.
by kcbland
Thu Oct 05, 2006 10:18 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: OCI stage not available
Replies: 3
Views: 1841

Is this a Server or a TX question? Was your template project setup to have all plugins? If so, then using DS Admin to create a new project automatically copies that configuration. Otherwise, you'll have to add the plugin via the install CD.
by kcbland
Thu Oct 05, 2006 10:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running more than 3 jobs in a sequence- giving a fatal error
Replies: 9
Views: 2599

Monitor the server node that houses the DS Engine for cpu and disk bottlenecking. Also, check the T30FILES setting in the uvconfig. All jobs require resources for logging and status maintenance, and Sequences are simply Server jobs. If there are no resources for job control execution, or some tunabl...
by kcbland
Thu Oct 05, 2006 10:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Increasing user limit
Replies: 10
Views: 3293

The license validation has been problematic since way back. Each version works a little bit different. One version of 7.5 counts every client as a license seat in use, so if I start 10 Designers, I've used up a 10 seat license. If 10 folks startup a Director each, then there's no seats left for Desi...
by kcbland
Thu Oct 05, 2006 7:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: optimum stages per job?
Replies: 7
Views: 1463

There's a difference between theory and practice. When attempting to set a land-speed record, do you see them driving a car in any other manner than a straight line? Do you see that the engine is tuned for a high-performance full power run with no clutch or automatic transmission? Do you see that th...
by kcbland
Thu Oct 05, 2006 7:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Increasing user limit
Replies: 10
Views: 3293

License connections are driven off the MAC and IP address, if you can figure out a way to spoof those then I think you can get around the security. Otherwise, welcome to IBM pricing schemes.
by kcbland
Thu Oct 05, 2006 4:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequencer getting errors trying to run
Replies: 4
Views: 2281

If job control is having issues getting info from log and status files, it's probably a maximum dynamic hashed files open issue. Can you confirm your T30FILES setting in the uvconfig file? If it's too low, like the default 200, then you can't properly execute jobs. The entire repository is based on ...
by kcbland
Thu Oct 05, 2006 4:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error when Running a Multiple Instance Job using DSJOB -run
Replies: 2
Views: 1939

You're running in project: SRA_dev job: SRADMckPrchHL390.0 ? Make sure that the job is compiled. Verify the EXACT spelling of the jobname and project. The error message indicates the job can't be found.
by kcbland
Thu Oct 05, 2006 4:01 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: More a question of IBM support....
Replies: 10
Views: 6501

I think the tools are going to evolve in a way that serves the larger IBM picture, rather than try to be best of breeds for niche markets. The ability to pick and choose flavours will disappear, as the toolset as a whole takes on more of a component architecture on a common subsystem, rather than 5 ...
by kcbland
Thu Oct 05, 2006 3:05 pm
Forum: General
Topic: How to RUN a DataStage Job/Sequencer from UNIX
Replies: 3
Views: 9489

This might give you some pointers:

http://www.dsxchange.com/viewtopic.php?t=85578
by kcbland
Thu Oct 05, 2006 10:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date format from flatfile to oracle database
Replies: 13
Views: 4482

How about a derivation of inlink.col[1,4]:"-":inlink.col[5,2]:"-":inlink.col[7,2]:" ":inlink.col[9,2]:":":inlink.col[11,2]:":":inlink.col[13,2] and then let auto-generated SQL add the to_date for you automatically?
by kcbland
Thu Oct 05, 2006 9:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Basic program to monitor path
Replies: 23
Views: 6485

Please stop talking about path. The terminology is "working directory", or PWD. When a DataStage job executes a shell command, the PWD is the project. You can verify this by using the Unix command "pwd". If the DataStage job were to execute this in DSExecute, you should see the fully qualified path ...