TRIGGERING DATABASE TABLE

Former Member — Wed, 28 Nov 2007 06:07:02 GMT

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.

Re: TRIGGERING DATABASE TABLE

Former Member — Wed, 28 Nov 2007 08:19:37 GMT

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

topic TRIGGERING DATABASE TABLE in Application Development and Automation Discussions

TRIGGERING DATABASE TABLE

Re: TRIGGERING DATABASE TABLE