IBM Data Server Driver for JDBC and SQLJ type 4 connectivity URL
syntax
jdbc:db2: // server
jdbc:db2j:net:
jdbc:ids:
: port
/ database
: property = value ;
IBM Data Server Driver for JDBC and SQLJ type 4 connectivity URL
option descriptions
The parts of the URL have the following meanings:
jdbc:db2: or jdbc:db2j:net:
The meanings of the initial portion of the URL are:
jdbc:db2:
Indicates that the connection is to a DB2 for z/OS, DB2 Database for
Linux, UNIX, and Windows.
jdbc:db2: can also be used for a connection to an IBM Informix
Dynamic Server (IDS) database, for application portability.
jdbc:db2j:net:
Indicates that the connection is to a remote IBM Cloudscape
®
server.
jdbc:ids:
Indicates that the connection is to an IDS data source.
jdbc:informix-sqli: also indicates that the connection is to an IDS data
source, but jdbc:ids: should be used.
server
The domain name or IP address of the data source.
port
The TCP/IP server port number that is assigned to the data source. This is an
integer between 0 and 65535. The default is 446.
database
A name for the data source.
v If the connection is to a DB2 for z/OS server, database is the DB2 location
name that is defined during installation. All characters in the DB2 location
name must be uppercase characters. The IBM Data Server Driver for JDBC
and SQLJ does not convert lowercase characters in the database value to
uppercase for IBM Data Server Driver for JDBC and SQLJ type 4
connectivity.
You can determine the location name by executing the following SQL
statement on the server:
SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1;
v If the connection is to a DB2 for z/OS server, all characters in database must
be uppercase characters.
v If the connection is to a DB2 Database for Linux, UNIX, and Windows
server, database is the database name that is defined during installation.
v If the connection is to an IDS server, database is the database name. The
name is case-insensitive. The server converts the name to lowercase.
Chapter 3. JDBC application programming 13
To Next Page
Loading...
Need help?
General