DSXchange

Hi, When using TeraData Enterprise stage be sure to use "DBOptions". Like this : user=myuser,password=*******,SessionsPerPlayer=2 you can add as well, the "RequestedSessions" option. There is a relation between the "SessionsPerPlayer", the number of nodes and the result...

Adam, We are using the TeraData Enterprise stage and we are facing the same problem. Usually the 2 error tables created by the Fastload are dropped. In case of a problem ( duplicate primary index key for example ), the error table #2 should be removed manually. The names of the two tables are ERR_co...

I only use the followings: APT_TERA_SYNC_DATABASE = [db name for terasync table] APT_TERA_SYNC_USER = [user name used for terasync table] APT_TERA_SYNC_PASSWORD = [password for user used to access terasync table] In our configuration ( I mean Teradata configuration), there is no need to configure th...

Hello, This is a quite frequent question when using Teradata and DS EE. DS EE use and create a table named "terasync". So you need to use a user with CREATE TABLE rights. By default the terasync table is created on the database you use in your stage. But you can use the DataStage environme...

Christina, May I ask what UNIX do you use? And one more question : do you have DataStage installed with user "dsadm" or "root"? We had that kind of troubles on HP-UX with installations done using "dsadm". You can go check the JobMonApp log file in ../PXENgine/java in or...

Hello everybody, I am looking for some feedback about a successful experience of DataStage Enterprise Edition used with Computer Associates eTrust Access Control. We are facing lots of difficulties to have Enterprise Edition 7.5 work with eTrust on our HP-UX 11.11 system. Seems Enterprise Edition is...

Hi, I also configured a simple job to have a user defined env var. the env var is showing in the log for the run but no file is created. I tried full path and directory path only but still no data seems to be generated. have anyone successfully used this option? Thanks in advance, Hi Roy, I gave $A...

I wanted to finalize the thread with the solution we found regarding that issue. We were wrong, that was not an installation problem : the problem was due to the AIX 5.2 Maintenance Level 4 applied over the existing AIX 5.2 Maintenance Level 2 system. The xlC.aix50.rte.6.0.0.0 runtime library was ch...

Thanks Ray, Right now, I am still waiting for some feedback from support. But I am convince you are right ( Transformer stage is not working in other projects) . You confirmed what I was afraid of : uninstall and re-install! Regards, Daniel Welcome aboard! :D Bienvenue! It appears that something odd...

Hello When trying to run an existing working application on a freshly installed new system ( IBM P595, AIX5.2, PX 7.0.1 ) , I got a fatal error when running a job : "main_program: Fatal Error: Duplicate name registration for: transform, APT_TransformOperator" Other jobs that do not use the...