Registering the SAP Sybase IQ Server

Sybase Control Center can manage many SAP Sybase resources. Register your SAP Sybase IQ server to identify the server and provide its connection information to Sybase Control Center.

Prerequisites
Ensure that the SAP Sybase IQ server does not have multiple databases. Sybase Control Center for SAP Sybase IQ supports a maximum of one database per server.
Task

The Perspective Resources is open by default.

  1. From the main menu bar, choose Resource > Register.
    SCC starts the Resource Registration Wizard and prompts you to define the resource:
    Title Field Names Description

    Resource Type

    Resource name

    Resource name, type and description.

    Use <localhost>_iqdemo as the Resource name and identify the Resource type as an IQ Server. Description is optional.

    Resource type

    Description

    Connection Information

    IQ host name

    JDBC connection information:

    Use <localhost> as the IQ host name and 2638 as the IQ port number. Entering the Database name (iqdemo.db) is optional.

    Note: Sybase Control Center for SAP Sybase IQ supports a maximum of one database per SAP Sybase IQ server.

    IQ port number

    Database

    Authentication Information

    IQ Username

    Demo database user name and password.

    Use DBA or dba (case-insensitive) as the IQ Username and sql (case-sensitive) as the IQ Password.

    IQ Password

    Options

    Post registration options

    Choose Add this resource to the current perspective and (if Resource Explorer is closed) Open the resource explorer to view this new resource.

  2. Click Finish.
    This step closes the Resource Registration Wizard. Perspective Resources now lists <localhost>_iqdemo as an SCC resource.
  3. On the Perspective Resources dialog, click the drop-down arrow next to the server name, choose Authenticate.
  4. On the Authentication dialog, enter your authentication information.
    For the Quick Start, SCC uses the demo database login as the authentication credentials. Choose Specify different credentials. Use DBA or dba (case-insensitive) as the IQ Username and sql (case-sensitive) as the IQ Password. Choose Remember these credentials for future sessions.
  5. Click OK.