Teradata connection issue
Moderators: chulett, rschirm, roy
To use the Teradata Enterprise Stage, you need a Terasync table set up with write access to it. Go through the Parallel Job Developer's guide for details on the Teradata Enterprise Stage and also the Parallel Job Advanced User's Guide (Teradata Environment Variables).
Try the Teradata API stage - which would work without the terasync table.
Aneesh
Try the Teradata API stage - which would work without the terasync table.
Aneesh
Maybe this will help -
viewtopic.php?p=123206&highlight=#123206
viewtopic.php?p=123206&highlight=#123206
thebird,
i think the issue we're having is different from that. we are able to connect in server job using the same user. do you think i should still try the following steps from other link you gave me? Also i'm not quite following what i should do. do i have to create a WORKDB env variable..is that all i have to do?
i think the issue we're having is different from that. we are able to connect in server job using the same user. do you think i should still try the following steps from other link you gave me? Also i'm not quite following what i should do. do i have to create a WORKDB env variable..is that all i have to do?
In the Server version, you dont have a Teradata Enterprise stage. The Enterprise stage and the API stage work differently.
First check if you you have enough Perm space and Spool. (the developer's guide say atleast 100 MB of perm and 10 MB of spool) in the database that you are trying to acess. If this is fine check if you create and write permissions on the DB.
If you do not have permissions, then create the following environment variables -
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]
The APT_TERA_SYNC_DATABASE should be created where you enough space and previlege.
If you do a seach as I suggested earlier, you will get a lot of help on this topic.
First check if you you have enough Perm space and Spool. (the developer's guide say atleast 100 MB of perm and 10 MB of spool) in the database that you are trying to acess. If this is fine check if you create and write permissions on the DB.
If you do not have permissions, then create the following environment variables -
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]
The APT_TERA_SYNC_DATABASE should be created where you enough space and previlege.
If you do a seach as I suggested earlier, you will get a lot of help on this topic.