DB2 10.5 for Linux, UNIX, and Windows

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.

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.