Using Autojournaling

SQDR Plus provides an option for automatically journaling physical files that are not already journaled. The Automatically Start Journaling Physical Files option is enabled by default when you create a Staging Agent with SQDR Manager. If you wish to disable this option, you can later edit the configuration of the Agent and change the value of autoJournal; see autoJournal in the Configuration Reference.

When a non-journaled physical file is selected for incremental replication, the SQDR Plus Staging Agent will create a new library in the same ASP (auxiliary storage pool) as the physical file. This library will be named <agentSchema><NN>, where agentSchema is the name of the Agent schema and userid (default SQDR) and NN is the ASP number. For example, if the Capture Agent schema is SQDR and the physical file is located in ASP 3, a library named SQDR03 will be created in ASP 3. This library will be used to store journals.

The library and its contents will be owned by the Capture Agent userid, and will contain the journal created by the Capture Agent for auto-journaling.

Note that using the autoJournal feature of SQDR Plus requires that authority of *ALL be granted to *PUBLIC for access to the journal. If it is important to secure the table for access only by a particular user or users, create a journal, journal receivers, and journal receiver libraries with the appropriate security for those users, as described in the following section.

Journal receivers for the journal will be created in the Agent schema (e.g. SQDR). This value can be overridden by configuring the receiverLibrary parameter; see receiverLibrary in the Configuration Reference.

If you plan to use autojournaling, we recommend considering ASP layout before installing SQDR Plus. For best performance, the Journal Receiver library should be located in an ASP other than the ASP containing the files or tables to be replicated.