This article contains an in-depth explanation to assist you in understanding what are the RSCSCCTLJ and RSCSPCTLJ journals for, and whether they be cleared.
Journals are an important part of the ShowCase server's smooth operation. Journals collect information about things the ShowCase server does, and they store that information in objects called Receivers.
There are four journals associated with ShowCase:
- RSCSCCTLJ - Used by Warehouse Manager, Warehouse Builder and Query catalogs
- RSCSPCTLJ - Associated with stored procedure catalogs
- QSQJRN - Used for Enterprise Reporting
- SCPTFLOG - Used only when applying Warehouse Manager server patches. The SCPTFLOG receiver will likely never be very large, and should not be changed.
Showcase journals are required for commitment control, and cannot be removed. However, as with other journals, the attached receivers can become exceedingly large. There are two ways to manage these receivers: either by manually detaching them and creating new ones, or by allowing the system to do it.
IBM has provided a simple process to detach a receiver and simultaneously create a new receiver for any journal on the system. Both of the following examples use variations on that process.
Manually managing receivers is simple, but requires constant attention. However, it may be your choice to manage receivers in this way. There may also be times when you need to manually generate new receivers (such as, in preparation for backup and recovery situations). To manually generate new receivers, follow this example, substituting the correct journal, receiver and library names:
CHGJRN JRN(server-lib/journal-name) JRNRCV(*GEN) MNGRCV(*USER) DLTRCV(*NO)
This creates a new journal receiver with an incremental name (for instance, if the current journal name is RSCSPC0001, this will create a new receiver named RSCSPC0002). It automatically detaches the old receiver, so that it can be saved and/or deleted. If you want to specify the name of the new journal receiver, the command would look like this:
CHGJRN JRN(server-lib/journal-name) JRNRCV(serverlib/receiver-name) MNGRCV(*USER) DLTRCV(*NO)
To delete a receiver, you can use this command:
The first step in enabling the system to manage these journals is to set a limit on the receiver size. The second step is to change the journal, so that once the maximum receiver size has been reached, the system automatically detaches it, creates a new receiver, and attaches itself to that. Optionally, you can instruct the system to delete or keep the old receiver. Below is an example in which the old receiver is retained. Substitute the correct journal, receiver and library names:
CRTJRNRCV JRNRCV(serverlib/receiver-name) THRESHOLD(500000)
CHGJRN JRN(serverlib/journal-name) JRNRCV(serverlib/receiver-name) SEQOPT(*RESET) MNGRCV(*SYSTEM) DLTRCV(*NO)
In both of the above examples, the receiver name can be automatically generated by the system, or can be specified. If you chose a specific name for a journal receiver, it's best that it is unique to the entire operating system to simplify recovery and avoid confusion.
For more information on the management of journals, please refer to the documentation found on IBM's Web site.