Release Notes

6Using LOB locators on a DB2 UDB for z/OS or OS/390 server

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