DSXchange

you can set all at the same place

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

-pratap

Background - We do not have a DataStage Administrator and would like some pointers on how to establish a odbc connection to a DB2 database and also a few related questions. 1) Does the remote database need to be cataloged on the ETL server? no 2) What does cataloging do on the ETL server? catalog c...

There are couple of bug's that IBM fixed on ODBC and DRS stage. contact tech support for them -pratap Hi, I am using ODBC stage to read the data from SQL Server to put into a sequential file. I am just using select * from <tablename> as the query in the ODBC stage. But strange, Data from the charact...

:? Haven't we already had this conversation? A 32bit application can connect to a 64bit database using the 32bit libraries the database provides. Simple. No routine or other shenanigans 'needed'. ... DataStage does not support connecting to the 64bit client and this will not work. You can still hav...

yeah its me pratap who named him "Mamu" , i am kim work together he is my sweet uncle

Always good practise to have double number of requestedsessions per node in config file and leve 2 sessions per player is good so if you have 2x2 config file set your requestedsessions to 4 and optionally you can set sessionsperplayer to 2 as its defaulted to 2 (always) you can set these on enterpri...

u need to specify TENACY and SLEEP as well so that the load wont fail if the limit exceeds it will wait untill TENACY and SLEEP setting ..

as explained you need to have previlages to create terasync table on the database where you have your table that you are reading/writing teradata ent uses this table to log the sql commands that it is using aganist the table that you are reading/writing and terasync table that you created. if yo spe...

your datastage might be installed on cluster. logon to apropreate system where /etlfs10/ is mounted use mount command to make sure you have that file system available coming to your issue .. Teradata utilities create Log table error tables during the load process ,if you happen to fail during the pr...

you need to register quality stage for datastage this step should be carried for every project that you have in datastage.

contact your admin for more info

pratap

Yes , where ever ODBC can reach profile stage can reach there. i mean source analysis should be done using odbc connections not native connection you can generate datastage job from profile stage. not sure about plug-in ? what do you mean ? -pratap Hi I am new to profile stage. shell i use any kind ...

This is a known issue , got fixed in 7.5.2 . you can ask for patch if yours is prior version. contact tech support I had this problem in the past and I thought I remembered the solution, but nothing I have tried has resolved the problem. The source is Teradata usig Fastload and the fields in the que...