Example of a CSV text file

The CSV text file contains the information about all the database connections. You can create and then import this file to add the database connections that you defined. You can also use the sample CSV text file that comes with your product. This CSV sample text file is in the samples subdirectory of the installation directory.

Parameters for the CSV text file

The following table describes the parameters that you can define in the CSV file.
Table 1. Parameters for the CSV text file
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:
  • DB2LUW
  • DB2Z
  • INFORMIX
  • INFORMIX_JDBC
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.

Sample CSV text file

You can see a sample of CSV text file in the samples subdirectory of the installation directory. The sample file has the following contents:
#=========================================================================#
#  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;, ,        

Feedback