EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #446 background imageLoading...
Page #446 background image
v The authorization ID of the owner of the T4XAIN01, T4XAIN02, T4XAIN03,
and T4XAIN04 packages. SQL statements in those packages are executed
using the authority of owner-ID.
-help
Specifies that the DB2T4XAIndoubtUtil utility describes each of the options
that it supports. If any other options are specified with -help, they are ignored.
-delete
Specifies that the DB2T4XAIndoubtUtil utility deletes the objects that were
created when DB2T4XAIndoubtUtil was run previously.
-priqty
Specifies the primary space allocation, in kilobytes, for the table space that
contains the SYSIBM.INDOUBT table. The default value for -priqty is 1000.
Important: The -priqty value divided by the page size for the table space in
which SYSIBM.INDOUBT resides must be greater than the maximum number
of indoubt transactions that are allowed at a given time. For example, for a 4
KB page size, the default -priqty value of 1000 allows about 250 concurrent
indoubt transactions.
-secqty
Specifies the secondary space allocation, in kilobytes, for the table space that
contains the SYSIBM.INDOUBT table. The default value for -secqty is 0.
Recommendation: Always use the default value of 0 for the -secqty value, and
specify a -priqty value that is large enough to accommodate the maximum
number of concurrent indoubt transactions.
-bindonly
Specifies that the DB2T4XAIndoubtUtil utility binds the T4XAIN01, T4XAIN02,
T4XAIN03, and T4XAIN04 packages and grants permission to PUBLIC to
execute the packages, but does not create the SYSIBM.INDOUBT table.
-showSQL
Specifies that the DB2T4XAIndoubtUtil utility displays the SQL statements that
it executes.
-jdbcCollection collection-name|NULLID
Specifies the value of the -collection parameter that was used when the IBM
Data Server Driver for JDBC and SQLJ packages were bound with the
DB2Binder utility. The -jdbcCollection parameter must be specified if the
explicitly or implicitly specified value of the -collection parameter was not
NULLID.
The default is -jdbcCollection NULLID.
DB2T4XAIndoubtUtil usage notes
To create the SYSTEM.INDOUBT table and its index manually, use these SQL
statements:
CREATE TABLESPACE INDBTTS
USING STOGROUP
LOCKSIZE ROW
BUFFERPOOL BP0
SEGSIZE 32
CCSID EBCDIC;
CREATE TABLE SYSIBM.INDOUBT(indbtXid VARCHAR(140) FOR BIT DATA NOT NULL,
uowId VARCHAR(25) FOR BIT DATA NOT NULL,
pSyncLog VARCHAR(150) FOR BIT DATA,
430 Application Programming Guide and Reference for Java
â„¢

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability