Managing Calendar Manager Utility

7.5 Managing Calendar Manager Utility

After loading holidays into the KDD_CAL_HOLIDAY table and weekly off-days into the KDD_CAL_WKLY_OFF table, you can use the Calendar Manager Utility to update and manage OFSBD system calendars.

The <OFSAAI Installed Directory>/database/db_tools/mantas_cfg/install.cfg configuration file contains modifiable inputs that you use to run the utility (refer to Install Configuration for more information).

This section contains the following topics:

Directory Structure
Logs
Calendar Information
Using the Calendar Manager Utility

Directory Structure

The following table provides the directory structure for the Calendar Manager Utility in

<OFSAAI Installed
                    Directory>/database/db_tools/

Table 7-14 Calendar Manager Utility Directory Structure

Directory	Description
bin/	Contains executable files, including the shell script set_mantas_date.sh.
lib/	Includes required class files in .jarformat.
mantas_cfg/	Contains configuration files , such as install.cfg and categories.cfg, in which you can configure properties and logging attributes.
logs/	Keeps the calendar_manager.log log file that the utility generates during execution.

Logs

As the utility updates the calendars in the OFSBD system, it generates a log that it enters in the <OFSAAI Installed Directory>/database/db_tools/logs/calendar_manager.log file (the logging process time-stamps all entries). The log file contains relevant information such as status of the various Calendar Manager processes, results, and error records.

You can modify the current logging configuration for the Alert Purge Utility in the<OFSAAI Installed Directory>/database/db_tools/log4j2.xml files. For more information about logging in these configuration files, refer to Managing Common Resources for Batch Processing Utilities and Appendix A - Logging.

Calendar Information

The Calendar Manager Utility obtains all holidays and weekly off-days for loading into the OFSBD calendars by retrieving information from the KDD_CAL_HOLIDAY and KDD_CAL_WKLY_OFF tables. These tables contain calendar information that an Oracle client has provided regarding observed holidays and non-business days.