IBM DB2

cSyncLog VARCHAR(150) FOR BIT DATA)
IN INDBTTS;
CREATE UNIQUE INDEX INDBTIDX ON SYSIBM.INDOUBT(indbtXid, uowId);
DB2T4XAIndoubtUtil example
Run the DB2T4XAIndoubtUtil to allow a DB2 for OS/390 and z/OS Version 7
subsystem that has IP address mvs1, port number 446, and DB2 location name
SJCEC1 to participate in XA distributed transactions.
java com.ibm.db2.jcc.DB2T4XAIndoubtUtil -url jdbc:db2://mvs1:446/SJCEC1 \
-user SYSADM -password mypass
Related concepts
Chapter 12, “IBM Data Server Driver for JDBC and SQLJ type 4 connectivity
JDBC and SQLJ distributed transaction support,” on page 467
Related tasks
“Installing the z/OS Application Connectivity to DB2 for z/OS feature” on
page 435
Chapter 9, “Migrating from the JDBC/SQLJ Driver for OS/390 and z/OS to the
IBM Data Server Driver for JDBC and SQLJ,” on page 439
“Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version”
on page 434
DB2LobTableCreator utility
The DB2LobTableCreator utility creates tables on a DB2 for z/OS database server.
Those tables are required by JDBC or SQLJ applications that use LOB locators to
access data in DBCLOB or CLOB columns.
DB2LobTableCreator syntax
 java com.ibm.db2.jcc.DB2LobTableCreator -url jdbc:db2: //server / database
:port


-user user-ID -password password
-help

DB2LobTableCreator option descriptions
-url
Specifies the data source at which DB2LobTableCreator is to run. The variable
parts of the -url value are:
jdbc:db2:
Indicates that the connection is to a server in the DB2 family.
server
The domain name or IP address of the database server.
port
The TCP/IP server port number that is assigned to the database server.
This is an integer between 0 and 65535. The default is 446.
database
A name for the database server.
Chapter 8. Installing the IBM Data Server Driver for JDBC and SQLJ 431