SAP ABAP DB400 SQL Package Size Monitoring

SAP ABAP DB400 SQL Package Size Monitoring

This monitor supervises SQL package size on SAP ABAP systems running on DB400.
It evaluates package size against configured thresholds and can generate alarms and metrics.

What Can Be Monitored

You can detect and alert on:

Oversized SQL packages in DB400
SQL package growth over time (via metrics)

This helps identify package bloat and potential database performance risks.

Monitored Data

The monitor calls RFC function to collect:

Package library name
Number of objects in package
Package size, converted to MB

Only packages with size strictly greater than 0 MB are retained.

Prerequisites

SAP backend database type must be DB400.
RFC function `ST04_DB4_GET_PKG_INFO` must be available and callable.

Configuration

Monitoring Parameters

Parameter	Type	Required	Default	Description
Max packages	Integer	Yes	`100`	Maximum number of packages kept after collection/sorting.

Surveillance Table

Field	Required	Default	Description
Active	Yes	`true`	Enables/disables this surveillance row.
SQL Package name	Yes	`*`	Package name filter (wildcard matching supported).
Threshold	Yes	`0`	Threshold expression used to evaluate package size (MB).
Severity	Yes	`MAJOR`	Alarm severity applied when threshold is breached.
Auto clear	Yes	`true`	Alarms generated by this row are clearable when condition recovers.
Alarm tag	No	(empty)	Optional custom alarm tag/prefix.
Alarm	No	`true`	Enables/disables alarm generation for this row.
Metric	No	`false`	Enables/disables metric emission for this row.

Alarm Conditions

For each active surveillance row:

Package name must match `SQL Package name`
Package size is evaluated against `Threshold`
If threshold evaluation is breached, an alarm is generated with configured `Severity`

Alarm message format:

`The size of <package> DB400 package is <size> MB ( >= <threshold> )`

Generated Metrics

If Metric is enabled on a row, the monitor emits:

Metric	Unit	Target	Description
SAP database package size	MB	Package name	Current DB400 SQL package size in MB.

Example

Active	SQL Package name	Threshold	Severity	Auto clear	Alarm tag	Alarm	Metric
true	`USR*`	`G2W:500`	4	true	`DB400,PKG`	true	true
true	`JOB*`	`G2W:1000`	3	true	`DB400,JOB`	true	false

Table of Contents