To change values of System environment variables

Document Sample
To change values of System environment variables Powered By Docstoc
					                                                RPS Version 4
                                       Optimizing Database Performance
                                             ASA Temporary File

Windows NT – Changing Environment Variables

Adaptive Server Anywhere creates a temporary file that is used for various database operations such as
sorting and performing unions. The temporary file is placed in the directory specified by the TMP,
TMPDIR, or TEMP Environment Variable. If the environment variables are not defined, the temporary file
is placed in the current working directory on the NT server. The overall Database performance can be
improved if the ASA temporary file is located on a physically separate drive from where the database
(rps.db) or log (rps.log) files are located (see Notes and Tips). To redirect where the temporary file is
created, the System Environment Variable will need to be added or modified.

To add System environment variables:

1         Stop the ASA Database Engine
2         Click Start Menu / Settings / Control Panel / System
3         On the Environment tab, in the System Variable list, click any existing variable name.
4         In the Variable box, enter Environment Variable TEMP
5         In the Value box, type the location where temporary files are to be created. Eg. D:\TEMP
6         Click Set
7         Click Apply
8         Restart the ASA Database Engine and the database

To change values of System environment variables:

1         Stop the ASA Database Engine
2         Click Start Menu / Settings / Control Panel / System
3         On the Environment tab, in the System Variable list, click the name of the TEMP variable.
4         In the Value box, type the location where temporary files are to be created. Eg. D:\TEMP
5         Click Set
6         Click Apply
7         Restart the ASA Database Engine and the database


Notes and Tips:

          Only a NT administrator may add or modify the System Environment Variables on a NT Server.

          Please note, in order to improve database performance, the temporary file should be stored on a
          physically separate drive (i.e. a different hard drive existing on the same machine) from where the
          Database and Log files are located. By placing the information on separate physical drives it
          allows operations to take place simultaneously. Also, you should ensure that sufficient disk space
          is available for the temporary file.

          The directory specified in the Value box (e.g. D:\TEMP) for the System Variable must exist in
          order to redirect where the ASA temporary file should be created.

          Changes to the Environment System Variables do not affect programs that are currently running
          on the server. The ASA Database Engine will need to be shut down and restarted in order to see a
          result to the change of the Environment System Variable.

          Windows NT saves changes in the registry so they are available automatically the next time you
          start your computer.

          Each time the ASA server is started a temporary file is created for database operations. When the
          ASA server is properly shutdown, the temporary file is automatically removed from the NT
          server. However, when the ASA server does not have a normal shutdown, the temporary file will
D:\Docstoc\Working\pdf\d32651e3-6d22-4939-b0b9-10dd4f9faa1f.doc
Page 1 of 2

Last Revised: October 18, 2000
                                                RPS Version 4
                                     Optimizing Database Performance
                                            ASA Temporary File
          remain on the NT server until the file is manually removed. Having multiple temporary files on
          the NT server may adversely impact ASA performance. Therefore, the temporary files that ASA
          creates should be deleted from the NT server after experiencing an abnormal shutdown.
          Temporary files created by ASA should be deleted before restarting the ASA database server.

          The path value is created by appending the path contained in AUTOEXEC.BAT to path
          definitions on the Environment tab of the System option in Control Panel.




D:\Docstoc\Working\pdf\d32651e3-6d22-4939-b0b9-10dd4f9faa1f.doc
Page 2 of 2

Last Revised: October 18, 2000

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:6/23/2012
language:
pages:2