After a user added numerous schedules, the Content Store database has been locked because some schedules contain invalid data. What can an…

To prevent the Content Store from being locked by schedules containing invalid data, an administrator must enable system-wide schedule validation. This is a server-side configuration. The correct procedure is to modify the advanced settings for the Event Management Service, which is responsible for handling schedules. By setting the emf.schedule.validation.enabled parameter to true, the system is forced to validate every schedule upon creation or modification. This ensures that invalid schedule specifications are rejected before they can be saved to the Content Store, thereby preventing the database locking issue.

A. Restrict the ability to create schedules to the Administrator only.

This is a restrictive security policy, not a technical solution. It doesn't prevent an administrator from inadvertently creating an invalid schedule that could still lock the system.

B. Select the delivery service inside IBM Cognos Configuration and set the schedule validation property to true.

This is incorrect because the setting applies to the Event Management Service, not the Delivery Service, and it is configured in IBM Cognos Administration, not the IBM Cognos Configuration tool.

C. Make sure that every schedule created by a user will be verifies with the validation button inside the schedule mask.

This approach relies on manual user compliance and is not a reliable, automated prevention method. An administrator cannot enforce this action for all users consistently.

1. IBM Cognos Business Intelligence 10.2.2 Administration and Security Guide.

Reference: Chapter 12: Server Administration, Section: "Advanced settings for the event management service", Page 338.

Quote/Content: The guide lists the parameter emf.schedule.validation.enabled and states, "Specifies whether to validate schedules when they are created or modified. When this property is set to true, invalid schedules cannot be saved in the content store. This prevents the content store from being locked by invalid schedules." This directly supports option D.

2. IBM Knowledge Center - Cognos Analytics 11.x Documentation (Concept is identical to Cognos BI 10.x).

Reference: Section: "Administration and Security", Topic: "Advanced settings for the event management service".

Content: The documentation details the emf.schedule.validation.enabled parameter for the Event Management service. It explains that setting this advanced property to true enables validation to prevent invalid schedules from being saved, which is the core requirement of the question. This confirms the service, property name, and its function.