Connection information set in the DBSERVERNAME configuration parameter
When a client application connects to a database server, it must specify the name for the database server. The sqlhosts information that is associated with the specified database server name describes the type of connection between the application and the database server.
DBSERVERNAME nyc_research
- In the ONEDB_SERVER environment variable
- In SQL statements such as CONNECT, DATABASE, CREATE TABLE, and ALTER TABLE, which specify a database environment
- In the DBPATH environment variable
The DBSERVERNAME must specify either the database server name or one of the database server aliases. The name must begin with a lowercase letter and can contain other lowercase letters, digits, and underscores. The name must not include uppercase characters, a field delimiter (space or tab), or a new line character. Other characters from the basic ASCII code set are not necessarily reliable. For example, a hyphen or minus sign can create problems and a colon might not work reliably. The @ character is reserved to separate the database from the server (as in dbase@server).
onimcsoc
or onsoctcp
protocols, you can update the
DBSERVERNAME configuration parameter to include the number of multiple listen threads for the
database server aliases in your sqlhosts information, as follows:
DBSERVERNAME name-number_of_multiple_listen_threads