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