Job Management Partner 1/Performance Management Planning and Configuration Guide

Appendix C.4 Exclusively occupied disk space when using the Store database in PFM - Agent 08-00 or later (Store 2.0)

This section describes the exclusively occupied disk space required for the Store database (Store 2.0) when running PFM - Agent 08-00.

Organization of this subsection

(1) Estimation expression

(2) Example estimate

(1) Estimation expression

The following describes how to estimate the exclusively occupied disk space, number of files, and number of directories used by the Store database.

(a) Exclusively occupied disk space

The exclusively occupied disk space used by the Store database is the sum of the disk space used for each record type. The exclusively occupied disk space used for PI-type records is the sum of the disk space used for each summary block.

Note:

Some additional fields are created when performance data is saved to the Store database. These additional fields are included in the disk space requirements and there is no need to estimate how much space they occupy. The additional fields common to all records are the same as in Store 1.0. For details, see the PFM - Agent manual.

Estimation expression for the exclusively occupied disk space X for each record type (unit: bytes)

X = {(e + 2) x f' + (d + 60) x {((e + 2) x f') / (65,250 - d) + 1}#1} x a / b x (c + 1) x 1.1

a: Value differs for each record type and summary block. See Table C-11.

b: Value differs for each record type and summary block. See Table C-11.^#2

c: Retention period setting for historical data^#3. The unit used depends on the record type and summary block. Look up the units in Table C-11.

d: Size of the fixed part of each type of historical data record^#4

e: Size of the variable part of each type of historical data record^#4

f: Number of instances of each type of historical data record (or 1 if single-instance records)^#5

f': If f is 2 or greater, f' is the value of f rounded up to the nearest multiple of 4. For example, if f = 2, then f' = 4. If f = 13, then f' = 16. If f = 13, then f' = 16.

Table C-11 Values to assign to a, b, and c

Record type	Summary block	a	b	c
PI	Minute	1,440	1 + (g - 1)/60#2	Retention period (unit: days)
	Hour	24	1 + (g - 1)/3,600#2	Retention period (unit: days)
	Day	7	1 + (g - 1)/86,400#2	Retention period (unit: weeks)
	Week	1	1 + (g - 1)/604,800#2	Retention period (unit: weeks)
	Month	1	1 + (g - 1)/2,592,000#2	Retention period (unit: months)
	Year	1	1 + (g - 1)/31,622,400#2	Retention period (unit: years)
PD	--	1,440	g/60	Retention period (unit: days)
PL	--	1,440	g/60	Retention period (unit: days)

Legend:

g: Collection interval setting for historical data (unit: bytes)

--: Not applicable.

#1

Truncate the result of {((e + 2) x f')/(65,250 - d) + 1} at the decimal point.

#2

Truncate the result of b for the PI record type at the decimal point.

#3

When using PFM - Agent 08-00 with Store 2.0, the retention period settings are derived from the settings used with Store 1.0. For details, see the section that describes the jpcconf db vrset command in the manual Job Management Partner 1/Performance Management Reference.

#4

The sizes of the fixed and variable parts of each record are the same as for Store 1.0. For details, see the PFM - Agent manuals.

#5

The number of instances of each record type is the same as for Store 1.0. For details, see the PFM - Agent manuals.

(b) Number of files

The expression for estimating N, the number of files that constitute the Store database, is as follows:

N = 20 + 2 x (
  (A11 + A12 + ... + A1m + m) +
  (A21 + A22 + ... + A2m + m) +
  (A31 + A32 + ... + A3m + m) +
  (A41 + A42 + ... + A4m + m) +
  (A51 + A52 + ... + A5m + m) +
  (11 x m) +
  (B1 + B2 + ... + Bn + n) +
  (C1 + C2 + ... + Co + o)
  )

m: Number of records of PI record type

n: Number of records of PD record type

o: Number of records of PL record type

A11 to A1m: Retention period settings for per-minute records of PI record type (unit: days)

A21 to A2m: Retention period settings for hourly records of PI record type (unit: days)

A31 to A3m: Retention period settings for daily records of PI record type (unit: weeks)

A41 to A4m: Retention period settings for weekly records of PI record type (unit: weeks)

A51 to A5m: Retention period settings for monthly records of PI record type (unit: months)

B1 to Bn: Retention period settings for records of PD record type (unit: days)

C1 to Co: Retention period settings for records of PL record type (unit: days)

(c) Number of directories

The expression for estimating N, the number of directories created to house the Store database, is as follows:

N = 25 + 2 x ((A1max) + (A2max) + (A3max) + (A4max) + (A5max) + 11 + (Bmax) + (Cmax))

A1max: Maximum retention period setting for records of PI record type in the summary block of minute (unit: days)

A2max: Maximum retention period setting for records of PI record type in the summary block of hour (unit: days)

A3max: Maximum retention period setting for records of PI record type in the summary block of day (unit: weeks)

A4max: Maximum retention period setting for records of PI record type in the summary block of week (unit: weeks)

A5max: Maximum retention period setting for records of PI record type in the summary block of month (unit: months)

Bmax: Maximum retention period setting for each record of PD record type (unit: days)

Cmax: Maximum retention period setting for each record of PL record type (unit: days)

(d) Number of files opened by the Store service

The expression for estimating N, the number of files opened by the Store service, is as follows:

N = 20 + 2 x (6 x l + m + n)

l: Number of records of PI record type

m: Number of records of PD record type

n: Number of records of PL record type

(2) Example estimate

An example of estimating these resource requirements is described below. In this example, the Store database (Store 2.0) is used in PFM - Agent for Platform.

(a) Exclusively occupied disk space

This example assumes that Performance Management collects the PI_LOGD record and the PD record.

The following shows an example of estimating the disk space requirements for PI_LOGD records. Substitute the following values for the variables in the expression in (1) Estimation expression.

d = 681 (bytes)
e = 700 (bytes)
f = 3
f' = 4
g = 60 (seconds)

Next, calculate the disk space requirements for per-minute and hourly records.

Per-minute records

Substitute the following values for the variables:

a = 1,440
b = 1 + (60 - 1)/60
 = 1.98... 
 = 1 (truncated at the decimal point)
c = 3 (days)

Use the following expression to estimate the disk space required:

X (per-minute) ={(700 + 2) x 4 + (681 + 60) x {((700 + 2) x 4) / (65,250 - 681) + 1}}
x 1,440 / 1 x (3 + 1) x 1.1
      = {2,808 + 741 x 1} x 6,336
      = 3,549 x 6,336
      = 22,486,464 (bytes) = Approx. 22 (MB)

Hourly records

Substitute the following values for the variables:

a = 24
b = 1 + (60 - 1) / 3,600
 = 1.01...
 = 1 (truncated at the decimal point)
c = 3 (days)

Use the following expression to estimate the disk space required:

X (hourly) = {(700 + 2) x 4 + (681 + 60) x {((700 + 2) x 4) / (65,250 - 681) + 1}}
x 24 / 1 x (3 + 1) x 1.1
      = {2,808 + 741 x 1} x 105.6
      = 3,549 x 105.6
      = 374,774.4 (bytes) = Approx. 0.4 (MB)

Daily records

Substitute the following values for the variables:

a = 7
b = 1 + (60 - 1) / 86,400
 = 1.00...
 = 1 (truncated at the decimal point)
c = 1 (weeks)

Use the following expression to estimate the disk space required:

X (daily) = {(700 + 2) x 4 + (681 + 60) x {((700 + 2) x 4) / (65,250 - 681) + 1}}
x 7 / 1 x (1 + 1) x 1.1
      = {2,808 + 741 x 1} x 15.4
      = 3,549 x 15.4
      = 54,654.6 (bytes) = Approx. 0.05 (MB)

Weekly records

Substitute the following values for the variables:

a = 1
b = 1 + (60 - 1) / 604,800
 =1.00...
 = 1 (truncated at the decimal point)
c = 1 (weeks)

Use the following expression to estimate the disk space required:

X (weekly) = {(700 + 2) x 4 + (681 + 60) x {((700 + 2) x 4) / (65,250 - 681) + 1}}
x 1 / 1 x (1 + 1) x 1.1
      = {2,808 + 741 x 1} x 2.2
      = 3,549 x 2.2
      = 7,807.8 (bytes) = Approx. 0.008 (MB)

Monthly records

Substitute the following values for the variables:

a = 1
b = 1+(60-1) / 2,592,000
 = 1.00...
 = 1 (truncated at the decimal point)
c = 1 (months)

Use the following expression to estimate the disk space required:

X (monthly) = {(700 + 2) x 4 + (681 + 60) x {((700 + 2) x 4) / (65,250 - 681) + 1}}
x 1 / 1 x (1+1) x 1.1
      = {2,808 + 741 x 1} x 2.2
      = 3,549 x 2.2
      = 7,807.8 (bytes) = Approx. 0.008 (MB)

Yearly records

Substitute the following values for the variables:

a=1
b=1+(60-1) / 31,622,400
 =1.00...
 =1 (truncated at the decimal point)
c=10 (fixed)

Use the following expression to estimate the disk space required:

X (yearly) = {(700 + 2) x 4 + (681 + 60) x {((700 + 2) x 4) / (65,250 - 681) + 1}}
x 1 / 1 x (10 + 1) x 1.1
      = {2,808 + 741 x 1} x 12.1
      = 3,549 x 12.1
      = 42,942.9 (bytes) = Approx. 0.04 (MB)

Accordingly, the disk space occupied by PI_LOGD records can be estimated as follows:

X (total)  = X (per-minute) + X (hourly) + X (daily) + X (weekly) + X (monthly) + X (yearly)
         = 22.506 (MB)
         = Approx. 23 (MB)

Next, we estimate the disk space requirements for PD records.

Substitute the following values for the variables:

a = 1,400
b = 60 / 60 = 1
c = 10 (days)
d = 681 (bytes)
e = 472 (bytes)
f = 10
f' = 12
g = 60 (seconds)

Use the following expression to estimate the disk space required:

X = {(472 + 2) x 12 + (681 + 60) x {((472 + 2) x 12) / (65,250 - 681) + 1}
x 1,400 / 1 x (10 + 1) x 1.1
 = {5,688 + 741 x 1} x 17,424
 = 6,429 x 17,424
 = 112,018,896 (bytes) = Approx. 112 (MB)

Accordingly, the exclusively occupied disk space required for PI_LOGD and PD records is 135 MB.

(b) Number of files

The following shows an example of estimating the number of files in the Store database when PI, PI_LOGD, PD, and PD_PDI records are collected. Substitute the following values for the variables in the expression in (1) Estimation expression.

m = 2
n = 2
o = Zero
A11 to A1m = 3 (days)
A21 to A2m = 3 (days)
A31 to A3m = 1 (weeks)
A41 to A4m = 1 (weeks)
A51 to A5m = 1 (months)
B1 to Bn = 10 (days)
C1 to Co = Not required

The expression for estimating N, the number of files created to house the Store database, is as follows:

N = 20 + 2 x (
         (A11 + A12 + ... + A1m + m) +
         (A21 + A22 + ... + A2m + m) +
         (A31 + A32 + ... + A3m + m) +
         (A41 + A42 + ... + A4m + m) +
         (A51 + A52 + ... + A5m + m) +
         (11 x m) +
         (B1 + B2 + ... + Bn + n) +
         (C1 + C2 + ... + Co + o)
         )
 = 20 + 2 x {
         [3(PI portion) + 3(PI_LOGD portion) + 2] +
         [3(PI portion) + 3(PI_LOGD portion) + 2] +
         [1(PI portion) + 1(PI_LOGD portion) + 2] +
         [1(PI portion) + 1(PI_LOGD portion) + 2] +
         [1(PI portion) + 1(PI_LOGD portion) + 2] +
         [11 x 2] +
         [10(PD portion) + 10(PD_PDI portion) + 2]
         }
 =20 + 2 x {8 + 8 + 4 + 4 + 4 + 22 + 22}
 =20 + 2 x 72 = 20 + 144 = 164

(c) Number of directories

The following shows an example of estimating the number of directories created to house the Store database when PI, PI_LOGD, PD, and PD_PDI records are colleted.

Substitute the following values for the variables in the expression in (1) Estimation expression.

A1max = 3 (days) (when A1max is 2 days for PI records and 3 days for PI_LOGD records, use 3 days as it is the higher value)
A2max = 3 (days)
A3max = 1 (weeks)
A4max = 1 (weeks)
A5max = 1 (months)
Bmax = 10 (days) (when Bmax is 8 days for PD_PDI records and 10 days for PD records, use 10 days is used as it is the higher value)
Cmax = Zero

The expression for estimating N, the number of directories created to house the Store database, is as follows:

N = 25 + 2 x ((A1max) + (A2max) + (A3max) + (A4max) + (A5max) + 11 + (Bmax) + (Cmax))
  = 25 + 2 x (3 + 3 + 1 + 1 + 1 + 11 + 10 + 0) = 85

(d) Number of files opened by the Store service

The following shows an example of estimating the number of files opened by the Store service when PI, PI_LOGD, PD, and PD_PDI records are collected.

Substitute the following values for the variables in the expression in (1) Estimation expression.

l = 2
m = 2
n = 0

The expression for estimating N, the number of files opened by the Store service, is as follows:

N = 20 + 2 x (6 x l + m + n)
  = 20 + 2 x (6 x 2 + 2 + 0) = 48

[Contents][Back][Next]

All Rights Reserved. Copyright (C) 2009, Hitachi, Ltd.