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

Read syntax diagramSkip visual syntax diagramjavacom.ibm.db2.jcc.DB2LobTableCreator -url jdbc:db2:// server : port /database -useruser-ID-passwordpassword-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.
database is the Db2 location name that is defined during installation. All characters in this value must be uppercase characters. You can determine the location name by executing the following SQL statement on the server: 
SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1;
-user
Specifies the user ID under which DB2LobTableCreator is to run. This user must have authority to create tables in the DSNATPDB database.
-password
Specifies the password for the user ID.
-help
Specifies that the DB2LobTableCreator utility describes each of the options that it supports. If any other options are specified with -help, they are ignored.