Minimally Configuring Adaptive Server in GUI Mode

Use GUI mode to minimally configure Adaptive Server and related products for use.

  1. If you installed the Adaptive Server plug-in, select enable or disable to remember the Adaptive Server password, then click Next.
  2. Depending on the products you have installed, you may be prompted to configure new servers. Select the servers you want to configure. Unselect any items you do not want to configure now:
    • Configure a new Adaptive Server
    • Configure a new Backup Server – see the System Administration Guide.
    • Configure a new XP Server – see the Transact-SQL® Users Guide.
    • Configure Job Scheduler – see the Job Scheduler Users Guide.
    • Enable Self Management
    • Configure Web Services – see Web Services Users Guide.
    • Configure an Unified Agent – see Unified Agent and Agent Management Console.
    Click Next.
  3. Enter your custom Adaptive Server configuration information:
    • Adaptive Server name
    • Port number
    • Error log – name and location of the error log file.
    • Application type:
      • (Default) MIXED – both OLTP and DSS.
      • OLTP – online transaction Processing generally consists of smaller, less complex transactions.
      • DSS – decision-support systems generally have less update activity with large complex queries.
    • Page size:
      • 2KB
      • (Default) 4KB
      • 8KB
      • 16KB
      Note: The default page size selection changed to 4KB in Adaptive Server version 15.5. The default in earlier versions was 2KB. If you plan to load database dumps from an Adaptive Server with a page size that is not 4KB, enter the page size to match the database dump.
    • Language
    • Character set
    • Sort order
    • Optimize Adaptive Server configuration – if you select this option, you must also provide this information:
      • Available physical memory for Adaptive Server – the value is 80 percent of sum of combined physical memory and OS shared memory.
      • Available CPU for Adaptive Server – the value is 80 percent of the physical CPU, with a minimum of 1.
      Note: If the value specified is larger than the available resource for allocation to the server, the optimize configuration may fail, causing the server to not start.
    • Create sample databases – create or install sample databases. Make sure you calculate the additional space for your master device.

    After customizing your Adaptive Server configuration, click Next to record the input fields.

  4. You see the second custom configuration window.
    • Master device – name of master device and the path where it should be located.
    • Master device size – the default options are:
      • 2KB page size – 30MB
      • 4KB page size – 60MB
      • 8KB page size – 120MB
      • 16KB page size – 240MB
    • Master database size – the default options are:
      • 2KB page size – 13MB
      • 4KB page size – 26MB
      • 8KB page size – 52MB
      • 16KB page size – 104MB
    • System procedure device path
    • System procedure device and database size – the default is 172MB.
    • System device path
    • System device size – the default options are:
      • 2KB page size server – 3MB
      • 4KB page size server – 6MB
      • 8KB page size server – 12MB
      • 16KB page size server – 24MB
    • System database size – the default options are:
      • 2KB page size server – 3MB
      • 4KB page size server – 6MB
      • 8KB page size server – 12MB
      • 16KB page size server – 24MB
    • Temporary database device
    • Temporary database device size:
      • 2KB page size server – 100MB
      • 4KB page size server – 100MB
      • 8KB page size server – 100MB
      • 16KB page size server – 100MB
    • Temporary database size:
      • 2KB page size server – 100MB
      • 4KB page size server – 100MB
      • 8KB page size server – 100MB
      • 16KB page size server – 100MB
    • Enable PCI in Adaptive Server – if you select this option, provide this additional information:
      • PCI device
      • PCI device size
      • PCI database size – PCI device and PCI database size are the same:
        • 2KB page size server – 24MB
        • 4KB page size server – 48MB
        • 8KB page size server – 96MB
        • 16KB page size server – 192MB

    After customizing your Adaptive Server configuration, click Next to record the input fields.

  5. Enter the Backup Server information:
    • Backup Server name
    • Port number
    • Error log

    Click Next.

  6. Enter the XP Server configuration information:
    • Port number
    • Error log

    Click Next.

  7. Enter Job Scheduler information:
    • Job Scheduler
    • Agent name
    • Port number
    • Management device
    • Management device size – the default is 75MB
    • Management database size – the default is 75MB

    Click Next.

  8. Custom-configure self management:
    • Self management user name
    • Self management password
    Note: If you choose the default user name "sa," you cannot enter the password. The "sa" default password is null.
  9. Custom-configure Web Service:
    • Producer HTTP Port Number
    • Producer HTTPS Port Number
    • Producer Host Name
    • Certificate Password
    • Confirm Certificate Password
    • Keystore Password
    • Confirm Keystore Password
    • Producer Log File
    • Consumer Port Number
    • Consumer Log File
  10. Choose a Self-Discovery Service Adapter to configure:
    • UDP Adapter
    • JINI Adapter – if you select this, enter:
      • JINI host name
      • JINI port number
      • JINI heart beat period
  11. Security Login Modules – choose the security login modules for the Unified Agent, then click Enable:
    • Simple Login Module – a dialog asks you to change the user name and password
    • Adaptive Server Login Module
    • Unix Proxy Login Module
  12. Verify that the values that appear in the Configure New Servers Summary window are correct, then click Next. You see the Configure Server Progress window
    You may see the restart window, which reminds you to either log out or restart your machine to complete the installation process.
  13. In the Installation Complete window, click Done.

Adaptive Server and related products have been successfully installed, and minimally configured for use. See Installing Sample Databases, to begin experimenting with your servers, or see the System Administration Guide for more advanced topics.

If you encounter any errors, see the Troubleshooting Guide.

Parent topic: Adaptive Server Installation
Related reference
Installing Sample Databases