# SHAPP Schema Statistics

The Sh Application (SHAPP) schema provides the following type of statistics:

- Counter: A counter records incremental data cumulatively and rolls over when the counter limit is reached. The limit depends upon the counter data type.
- Gauge: A gauge statistic indicates a single value representative of a single instance. This type is often used to track particular events in time.
- Fixed Value String: A string statistic indicates the name of a service instance or a node.

IMPORTANT:

The format string syntax is described by Schema Format String Syntax in the Bulk Statistics Overview chapter.

IMPORTANT:

Unless otherwise indicated all statistics are of proprietary type based on 3GPP standard.

IMPORTANT:

Unless otherwise indicated, all statistics are counters. For statistics with the Int32 data type, the roll-over to zero limit is 4,294,967,295. For statistics with the Int64 data type, the roll-over to zero limit is 18,446,744,073,709,551,615. All statistics are cumulative and reset only by one of the following methods: roll-over (as described above), after a system restart, or after a clear command is performed. All statistics are considered standards-based unless otherwise noted.

The following variables are supported:
Table 1. SHAPP Schema Statistics

Statistic | Description | Data Type
--- | --- | ---
sh_db_query | Indicates total number of database queries made during Sh call processing. Trigger: When DB API is called. Availability: Available across Sh application. | Gauge/ Int64
db_rid_usage | Indicates current usage count per Rating Id. Trigger: When a given rating id is used. Availability: Available across Sh application. | Gauge/ Int64
db_umon_usage | Indicates current usage count per usage monitor. Trigger: When a usage monitor is used. Availability: Available across Sh application. | Gauge/ Int64
db_sess_usage | Indicates current session usage. Trigger: Usage for a given session. Availability: Available across Sh application. | Gauge/ Int64
db_rid_upd | Indicates total number of updates per rating id. Trigger: When a given rating id is updated. Availability: Available across Sh application. | Gauge/ Int64
db_umon_upd | Indicates total number of database usage updates, incremented for each database update, each plan in a Profile Update Request.- (PUR). Trigger: When a database usage is updated for PUR. Availability: Available across Sh application. | Gauge/ Int64
sh_db_err | Indicates total number of database errors encountered in processing of Sh calls. Trigger: When database API has returned an error. Availability: Available across Sh application. | Gauge/ Int64
sh_notif | Indicates total number of Push Notification Request (PNR) IPC messages sent by application manager to Sh controller. Trigger: When PNR is generated at application manager. Availability: Available across Sh application. | Gauge/ Int64
sh_db_profile | Indicates requested subscriber profile. Trigger: When a subscriber profile is requested. Availability: Available across Sh application. | Gauge/ Int64
snr_in | Indicates total number of Subscriber Notification Request (SNRs) messages received. Trigger: When an SNR is received. Availability: Available across Sh application. | Gauge/ Int64
sna_out | Indicates Subscriber Notification Answer (SNA) Sent. Trigger: When an SNR is sent. Availability: Available across Sh application. | Gauge/ Int64
pur_in | Indicates total number of Profile Update Request (PUR) messages received. Trigger: When a PUR is received. Availability: Available across Sh application. | Gauge/ Int64
pua_out | Indicates total number of Profile Update Answer (PUA) replies sent. Trigger: When a PUA is sent. Availability: Available across Sh application. | Gauge/ Int64
pnr_out | Indicates total number of Push Notification Request (PNR) messages sent. Trigger: When a PNR is sent. Availability: Available across Sh application. | Gauge/ Int64
pna_in | Indicates Push Notification Answer (PNA) messages received. Trigger: When a PNA is received. Availability: Available across Sh application. | Gauge/ Int64
ipc_appmgr_req | Indicates total number of IPC requests sent to application manager by Sh controller. Trigger: When an IPC request is sent to application manager by Sh controller. Availability: Available across Sh application. | Gauge/ Int64
snr_err | Indicates total number of subscriber Notification Request (SNR) error messages. When an SNR eror message is sent or received. Available across Sh application. | Gauge/ Int64
sna_err | Indicates total number of Subscriber Notification Answer (SNA) error messages. When an SNA error message is sent or received. Available across Sh application. | Gauge/ Int64
pur_err | Indicates total number of Profile Update Request (PUR) error messages. When a PUR error messages is sent or received. Available across Sh application. | Gauge/ Int64
pua_err | Indicates total number of Profile Update Answer (PUA) error messages. When a PUR error messages is sent or received. Available across Sh application. | Gauge/ Int64
pnr_err | Indicates total number of Push Notification Request (PNR) error messages. When a PNR error messages is sent or received. Available across Sh application. | Gauge/ Int64
pna_err | Indicates total number of Push Notification Answer (PNR) error messages. When a PNA error messages is sent or received. Available across Sh application. | Gauge/ Int64
IMPORTANT: For information on statistics that are common to all schema see the Statistics and Counters Overview chapter.