Search found 4992 matches

by kcbland
Thu Oct 28, 2004 9:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsprcd starts, but not the rest of the services
Replies: 4
Views: 1635

Clients connect under the process names of dscs and dsapi in the ps table. Using netstat is one of the 2 required steps to making sure there are no active process, ps is the other. That has always been true, the issue is the constant renaming of processes from uvcs to dscs; from uvapi to dsapi; unir...
by kcbland
Thu Oct 28, 2004 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Stage Variables
Replies: 3
Views: 1097

Put all of your source data into a hash file and use the date as the key. Then, read the source again and reference the hash file four times. In each reference key expression, use your date value +1, +2, +3, and +4. Since most next business days will be the next day, on 5/7 attempts the +1 row will ...
by kcbland
Thu Oct 28, 2004 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsprcd starts, but not the rest of the services
Replies: 4
Views: 1635

You need to verify that your dsenv file does not contain errors. The startup script parses this file and you probably have errors that are preventing it from correctly parsing. I suggest you revert to your saved "before" copy and restart your services. By the way, the reason services don't start aga...
by kcbland
Mon Oct 25, 2004 10:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS windows ntlogin
Replies: 1
Views: 542

None. DS on unix uses the unix login to that server.
by kcbland
Fri Oct 22, 2004 8:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set default Params
Replies: 2
Views: 687

It works up to 7.1, haven't heard from anyone using 7.5 if it still works. The help text is one of 18-20, but I'm not sure. I did see from looking at the data that it looks to be associated from the fact that I saw delimiting multivalue marks on all of those attributes and assumed they're part of th...
by kcbland
Thu Oct 21, 2004 10:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance job logs
Replies: 18
Views: 6920

Why use date? Could you use a fixed range of numbers, thereby reusing the instance? Since you're using hour, could jobname.hournumber suffice? You'll have 24 instances fixed in the status view, and can utilize the purging capabilities.
by kcbland
Thu Oct 21, 2004 10:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Directory name containing a space
Replies: 4
Views: 1186

You may be running afoul of the "quotes inside quotes inside quotes" issue common to any language that has OS shells. You're best bet is to write a dynamic (temporary) shell script and execute that. By constructing it on the fly, then executing it, you avoid a lot of these hassles. Sorry, that's jus...
by kcbland
Thu Oct 21, 2004 9:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance job logs
Replies: 18
Views: 6920

Sorry, I've confused myself. You're talking about getting rid of job invocations, not log entries. How to get rid of job invocations that have a date as the invocation id, meaning an infinite number of invocations. Craig's suggestion is to recompile the base job, which removes all invocations. You n...
by kcbland
Thu Oct 21, 2004 8:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance job logs
Replies: 18
Views: 6920

When you use the APIs to access the log of an instance, it returns all messages across all instances of the root. You will have to discriminate the rows that pertain to the instance you have interest in. As far as Director is concerned, the only way to filter log messages on an instance is to change...
by kcbland
Thu Oct 21, 2004 7:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance job logs
Replies: 18
Views: 6920

After each instance run extract the log rows for that instance run and tuck it away in your own repository table. Basically "roll your own". Set the purge to be daily and ignore DataStage's log completely.
by kcbland
Thu Oct 21, 2004 3:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Qucik question on Multiple Key lookup
Replies: 8
Views: 2181

Beat 'cha
by kcbland
Thu Oct 21, 2004 2:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Qucik question on Multiple Key lookup
Replies: 8
Views: 2181

You will have to put two links to the hash file, using 1 as the expression in the first link, and 2 as the expression in the second link. You'll double-tap the hash file, but that's your requirement. You will need to decide which takes precedence, the 1 row or the 2 row, because you may have both ro...
by kcbland
Thu Oct 21, 2004 2:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to create file
Replies: 2
Views: 747

Reboot your server. Sorry, your locks are probably being held by Windoze, make sure you don't have any virus software running on the server.
by kcbland
Thu Oct 21, 2004 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading Hash File
Replies: 14
Views: 3217

Search the forum, we've covered this before. It's in the uvconfig file, so requires a uvregen and is a server wide setting, affecting all projects.
by kcbland
Mon Oct 18, 2004 12:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Setting up Account Name in Hash File Stage
Replies: 5
Views: 948

Leaving the field blank will default the job to creating/looking for the hash file in the project. By explicitly naming the account (project), you "lock" the hash file to that named project. Better to use a job parameter in this field. However, leaving it blank works the best since it doesn't care w...