Parameter | Explanation |
---|---|
name (Required) | The unique database connection name. The
name parameter is the identifier for a database connection, and so
each connection must have a unique name.
Note: During import, if the
import file contains a duplicate name, the import
wizard prompts you to either update the connection properties with
the new data, or to keep the existing connections without modifications.
|
dataServerType (Required) | The database server type. The following values
are permitted:
Attention: Some products support a limited set of
database servers. Before you import a data source connection file,
make sure the included dataServerType entries
are supported by your product.
|
db2instance (Optional) | The DB2® instance name. |
databaseName (Required) | The database name for this database connection. |
host (Required) | The IP address or IP name of the host where the database exists. To retrieve the host name, run the TCP/IP hostname command on the server. To retrieve the host IP address, run the ping host_name command on the server. |
port (Required) | The port number where the database is configured. |
user (Optional) | The database user name. |
password/password.decrypted (Optional) | The password for the database user. If you use the password parameter, the password that is specified in the definition must be in the encrypted form. |
location (Required for DB2Z) | The location of the DB2 for z/OS® system. |
databaseAlias (Optional) | The alias of the DB2 command line processor (CLP). This parameter can be used for data server types DB2LUW and DB2Z only. |
INFORMIXSERVERNAME (Required for INFORMIX_JDBC, optional for INFORMIX) | The name of the Informix® database server. |
xtraProps (Optional) | Additional properties such as connection properties as defined in the JDBC driver documentation for the database server type. Example: traceLevel=32 |
URL (see the explanation) | The JDBC URL of the database server. The URL parameter
is required if the data server type is not supported by default. Note: A
default URL is created for the connection if you do not enter a value
for this parameter.
|
comment (Optional) | A descriptive comment for the database connection. |
#=========================================================================#
# Licensed Materials - Property of IBM #
# 5724-Y94 #
# © Copyright IBM Corp. 2009, 2011 All Rights Reserved. #
# US Government Users Restricted Rights - Use, duplication or #
# disclosure restricted by GSA ADP Schedule Contract with #
# IBM Corp. #
#=========================================================================================================================================================================================
# Field :: Description
# name :: Required. The unique identifier for the data source connection.
# dataServerType :: Required. The database type. The following databases are supported by default: DB2LUW, DB2Z.
# db2instance :: Optional. The DB2 instance name.
# databaseName :: Required. The database name.
# host :: Required. The IP address or IP name of the host where the data source exists.
# port :: Required. The port number where the data source is configured.
# user :: Required. The ID of a user that has access privileges on the database.
# password/password.decrypted :: Optional. The password of the user ID. If you use the 'password' option, the value of this field must be the encrypted password.
# location :: Optional. The location of DB2Z. This column is only required when the dataServerType is DB2Z.
# databaseAlias :: Optional. The alias of the DB2 CLP. This column is only used for DB2LUW and DB2Z.
# INFORMIXSERVERNAME :: Required if dataServerType is INFORMIX_JDBC.
# xtraProps :: Optional. Additional properties such as connection properties as defined in the JDBC driver documentation for the database server type. Separate multiple properties with a semicolon.
# URL :: Optional. The JDBC URL. This field is required if the data server type is not those supported by default.
# comment :: Optional. A descriptive note for this this connection.
# securityMechanism :: Optional. This column is reserved/used for connection export only. Users should not modify this column.
# kerberosServerPrincipal :: Optional. This column is reserved/used for connection export only. Users should not modify this column.
#=========================================================================================================================================================================================
name, dataServerType, databaseName, db2instance, host, port, user, password, databaseAlias, location, INFORMIXSERVERNAME, xtraProps, URL, comment,
#-------------------------------------------------------------------------------------------------------------------------------------------------------------------
SAMPLEDB, DB2LUW,SAMPLE_DATA,,sample.ibm.com, 50002, inst95, , , , , ,jdbc:db2://sample.ibm.com:50002/SAMPLE_DATA:retrieveMessagesFromServerOnGetMessage=true;securityMechanism=3;, ,