User`s guide

228 Chapter 14: Database Administration

not be used by users that do not know how to read to error logs and that

are not able to fix AQ issues manually.

• Errlog: (# items in the errlog): Lists the last 100 entries in the errlog. It also

gives the option to delete all entries older than 3 months.

• Sys' Error view: Lists all errors with the current schema as owner, in the sys'

all_errors view.

• VizAdmin log: Shows the last 100 entries of the VizAdmin log table.

• Invalid objects: Shows all invalid objects in the database.

This section contains information on the following topics:

• Message Queue

• Purge Expired Messages

• To see extended information

Message Queue

In order to enable the VCP notification mechanism utilizing "Oracle Streams and

Advanced Queuing" for VCP versions prior to 5.1.3, some triggers need to be

enabled.

Purge Expired Messages

When a journalist creates a new element of a template, a MOS message is sent

from the database to Viz Gateway. All MOS messages are stored on the database

which again takes up space on the database server. It is therefore convenient to

purge expired messages from the VCP message queue. As expired messages are

transferred to the exception queue, they need to be explicitly removed. This can

be done by running a job at regular intervals (every day). By default this is done

every day.

To see extended information

1. Click

Show Schema Status.

2. Select schema, enter schema user password, and click Next.

3. Select View Extended Info (Advanced), and click Next.

4. Select one of the tabs to view the extended information.