Additional database configuration information panel

When you have selected your database on the Database configuration panel in the Profile wizard, a follow-up panel asks you for database-specific information. (This panel does not appear if you selected Cloudscape V5.1 when configuring a stand-alone server profile.) This panel, called the Additional database configuration information panel, contains slightly different fields and default values, depending on your database selection and whether you chose to create a new database, use an existing database, or set up a new or existing database separately (apart from the profile creation or augmentation process).

Follow the link for your database type and action combination in Table 1 to determine which fields will appear on the Additional database configuration information panel based on your selections on the Database configuration panel. When you have completed entering the information on the Additional database configuration information panel, return to the topic from which you accessed this information (Configuring a stand-alone server profile or Configuring a deployment manager).

DB2 Universal -- Create a new (local) database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

For Location (directory) of JDBC driver classpath files, 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 of 50000 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 -- Use an existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

For Location (directory) of JDBC driver classpath files, 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.

Enter values for the Database server host name (for example, IP address) and Server port fields (or accept the default values of localhost and 50000, respectively).

DB2 Universal -- Set up a new or existing database separately

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

For Location (directory) of JDBC driver classpath files, 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.

Enter values for the Database server host name (for example, IP address) and Server port fields (or accept the default values of localhost and 50000, respectively).

DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for z/OS V8 -- Create a new (local) database

You cannot create a new database if you are using DB2 UDB for z/OS and OS/390 V7, DB2 UDB for z/OS V8, Oracle OCI, or Oracle Thin. If you select one of these databases and the option Create a new (local) database, a message panel prompts you to either use an existing database or select a different database product. Select OK to close this message panel, and make different selections on the Database configuration panel.

DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for z/OS V8 -- Use an 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 of 446 is provided for the field Server port.

DB2 UDB for z/OS and OS/390 V7 or DB2 UDB for z/OS V8 -- Set up a new or existing database separately

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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 of 446 is provided for the field Server port.

DB2 CLI -- Create a new (local) 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the db2java.zip file. An error message is displayed if the file cannot be found at the specified location.

DB2 CLI -- Use an 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the db2java.zip file. An error message is displayed if the file cannot be found at the specified location.

DB2 CLI -- Set up a new or existing database separately

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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the db2java.zip file. An error message is displayed if the file cannot be found at the specified location.

Informix -- Create a new (local) 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 of 1526 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 -- Use an 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 (localhost and 1526, respectively).

Informix -- Set up a new or existing database separately

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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 (localhost and 1526, respectively).

Microsoft SQL Server Embedded -- Create a new (local) database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

A default value of 1433 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 an existing database

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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

Microsoft SQL Server Embedded -- Set up a new or existing database separately

Enter values for the fields User ID to authenticate with the database, Password (the password for database authentication), and Password confirmation. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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

Microsoft SQL Server DataDirect -- Create a new (local) 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 of 1433 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 an 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 (localhost and 1433, respectively).

Microsoft SQL Server DataDirect -- Set up a new or 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

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 (localhost and 1433, respectively).

Oracle OCI -- Create a new (local) database

You cannot create a new database if you are using DB2 UDB for z/OS and OS/390 V7, DB2 UDB for z/OS V8, Oracle OCI, or Oracle Thin. If you select one of these databases and the option Create a new (local) database, a message panel prompts you to either use an existing database or select a different database product. Select OK to close this message panel, and make different selections on the Database configuration panel.

Oracle OCI -- Use an 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the file ojdbc14.jar. 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 (localhost and 1521, respectively).

Oracle OCI -- Set up a new or existing database separately

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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the file ojdbc14.jar. 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 (localhost and 1521, respectively).

Oracle Thin -- Create a new (local) database

You cannot create a new database if you are using DB2 UDB for z/OS and OS/390 V7, DB2 UDB for z/OS V8, Oracle OCI, or Oracle Thin. If you select one of these databases and the option Create a new (local) database, a message panel prompts you to either use an existing database or select a different database product. Select OK to close this message panel, and make different selections on the Database configuration panel.

Oracle Thin -- Use an 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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the file ojdbc14.jar. 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 (localhost and 1521, respectively).

Oracle Thin -- Set up a new or existing database separately

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. Values you enter for the password and password confirmation fields are not displayed in clear text – you must ensure that they have the same values.

The Location (directory) of JDBC driver classpath files field must point to the directory that contains the file ojdbc14.jar. 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 (localhost and 1521, respectively).


Last updated: Wed 01 Nov 2006 07:47:12

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