DSXchange

ray.wurlod

Ya just can't afford vacations in this industry! Or did "she who must be obeyed" set you to chores again, and wouldn't let you log on till they were all done?

ray.wurlod

Are you using the default TCP port numbers? Is there any firewall software? Have you configured DataStage to use ssh rather than rsh? You can enable environment variables such as APT_STARTUP_STATUS and APT_PM_SHOWRSH to help to determine what's happening.

ray.wurlod

It's usually within 24 hours. Walter, would it be possible to program in a grace period for renewals?

ray.wurlod

It makes you wonder how they discover stuff like "make sure there's a space before 'noexec=off'"! Did they bother to explain what the problem was, and why this was the fix?

ray.wurlod

And here is your chastisement for hijacking a thread. Your problem is not the same as that of the original poster.

If you have a new question, start a new thread. It helps future searchers.

ray.wurlod

Status is reported through stderr (it is documented thus).

Redirect file unit 2 to an appropriate file (or even to the same file).

Code: Select all

$DSHOME/bin/dsjob -lparams $project $jobname > Somefile.txt 2>Error.txt

$DSHOME/bin/dsjob -lparams $project $jobname > Somefile.txt 2>&1

ray.wurlod

'nother question, 'nother thread please. It helps future searchers.

ray.wurlod

Just put the column name in double quotes in the SELECT statement. Otherwise the "-" character could be interpreted as a request to perform subtraction. And/or you can use an alias column name in the SELECT statement; there's no need to create a view.

ray.wurlod

No-one's yet reported what changed.

ray.wurlod

So you can mark the thread as resolved, then?

ray.wurlod

The deadlock daemon is not governed by any environment variable.

Its auto-start is configured in a file called dsdlockd.config in the DataStage engine directory.

You can check to see whether it's running by looking for its process using UNIX commands.

Code: Select all

ps -ef | grep dsdlockd | grep -v grep

ray.wurlod

Try using DSU.UtilityHashLookup instead of UtilityHashLookup.

Try using the Trans() function instead. It's more efficient for performing a key-based lookup against a hashed file that's been named in VOC.

ray.wurlod

In INIT, do not check the "log warning if finished other than OK".

ray.wurlod

Read the message carefully. Check the data to ensure that there are no embedded newline characters. Check the job log for "import failed" warnings. Use reject links to capture such rows. When you posted it was 2:43am in my current location, and I was sleeping. You made no case for urgency. If you wa...

ray.wurlod

What other errors/warnings are logged? After the job aborts, reset it in the Director and examine any event logged "from previous run...". It might be something simple, like one of the parameters not being passed correctly, or the DB2INSTANCE environment variable not being set. Check the first four ...

Search found 53125 matches