Make Sybase Control Center aware of a Sybase IQ resource (for example, a server that can be monitored) and its connection information by registering the resource.
Prerequisites
Ensure that the Sybase IQ server does not have multiple databases. Sybase Control Center for Sybase IQ supports a maximum of one database per server.
Task
In the Resource Explorer, select Resources > Register.
Specify:
New resource type details
Field
Description
Resource Name
(Required) Name of the resource to register. Enter the actual name of the server, including uppercase and lowercase letters. If the name registered in Sybase Control Center does not exactly match the server name, some monitoring functions may not work.
Resource Type
Select a resource type:
IQ Multiplex – register a Sybase IQ multiplex server.
IQ Server – register a Sybase IQ simplex server. Recommended. Can handle both simplex and multiplex servers.
Description
A brief description to help you identify the resource.
Click Next.
Specify the connection information for your resource:
New resource connection details
Field
Description
Host Name
(Required) Host name of the Sybase IQ server.
IQ Port Number
(Required) Port number on server host.
Database
Name of the database.
Character Set
Character set to use for the connection.
Language
Language to use for the connection.
(Optional) Enter a user name and password that SCC can use to authenticate with this resource to retrieve its software version. The credentials are used only for this purpose, then discarded.
If you prefer not to authenticate now, click I do not want to supply authentication information.
This step enables SCC to display the correct version information for the server before the server is formally authenticated (later in the configuration process).
Click Next.
(Optional) Click Add this resource to the current perspective. You must add a resource to a perspective (not necessarily the current perspective) before you can manage or monitor it.
(Optional) Click Open the resource explorer to view this new resource. (This option is not present when the Resource Explorer is open.)
The resource is added to the Resource Explorer even if you choose not to view it.