# Installation Guide

# Appendix B: Setting Up ALSM Databases

For information about how to switch to an external database after installation, see the ALSM online help at http://download.oracle.com/docs/cd/E13172_01/alsm/docs26/webhelp/index.htm. Locate the section "Configuring and Administering ALSM Components/Database Configuration/Administering Databases".

## Supported Database Drivers

Table B-1 Database Drivers
Database | Driver
default Hypersonic | org.hsqldb.jdbcDriver.
Microsoft SQL Server (Java) | com.microsoft.jdbc.sqlserver.SQLServerDriver
Oracle | oracle.jdbc.OracleDriver
IBM DB2 UDB | com.ibm.db2.jcc.DB2Driver
Sybase ASE | com.sybase.jdbc3.jdbc.SybDriver

## Connection URLs

### Microsoft SQL Server (Java)

The connection URL for Microsoft SQL Server (Java) can use two forms.

Note: | In both forms you must set the `SelectMethod` property to cursor, the `SendStringParametersAsUnicode` property to false, and the `DatabaseName` property to the name of the database in which you want to create the ALSM tables.

##### Form 1:

    jdbc:microsoft:sqlserver://Server_Name:Port_Number[;Property_Name=Property_Value...]

Example

    jdbc:microsoft:sqlserver://server1:1433;SelectMethod=cursor;
    DatabaseName=sphereServiceDB;SendStringParametersAsUnicode=false

    jdbc:microsoft:sqlserver://server1:1433;SelectMethod=cursor;
    DatabaseName=domains;SendStringParametersAsUnicode=false

##### Form 2:

    jdbc:microsoft:sqlserver://Server_Name\\Instance_Name[;Property_Name=Property_Value...]

Example

    jdbc:micsrosoft:sqlserver://server1\\NetSDK;SelectMethod=cursor;
    DatabaseName=sphereServiceDB;SendStringParametersAsUnicode=false

For more information about this connection URL, refer to the Microsoft SQL Server 2000 Driver for JDBC, User's Guide and Reference manual.

### Oracle

The connection URL for Oracle uses the form:

    jdbc:oracle:Driver_Type:@Database_Specifier

Example

`jdbc:oracle:thin:@svr3:1521:svc01` (example using the service ID)

`jdbc:oracle:thin:@svr3:1521/name01` (example using the service name)

For more information about this connection URL, refer to the Oracle 9i, JDBC Developer's Guide and Reference manual.

### IBM DB2 UDB

The connection URL for IBM DB2 UDB uses the form:

    jdbc:db2://Server_Name:Port_Number/Database_Name

Example

    jdbc:db2://server1:50000/sphereServiceDB

### Sybase ASE

The option 'DDL in tran" should be set to true. This can be done through the Sybase central GUI application or with the sp_dboption stored procedure.

    jdbc:sybase:Tds:Server_Name:Port_Number/Database_Name

Example

    jdbc:sybase:Tds:dbserver:5000/SLM