TRIGGERING DATABASE TABLE

[Former Member]

Hi friends ,

I have one requirement , I have a FM which automatically update the latest values in the database table from a class . My requirement is how can i trigger another class when ever my database table is updated using the latest updated values.

Points will b rewardered .

Thanks in Advance.

Arun.

[Former Member]

Monitoring the Database with the Alert Monitor (Informix)

Use

Using the alert monitor, you can monitor the following database alerts:

Space management – reorganization and space monitoring

DB system check – consistency and profile

Backup/restore

The alerts described in this section are all triggered automatically from DB System Checks in CCMS (Informix).

Prerequisites

Changing the default thresholds

Although SAP recommends that you do not normally change the default thresholds, you can set thresholds yourself for most of the database alerts.

Deactivating an alert

You can deactivate an alert, but only do this for a particular reason and for a short time.

For more information, see Configuring DB System Checks in CCMS (Informix).

Procedure

Start the alert monitor.

Choose SAP CCMS Monitor Templates.

Choose Entire System.

Open the Database monitoring tree element (MTE).

For each R/3 instance, the alerts are displayed with color coding to indicate severity. The following alerts are possible in the Database MTE:

MTE

Meaning

For more information, see

SpaceManagement

Monitors the space situation in your database

Management of Database Growth

Reorganization

Checks if reorganization or application data archive required, due to tables running out of extents or running out of allocated pages

Reorganization with SAPDBA

Application Data Archiving

Analyzing Tables by Fill Level, Size, and Extents with SAPDBA

SpaceMonitoring

Checks if dbspace fill level OK and if tables can be extended correctly

Listing Dbspaces with SAPDBA

Analyzing Tables for Critical Next Extent Size with SAPDBA

See also next step.

DBSystemCheck

Checks key aspects of your database system

DB System Checks in CCMS (Informix)

DB Consistency

Checks if chunk sizes are within limit, if raw devices are overlapping, and if logging mode OK

Listing Chunks with SAPDBA

Logging Mode with SAPDBA

DB Profile

Checks value of settings in the ONCONFIG file

Editing the ONCONFIG File for ON-Archive

Backup

Checks aspects affecting database backup and archive

Database Backup (ON-Bar)

Archive (ON-Archive and ontape)

Restore

Checks number of

chunks for a dbspace

Listing Chunks with SAPDBA

To get up-to-date and detailed information about what the alerts mean and how you should react, use the online help in the R/3 System.

If you have the SpaceMonitoring alert for a dbspace, choose Start analysis tool to extend the dbspace. Refer to Extending a Dbspace with CCMS.

Result

By using the database alert monitor continually during productive database operation, you can find out quickly and easily whether your database has problems. The result is a more highly tuned database and reduced system downtime.