SQL parameters: sqllibrary

Startup parameters change the behavior of the HPE Service Manager server. You can always set a startup parameter from the server's operating system command prompt.

Parameter

sqllibrary

Description

This parameter defines the file name of the library containing your RDBMS drivers. HPE Service Manager provides a collection of database drivers for supported vendors and versions.

Valid if set from

Initialization file (sm.ini)

Requires restart of the Service Manager server?

Yes

Default value

One of the following RDBMS drivers:

DB2

  • Windows – SQDB2.CLI.DLL
  • AIX, Linux, and Solaris – sqdb2.cli.so
  • HP-Unix – sqdb2.cli.sl

Oracle

  • Windows – SQORACLE.OCI10.DLL
  • Linux – sqoracle.oci11.so, sqoracle.oci12.so
  • HP-Unix – sqoracle.oci10.sl, sqoracle.oci11.sl

Microsoft SQL Server

  • Windows – SQMSSQL.ODBC.DLL

Possible values

File name of library containing RDBMS drivers:

Note Driver names are case sensitive. Be sure to use the correct case.

Windows drivers

  • SQDB2.CLI.DLL
  • SQMSSQL.ODBC.DLL
  • SQORACLE.OCI10.DLL

Linux drivers

  • sqdb2.cli.so
  • sqoracle.oci11.so
  • sqoracle.oci12.so

HP-Unix

  • sqdb2.cli.sl
  • sqoracle.oci10.sl
  • sqoracle.oci11.sl

HP-Unix Itanium

  • sqdb2.cli.so
  • sqoracle.oci10.so
  • sqoracle.oci11.so

Example usage

If you are running on the Linux system and have oracle11 client software, the initialization file entry is as follows:

-sqllibrary:sqoracle.oci11.so