Job Session ID

sachinag · Post by **sachinag** » Wed Jan 05, 2011 11:55 pm

Hi,

I want to populate Job Session ID (Datastage tool session id for that job) in my Datastage Job.This session id value i have to pass a column value to my job which will further loaded to table.

Please provide me some solution on this.

Regards,
Sachin Gupta

ray.wurlod · Post by **ray.wurlod** » Thu Jan 06, 2011 12:45 am

There isn't one.

You have to derive it by whatever mechanism you prefer.

All DataStage job runs are independent of each other and therefore do not require any Session ID.

sachinag · Post by **sachinag** » Thu Jan 06, 2011 2:43 am

Hi,
Thanks for your reply,

I want to capture the instance ID that datastage engine creates to run any datastage job such as PID number in Unix.

Regards,
Sachin Gupta

ray.wurlod · Post by **ray.wurlod** » Thu Jan 06, 2011 4:16 am

A DataStage job can generate many process IDs. For example a ten stage job running on four nodes may generate 45 processes. Which one do you want?

Sreenivasulu · Post by **Sreenivasulu** » Thu Jan 06, 2011 5:12 am

As Ray mentioned datastage generates multiple unix process ids in a parallel enviroment. If you want a unique identification number for a process then you can use the 'job start timestamp' as a unique number.

Regards
Sreeni

ray.wurlod · Post by **ray.wurlod** » Thu Jan 06, 2011 3:35 pm

Maybe. Unless you manage to start two at the same second. Granularity of job start timestamp is only whole seconds.