HP 3000 Manuals

Restrictions [ IMAGE/SQL Administration Guide ] MPE/iX 5.5 Documentation


IMAGE/SQL Administration Guide

Restrictions 

You can only modify one type of data in a transaction.  That is, you can
do the following within the same transaction:

   *   Read a TurboIMAGE/XL and/or ALLBASE/SQL database and modify a
       TurboIMAGE/XL database.
   *   Read a TurboIMAGE/XL and/or ALLBASE/SQL database and modify an
       ALLBASE/SQL database.
[REV BEG]

You cannot update both an ALLBASE/SQL database and a TurboIMAGE/XL
database within the same transaction.  Such an attempt will produce an
error.[REV END]

Within a transaction, avoid a terminal read with locks in effect (DBOPEN
mode 1 through 4 and isolation level of RR, CS, or RC) because the
database could be locked for a lengthy period of time.  See Table 5-1  
for details on locking assignment.

The limitation of transaction size depends on the Transaction Management
(XM) limit and the DBE LOG SIZE limit.[REV BEG] The XM limit for every
transaction cannot exceed 4MBytes.[REV END]


NOTE TurboIMAGE/XL activity is not logged to DBELOG.


MPE/iX 5.5 Documentation