Help req for setting proper ENV variable

bhaskarjha · Post by **bhaskarjha** » Mon Jul 24, 2006 7:10 am

Hi,
My Server job runs fine when I run it from director. But once I schedule the job to run in future. It got aborted with message "Failed to allocate environment handle 'ENV'". Can anyone please suggest solution.
Thanks,

chulett · Post by **chulett** » Mon Jul 24, 2006 7:26 am

Odd... what operating system? I assume you are using Director to schedule the job, yes? And 'in future' means what - one time or a recurring number of times?

bhaskarjha · Post by **bhaskarjha** » Mon Jul 24, 2006 7:46 am

Hi,
Operating System is UNIX, I am scheduling my job (for daily run of job) from director.

ArndW · Post by **ArndW** » Mon Jul 24, 2006 7:56 am

Do you get the same error when you use the dsjob command from the UNIX command line to start your job?

bhaskarjha · Post by **bhaskarjha** » Mon Jul 24, 2006 8:11 am

Hi Arnd,
My job runs fine when I run it with dsjob command.

chulett · Post by **chulett** » Mon Jul 24, 2006 8:14 am

bhaskarjha wrote:Operating System is UNIX, I am scheduling my job (for daily run of job) from director.

Know that from your post.

Was wondering who's it was - HP-UX, AIX, etc. And the other question was to ascertain if you were into 'cron' or 'at' land. It will use cron for recurring schedules like 'every Monday' while 'at' is used for one-time runs - tomorrow at 8am, for instance.

bhaskarjha · Post by **bhaskarjha** » Mon Jul 24, 2006 8:19 am

Hi chulett,
The OS is AIX. I am not using 'cron' or 'at'. I am just scheduling my job from director for evryday (ex:- to run by 7 am in the morning).

ArndW · Post by **ArndW** » Mon Jul 24, 2006 10:08 am

When you schedule a job from the director in a default UNIX environment it will use "cron"; DataStage does not have it's own scheduler.

Once you've scheduled the job, look at your crontab to see what the actual command is that is being issued. Also remember that this process needs to have the dsenv set and find the dsjob command in it's command path.

DSguru2B · Post by **DSguru2B** » Mon Jul 24, 2006 12:32 pm

Probably create a small script that sources the dsenv file and then executes your job.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 24, 2006 4:11 pm

ENV is a reserved word - it's the DataStage command for getting and setting environment variables. Use a different name.