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.

For example, to assign the name nyc_research to a database server, set the DBSERVERNAME value in the onconfig file or Windows registry key:
DBSERVERNAME nyc_research
Client applications specify the name of the database server in one of the following places:
  • In the INFORMIXSERVER 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).

For 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

You can configure DBSERVERALIASES connections as SSL connections, and you can have a mix of SSL and non-SSL connections.

Copyright© 2019 HCL Technologies Limited