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_LOGINto 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