Estimating Space Requirements for PMU Data

The total space requirements, in kilobytes, for PMU data that is stored in PSPMTRANSHIST and PSPMTRANSCURR tables can be estimated using the following formula:

N x [D + 1] x L x R x M x T

This table describes the variables that are used in this formula.

Notation	Description	Performance Monitor Value Default	Navigation
N	Number of PeopleSoft systems that are monitored by Performance Monitor. This is the number of PeopleSoft databases appearing on the System Definitions search page.	NA	PeopleTools, and then Performance Monitor, and then Administration, and then Monitored Systems
D	Performance history retention period in days. This is the value that is set for the After N days option.	NA	PeopleTools, and then Performance Monitor, and then Administration, and then Monitored Systems
L	Number of user sessions per day for a monitored system. A session means that a user signs on, performs a few transactions, and signs off.	NA	NA
R	Number of user interactions per session. User interactions are anything that triggers a server trip, including clicking a button, clicking TAB, and so on.	NA	NA
M	Number of PMU rows that are captured per user interaction.	9	NA
T	Number of KB per PMU row in the table.	Refer to the value in the following table for the target database.	NA

The following table helps you to determine the value for T.

Parameter	ANSI/Unicode	Oracle	Microsoft SQL Server	DB2	Db2 for z/OS
T	ANSI	1.3	1.4	1.8	2.1
T	Unicode	2.4	2.6	3.3	3.8