10.3.5.5 DBMS Constraints
The DBMS user indicated in the OPENINFO
of the
group containing the server, must have access to
ARTTSQP_INFO
, ARTTSQP_CONTENT
and
ARTTSQP_MAN
tables, either directly (objects are
created in this schema) or through a DBLINK
.
On these pre-existing tables the DBMS user must have select, insert, update, delete permissions.
You can find the sample script
crtsptable_{Oracle|UDB}
in $KIXDIR/tools
to create tables.
When using UDB, do the followings to rebind
ARTTSQP_UDB
.
- Set environment variable
MT_DB_LOGIN
to enter database connection information. - Go to
$KIXDIR/bin
. - Execute:
../tools/bind.sh tspool_UDB.bnd
The bind.sh
script issues DB2 BIND
command; you can change its parameter to meet your actual scenario.
The changes you make will affect not only ARTTSQP_UDB
but also ARTSRM_UDB
and ARTTSQ_UDB
via
commands like buildartcics
.
Parent topic: ARTTSQP Configuration