Can you please let me know , how many number of session at a time will be accepted in TD15.10. I have many jobs whcih will be hitting teradata , for some jobs we are facing connectivity issue once we reran the job it was running god. I am using Datastage job to connect with teradata and shell scripts
Can you please let me know how many sessions TD15.10 will be accepting at a single run .. ?
Thanks in advance
By default there are two Parsing Engines per node, each allows 120 sessions, so the available number of session is 240 * number of nodes.
The number of PEs can be increased Usually done by Customer Suppprt), but before you do this you should check:
Also make sure you are using an approach that spreads connections across all available nodes, e.g. network aliases mytdCOP1 through mytdCOPn in DNS or hosts file, with just "mytd" prefix as the name in the connection, and "COP discovery" enabled (client driver default).