Hi,
There have been several posts realted to fixing Terasync table error which have been useful but I need to find where this table is being created. (as it gets dropped after the job is finished)
I have created following env variables in my DS project Administrator.
APT_TERA_SYNC_DAEMON_PROG = [server name for terasync table]
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]
I have intentionally given APT_TERA_SYNC_DATABASE name wrong (I have no access to create table in this database). But the job is not failing with Terasync table error. That means the parameter values are not what I have defined at PROJECT level and they are no being used. How do I find out where the terasync table is being created.
NOTE that the source teradata table domain is also not the terasync table domain because I do not have create table access to that domain.
Any feedback is appreciated.
Regards,
Vipin
Finding Terasync table database
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I guess keshav0307 read the section in the Parallel Job Advanced Developer's Guide that refers to environment variables, in particular the discussion of the APT_TERA_SYNC_DATABASE.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.