Creating a Database

Use the Create Databases wizard to create a Sybase IQ database on the same host as the SCC agent.

1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
2. In the left pane of the Administration Console, select IQ Servers and click the drop-down arrow that appears to the right.
3. Select Create Databases.
4. Click Add.
5. In the Add Database Definition dialog, specify Sybase Control Center agent and database information:

   Area	Description
   Host	The name of the host system where the new database is created.
   SCC agent port	The port number that the Sybase Control Center agent on the given host is listening on. Default is 9999.
   SCC agent user	User ID for the Sybase Control Center agent. Default is uafadmin.
   SCC agent password	Password for the Sybase Control Center agent user. Default is no password.
   Utility server user	User ID for the utility database. Default is DBA.
   Utility server password	Password for the utility database. Default is sql.
   IQ Server Name	Name of the IQ server to be created.
   IQ Server Port	Port number for the new IQ server.
   IQ user	User ID for the new IQ server.
   IQ password	User password for the IQ user.
   Database path	Path to the database file. For example, /<hostname>/sample/sample/mytestdb.db.
   IQ page size	Page size of the database, in kilobytes. If you do not make a selection, the application chooses a page size.
   Catalog page size	Database page size for the catalog store, in kilobytes. If you do not make a selection, the application automatically chooses a page size.
   IQ main dbspace path	Path to the IQ main store dbspace physical file on disk. For example, /<hostname>/sample/sample/mytestdb.iq.
   IQ main dbspace size (MB)	(Disabled if Raw Device is selected.) Size, in megabytes, for the IQ main store dbspace. Specify at least 100.
   IQ main dbspace reserve (MB)	The amount of space, in megabytes, to reserve for future expansion in the IQ main store.
   Raw device (IQ main dbspace)	Indicates a raw disk.
   Local temporary dbspace path	Path to the temporary IQ store physical file on disk. For example: /<hostname>/sample/sample/mytestdb.iqtmp.
   Local temporary dbspace size (MB)	(Disabled if Raw Device is selected.) Size, in megabytes, for the temporary IQ store.
   Local temporary dbspace reserve (MB)	The amount of space, in megabytes, to reserve for future expansion in the temporary IQ store.
   Raw device (local temp dbspace)	Indicates a raw disk.
   Transaction log	File name of the IQ transaction log that records changes to the database. If you leave this field blank, the application automatically assigns a log name: <database_name>.log.
   CHAR collation	Click Select to open the Select CHAR Collation dialog box. (Select is disabled until all required fields are filled.) Select the CHAR collation sequence used by the database to perform alphanumeric sorting. The default is ISO_BINENG.
   NCHAR collation	Click Select to open the Select NCHAR Collation dialog box. (Select is disabled until all required fields are filled.) Select the NCHAR collation sequence used by the database to perform alphanumeric sorting on NCHAR data. The default is UCA.
   Case insensitive for string comparison	Indicates that CHAR and NCHAR values in the database are case-insensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers.
   Enable simple encryption on entire database	Indicates simple database encryption is enabled.

6. Click OK.
   The Create Database wizard appears. If your database definition values are valid, a check mark appears in the left pane next to Database Definitions. If any input for the database definition is not valid, an X appears. Hover the mouse over the X to see error information.
7. Click Next, or, from the left pane of the wizard, select Execution.
8. Click Execute to start the database creation process.
9. (Optional) Import a list of database definitions from a CSV file.
   1. On the Database Definitions page of the wizard, click Import and specify:

      Area	Description
      File Name	File name of the CSV file containing delimited list of node definitions.
      Browse	Opens a file explorer window to locate the CSV file.
      Field Delimiter	The default field delimiter is a vertical bar ("|"). If your CSV file uses a different field delimiter, enter it in this field.

   2. Click OK.
10. (Optional) Export your existing database definitions to a CSV file for safekeeping or future import:
    1. On the Database Definitions page of the wizard, click Export and specify:

       Area	Description
       Field Delimiter	The default field delimiter is a vertical bar ("|"). You can specify a different field delimiter.

    2. Click OK.
11. Click Finish to exit the wizard.