Additional database configuration information for common databases

Certain selections made on the Database configuration panel in the Profile Wizard cause different fields and default values to be displayed on the follow-up panel, the Additional database configuration information panel. This topic describes the fields and default values available on each variation of this panel.

The Additional database configuration information panel is displayed if you select any database other than Cloudscape from the Database configuration panel.
Important:

If you select Cloudscape, no additional database configuration is necessary.

You cannot create a new database if you are using DB2 Universal OS/390 V7.1, DB2 Universal OS/390 V8.1, Oracle OCI, or Oracle Thin as your database product. If you select one of these combinations on the Database configuration panel, a message panel is displayed, informing you that you must either use an existing database or select a different database product.

The Additional database configuration information panel contains slightly different fields and default values, depending on your selection and whether you chose to create a new database or use an existing database on the Database configuration panel. On all variations of the Additional database configuration information panel, the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation are always required. On all variations of the panel except when Microsoft SQL Server Embedded is selected, the field Location (directory) of JDBC driver classpath files is always required. Values you enter for the password and password confirmation fields are not displayed in clear text and must be verified to have the same values.

For information on what fields will appear on the Additional database configuration information panel based on your selection and whether you chose to create a new database or use an existing database on the Profile Wizard Database configuration panel, follow one of the links below.

DB2 Universal Database -- create new database

Enter values for the fields Directory of database server installation, User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. For the Location (directory) of JDBC driver classpath files field, accept the default value of install_root/universalDriver_wbi/lib on Linux and UNIX platforms or install_root\universalDriver_wbi\lib on Windows platforms, or browse to the location on your system that contains the following files:
  • db2jcc.jar
  • db2jcc_license_cu.jar or db2jcc_license_cisuz.jar
An error message is displayed if the files cannot be found at the specified location.

A default value is provided for the Server port field. When creating a new database, the only valid value for the database server host name is localhost. As a result, the Database server host name (for example, IP address) field does not appear on this panel.

DB2 Universal Database -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the following files:
  • db2jcc.jar
  • db2jcc_license_cu.jar or db2jcc_license_cisuz.jar
An error message is displayed if the files cannot be found at the specified location.

Default values are provided for the fields Database server host name (for example, IP address) and Server port.

DB2 Universal Database for OS/390 V7.1 or DB2 Universal Database for OS/390 V8.1-- create new database

You cannot create a new database if you are using DB2 Universal OS/390 V7.1, DB2 Universal OS/390 V8.1, Oracle OCI, or Oracle Thin as your database product. If you select one of these combinations on the Database configuration panel, a message panel is displayed, informing you that you must either use an existing database or select a different database product.

DB2 Universal Database for OS/390 V7.1 or DB2 Universal Database for OS/390 V8.1-- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the following files:
  • db2jcc.jar
  • db2jcc_license_cisuz.jar
An error message is displayed if the files cannot be found at the specified location.

Enter values for the fields Database server host name (for example, IP address), Database storage group name, and Location name of the database server. Since the database is always located remotely, the Database server host name (for example, IP address) field does not have a default value of localhost. A default value is provided for the field Server port.

DB2 Call Level Interface (CLI) -- create new database

Enter values for the fields Directory of database server installation, User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the db2java.zip file. If db2java.zip cannot be found at the specified location, an error message will be displayed.

DB2 Call Level Interface (CLI) -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the db2java.zip file. If db2java.zip cannot be found at the specified location, an error message will be displayed.

Informix Dynamic Server -- create new database

Enter values for the fields Directory of database server installation, User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the following files:
  • ifxjdbc.jar
  • ifxjdbcx.jar
An error message is displayed if the files cannot be found at the specified location.
You must also enter a value for the Database instance name field. A database instance name must always begin with ol_. A default value is provided for the Server port field. The Database server host name (for example, IP address) field is set to localhost by default and does not appear on this panel.

Informix Dynamic Server -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the following files:
  • ifxjdbc.jar
  • ifxjdbcx.jar
An error message is displayed if the files cannot be found at the specified location.

You must also enter a value for the Database instance name field. A database instance name must always begin with ol_. Default values are provided for the fields Database server host name (for example, IP address) and Server port.

Microsoft SQL Server Embedded -- create new database

Enter values for the fields Directory of database server installation, User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. A default value is provided for the Server port field. When creating a new database, the only valid value for the database server host name is localhost. As a result, the Database server host name (for example, IP address) field does not appear on this panel.

Microsoft SQL Server Embedded -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Default values are provided for the fields Database server host name (for example, IP address) and Server port.

Microsoft SQL Server DataDirect -- create new database

Enter values for the fields Directory of database server installation, User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the following files:
  • sqlserver.jar
  • base.jar
  • util.jar
Plus, the file spy.jar must be available in the following location relative to the location of the JDBC driver classpath files:
  • Icon indicating Linux platforms Icon indicating UNIX platforms On Linux and UNIX platforms: ../spy/spy.jar
  • Icon indicating Windows platforms On Windows platforms: ..\spy\spy.jar
An error message is displayed if the files cannot be found at the specified locations.

A default value is provided for the Server port field. When creating a new database, the only valid value for the database server host name is localhost. As a result, the Database server host name (for example, IP address) field does not appear on this panel.

Microsoft SQL Server DataDirect -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the following files:
  • sqlserver.jar
  • base.jar
  • util.jar
Plus, the file spy.jar must be available in the following location relative to the location of the JDBC driver classpath files:
  • Icon indicating Linux platforms Icon indicating UNIX platforms On Linux and UNIX platforms: ../spy/spy.jar
  • Icon indicating Windows platforms On Windows platforms: ..\spy\spy.jar
An error message is displayed if the files cannot be found at the specified locations.

Default values are provided for the fields Database server host name (for example, IP address) and Server port.

Oracle OCI client -- create new database

You cannot create a new database if you are using DB2 Universal OS/390 V7.1, DB2 Universal OS/390 V8.1, Oracle OCI, or Oracle Thin as your database product. If you select one of these combinations on the Database configuration panel, a message panel is displayed, informing you that you must either use an existing database or select a different database product.

Oracle OCI client -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the classes12.zip file. An error message is displayed if the file cannot be found at the specified location.

Default values are provided for the fields Database server host name (for example, IP address) and Server port.

Oracle Thin -- create new database

You cannot create a new database if you are using DB2 Universal OS/390 V7.1, DB2 Universal OS/390 V8.1, Oracle OCI, or Oracle Thin as your database product. If you select one of these combinations on the Database configuration panel, a message panel is displayed, informing you that you must either use an existing database or select a different database product.

Oracle Thin -- use existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), Password confirmation, and Location (directory) of JDBC driver classpath files. The Location (directory) of JDBC driver classpath files field must point to the directory that contains the ojdbc14.zip file. An error message is displayed if the file cannot be found at the specified location.

Default values are provided for the fields Database server host name (for example, IP address) and Server port.


Terms of use |

Last updated: Thu Apr 27 15:20:06 2006

(c) Copyright IBM Corporation 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)