Figure 16: System environment for ONLINE-PRIVACY
The ONLINE-PRIVACY utility routine runs as a UDS/SQL TIAM application program in an independent DBH session.
You can start ONLINE-PRIVACY at any time while the database is operating when the following requirements are fulfilled:
ONLINE-PRIVACY is called under the user ID under which the database is cataloged.
The database is activated as an independent DBH session.
The database is not attached to the session in the SHARED-RETRIEVAL mode.
With ONLINE-PRIVACY you can grant new user groups access to an existing database application and change the access rights of existing user groups as many times as needed.You need to update the access rights after making changes to a schema (for example, after adding new record types or new base tables).
Activating online extensibility of the DBDIR using ACT INCR enables you to ensure that the DBDIR can, when required, be extended by the DBH. However, no online extension of the DBTTs of the DBDIR’s record types takes place.
Access to a database in a remote configuration via UDS-D is not possible with ONLINE-PRIVACY.
Access locks
An access lock (ACCESS LOCK) or access restriction (ACCESS RETRIEVAL) set with the DAL command ACCESS on the database or realm level has no effect on the ONLINE-PRIVACY utility routine.
ONLINE-PRIVACY therefore provides you with the ability to change the access rights for a database for which only read transactions are permitted. The database must be in the EXCLUSIVE-UPDATE attach mode and be locked for other transactions with the DAL command ACCESS RETRIEVAL,DB=dbname.
Effect of changing rights
Changes to the access rights of a database that you have made using ONLINE-PRIVACY affect all processing chains started after terminating the ONLINE-PRIVACY run (FINISH statement of the ONLINE-PRIVACY transaction).
Processing chains started before the end of the ONLINE-PRIVACY run continue to work with the old privacy information.
Effect on the communication pool (CUP)
The ONLINE-PRIVACY utility routine connects to the communication pool (CUP) just like other UDS/SQL TIAM application programs. The space required by ONLINE-PRIVACY within the communication pool is about the same as the size of the SIA of the database to be processed.
Proceed as follows to ensure that the size of the communication pool is large enough to use ONLINE-PRIVACY:
Determine the size of the SIA with the BPSIA utility routine.
Take the size of the SIA into account as an additional space requirement for ONLINE-PRIVACY when calculating the minimum size of the communication pool.
Set the value of the DBH load parameter PP CUP-SIZE accordingly.