Editing Server Properties

Change general, configuration, and agent information, and options and values of properties for the selected server.

Prerequisites

Authenticate with Sybase IQ using an account that has DBA authority.

Task

In the Perspective Resources view, select a resource, then select Resource > Administration Console.
In the left pane of the Administration Console, select either:
- IQ Servers, or
- IQ Servers > Multiplex Management > Multiplex Servers
Select the resource in the right pane and either:
- Click the drop-down arrow to the right of the name and select Properties, or,
- From the Administration Console menu bar, select Resource > Properties.
Edit server properties.

Note: Configuration changes may take several minutes to complete. When you make a configuration change, a status dialog box displays the progress of the change.

Area	Description
General page	Server name – Name of the server. Host – Host name where the server is running. Port – Port where the server is running. Database – Database name. Server version – Server version number. Platform – Platform the server is running on. Platform version – Version of the operating system where the server is running. Type (simplex server) – Server type: Single Server. Type (multiplex node) – Server type: Reader, Writer, or Coordinator. Status (multiplex node) – Server status: Include or Excluded. Designated Failover Node (multiplex node) – True or False. If true, then this server is the designated failover node.
Configuration page (multiplex node only)	Server name – Name of the server. Public Host/Ports (multiplex node) – Public host names and port numbers. Private Host/Ports (multiplex node) – Information about private hosts and ports to be used. Database file path – Location of the .db file.
Options page (multiplex node only)	Current time – The current time. Refresh – Click Refresh to update the current time. Quitting time – Enter a time for the database server to shut down. Use the same format as the current time: YYYY-MM-DD HH:NN:SS.SS Disable new connections – Prevent other users from connecting to the database. This may be useful for some maintenance operations. Remember last statement – Instruct the database server to capture the most recently prepared SQL statement for each connection to a database on the server.
Agent page	Agent registered – Indicates if the Sybase Control Center agent is registered: true or false. Agent authenticated – Indicates if the Sybase Control Center agent is authenticated: true or false. Agent status – Status of the Sybase Control Center agent: Running, Stopped, or Unknown. Agent host – Name of the host machine where the Sybase Control Center agent is running. Agent port – Port number on the host machine where the Sybase Control Center agent is running. Agent user – User name for authentication of the agent. Default is `uafadmin`. Agent process owner – The user name that owns the agent process. Agent home – The home directory of the Sybase Control Center agent. Agent version – The version of the Sybase Control Center agent. SCC agent plugin version – The agent plugin version of the Sybase Control Center agent. IQ directory – Installation directory of the IQ server with which the Sybase Control Center agent is associated. IQ version – Version of the IQ server with which the Sybase Control Center agent is associated.
Server Properties page	Properties – The name, value, and description of all server properties.