The Runtime Profile (RPROF) Table for DB2 › Table Definition › Sample RPROF Table Definition

Sample RPROF Table Definition

CREATE TABLE RPROF
(IETUID CHAR(8) NOT NULL,
IETAPPID CHAR(4) NOT NULL,
IETPSNUM SMALLINT NOT NULL,
SEQNUM SMALLINT NOT NULL,
CNTLOVHD VARCHAR(3072) NOT NULL,
PSTEPDTA VARCHAR(512) NOT NULL,
KEYFILL CHAR (86) NOT NULL WITH DEFAULT,
RPROF_DATE DATE NOT NULL WITH DEFAULT,
RPROF_TIME TIME NOT NULL WITH DEFAULT)
IN database.RPROF;

The values in the table have the following definitions:

IETUID

Contains the CICS, IMS, or TSO user ID. If the user ID is unavailable, the terminal ID is used.

IETAPPID

Contains a numeric ID representing the CA Gen business system.

IETSNUM

Contains a procedure step depth of stack number indicating the location of the procedure step in the dialog.

SEQNUM

Contains a sequence number to tie physical RPROF rows into a logical RPROF record. There can be as many as 11 physical RPROF rows per logical RPROF record, assuming no compression.

CNTLOVHD

Contains control information for the dialog flow, such as trancode and exit state.

KEYFILL

Provides the concurrency.

PSTEPDTA

Contains the procedure step export views.

RPROF_DATE

Provides the assistance in the cleanup of unused rows.

RPROF_TIME

Provides the assistance in the cleanup of unused rows.

Initially, the data that is stored in PSTEPDTA is compressed. Because of this compression, many RPROF records are stored in one RPROF row. The PSTEPDTA column is back-filled with spaces, after compression, to fill a 4K page for maximum concurrency.