Disabling tx object creation

Important!

This topic applies only when the IMPAX site archives to an IMPAX Data Center.

Issues can arise due to the creation of Transaction or tx objects (DICOM objects used to synchronize status changes across multiple IMPAX clusters). To prevent these issues, you must disable support for these objects. (As of IMPAX 6.5.1, support for these objects is disabled by default.)

To disable tx object creation in an IMPAX Oracle database

Log in as the oracle user (Solaris) or as the AgfaService user (Windows).
On Solaris, copy dosr.trigsql.oracle as /usr/mvf/etc/dosr.trigsql.oracle.MIS101670.
or
On Windows, copy dosr.trigsql.sqlserver as c:\mvf\etc\dosr.trigsql.oracle.MIS101670.
Log into SQLPlus as the dbadmin user.
On Solaris, type @/usr/mvf/etc/dosr.trigsql.oracle.MIS101670.

or
On Windows, type @c:\mvf\etc\dosr.trigsql.oracle.MIS101670.
Type quit.
Type regrant-oracle (Solaris) or bash regrant-oracle (Windows).

To disable tx object creation in an IMPAX SQL Server database

Log in as the AgfaService user.
Copy dosr.trigsql.sqlserver as c:\mvf\etc\dosr.trigsql.sqlserver.MIS101670.
In SQL Server, using a tool such as Query Analyzer or Management Studio, open the C:\mvf\etc\dosr.trigsql.sqlserver.MIS101670 file.
Click Execute.
In Query Analyzer or Management Studio, run sp_grant_permission.