Teradata Enterprise Stage - setting for Tenacity and Sleep

etlbets · Post by **etlbets** » Tue Nov 27, 2007 4:35 pm

I am using Teradata Enterprise Stage in DataStage 7.5.2 to load large amounts of data to several different tables.

Does anyone know if it is possible to set Tenacity and Sleep in "Additional Connection Options"? And if so, what is the syntax?

Thanks

throbinson · Post by **throbinson** » Tue Nov 27, 2007 4:42 pm

Wow deja vu! I just asked IBM Support this very question. I will let you know if I ever hear back from them. Two undocumented Additional Connections options I DO know are;
workdb=
synctimeout=

Are there others?

etlbets · Post by **etlbets** » Tue Nov 27, 2007 5:54 pm

We are using 2 others:

requestedsessions=16
and
sessionsperplayer=2

keshav0307 · Post by **keshav0307** » Sat Apr 19, 2008 5:40 am

requestedsessions= sessionsperplayer * number of nodes used in the job

throbinson · Post by **throbinson** » Tue Jun 10, 2008 8:11 am

It is now possible. There is a patch from IBM. I just tested it and it appears to work.

pathmaker · Post by **pathmaker** » Tue Jun 10, 2008 12:33 pm

you can set all at the same place

requestedsessions=16,sessionsperplayer=2,TENACITY=5,SLEEP=9

-pratap