Release Notes
6If you intend to use LOB locators to access DBCLOB columns in DB2 UDB
6tables on a DB2 UDB for z/OS or OS/390 server, run the
6com.ibm.db2.jcc.DB2LobTableCreator utility on each
6of those servers to create tables that are needed for fetching LOB
6locators.
6DB2LobTableCreator syntax
6>>-java--java com.ibm.db2.jcc.DB2LobTableCreator---------------->
6
6>---url--jdbc:db2:-//server--+-------+--/database--------------->
6 '-:port-'
6
6>---user--user-ID---password--password--+-------+--------------><
6 '--help-'
6
6
6DB2LobTableCreator option descriptions
6
- 6-url
- 6Specifies the data source at which DB2LobTableCreator is to run.
6The variable parts of the -url value are:
6
- 6jdbc:db2:
- 6Indicates that the connection is to a server in the DB2 UDB family.
- 6server
- 6The domain name or IP address of the database server.
- 6port
- 6The TCP/IP server port number that is assigned to the database
6server. This is an integer between 0 and 65535. The default is
6446.
- 6database
- 6A name for the database server.
6database is the DB2 UDB location name that is defined during
6installation. All characters in this value must be uppercase
6characters. You can determine the location name by executing the
6following SQL statement on the server:
6SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1;
6
- 6-user
- 6Specifies the user ID under which DB2LobTableCreator is to run.
6This user must have authority to create tables in the DSNATPDB
6database.
- 6-password
- 6Specifies the password for the user ID.
- 6-help
- 6Specifies that the DB2LobTableCreator utility describes each of the
6options that it supports. If any other options are specified with
6-help, they are ignored.
6
[ Top of Page | Previous Page | Next Page | Table of Contents ]