Increase the speed of the CLIv2 logon process by limiting the number of host name resolution requests issued by the applications.
-
Set an environment variable with the name equal to the machine name with a specified number of COPS available for it.
set machine_name=cops
- machine_name
- name of the Teradata Database system, or tdpid
- cops
- number of COPS
-
Open the System Properties dialog box.
Tip: To open the dialog box, open a command prompt and type SYSDM.CPL .
- Click the Advanced tab.
- Click Environment Variables and add or edit the machine_name system environment variable.
- Set the SHOGUN system environment variable to 3 as follows: set SHOGUN=3 Setting SHOGUN=3 causes CLIv2 to issue GetHostByName for SHOGUNCOP1, SHOGUNCOP2, and SHOGUNCOP3 only. If one of the GetHostByName requests fails, the successive requests are not issued.
- Add or edit the SHOGUN system environment variable.