DBSERVERNAME configuration parameter

Use the DBSERVERNAME configuration parameter to specify a unique name that you want to associate with the database server. You specify this configuration parameter when you install the database server.

onconfig.std value
Not set. A database server name is not defined.
if not present
On UNIX: hostname

On Windows: ol_hostname

The hostname variable is the name of the host computer.
values
A database server name that has a maximum length of 128 bytes.The database server name can be optionally followed by a minus sign and an integer from 1 - 50 that specifies the number of multiple listener threads to use for the onimcsoc or onsoctcp protocols. The default number of listener threads is 1. For example, the following database server name has four listener threads: ifxserver-4. The listener thread number is ignored for other protocols.
A database server name must begin with a letter and can include any printable character, except the following:
  • Uppercase characters
  • A field delimiter (blank space or tab)
  • A newline character
  • A comment character (#)
  • A hyphen or minus ( = ASCII 45) character
  • The @ character
  • A blank space
takes effect
After you edit your onconfig file and restart the database server and update the sqlhosts file or registry of each database server. In addition, the INFORMIXSERVER environment variable for all users might need to be changed.

Usage

The database server name is associated with a communication protocol that is specified in the sqlhosts file or registry. If the database server uses multiple communication protocols, define values for database server names with the DBSERVERALIASES configuration parameter.

Client applications use the database server name in the INFORMIXSERVER environment variable and in SQL statements such as CONNECT and DATABASE, which establish a connection to a database server.
Important: To avoid conflict with other instances of Informix® database servers on the same computer or node, you should use the DBSERVERNAME configuration parameter to assign a database server name explicitly.

For Informix MaxConnect users, the value of the INFORMIXSERVER environment variable on the client must match either the value of the DBSERVERNAME configuration parameter or one of the entries of the DBSERVERALIASES configuration parameter.

High-availability cluster servers that use shared-memory connections must also have TCP connection aliases for server-to-server communication. If a high-availability cluster server's DBSERVERNAME is associated with a shared-memory sqlhosts file entry, you must create a TCP alias for the server by setting a DBSERVERALIASES value, setting the HA_ALIAS configuration parameter to the DBSERVERALIASES value, and then creating a TCP sqlhost file entry for the alias.


Copyright© 2019 HCL Technologies Limited