DataStage and DB2 session tables

I_Server_Whale · Post by **I_Server_Whale** » Tue Feb 24, 2009 12:50 pm

Hi all,

I'm being told to use DB2 session tables in DataStage jobs. Has anyone used DB2 session tables in DataStage? I believe that the session table will hold or be active only during that particular job run that the session table is used in and not across multiple jobs.

Is that a safe assumption? Any inputs on your experience with DB2 session tables would be greatly appreciated.

Regards,
Whale.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 24, 2009 5:35 pm

Who is doing the telling, and do they have any DataStage knowledge or experience?

What do "they" want you to achieve using session tables? How were you planning to do it?

Resist stupid requirements!!!

I_Server_Whale · Post by **I_Server_Whale** » Tue Feb 24, 2009 5:44 pm

You are absolutely right. "They" do not have DS knowledge and there in lies the problem.

Thanks for the response. I will be doing the telling from now on.

Slapping on my wrist and talking to myself "Wake up you sleepy head".

Thanks Ray!

Regards,
Whale.