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.

  1. Set environment variable MT_DB_LOGIN to enter database connection information.
  2. Go to $KIXDIR/bin.
  3. 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.