journalingRates

The journalingRates command produces a journaling rates text file report of the transaction journal file or files specified using the journal argument, to enable you to plan the capacity for an SDS connection.

The syntax of the journalingRates command in the jdbutilb command line is as follows.

jdbutilb path=database-path
         ini=initialization-file-name
         journalingRates
         journal=journal-file-number
         [journalDir=journal-directory]
         [lastJournal=journal-file-number]
         [samplingInterval=minutes]
         [nostatus]

Specify the samplingInterval argument if you want journal rates sampled at an interval other than one minute (that is, journal rates are sampled at one-minute intervals, or 60000 milliseconds, by default).

The following example shows the use of the journalingRates command in the jdbutilb command line to output the journaling rates of journal db0000076894.log.

jdbutilb path=s:\testjade\db\logs\current ini=s:\testjade\jade.ini journalingRates journal=76894 journalDir=s:\testjade\logs\current samplingInterval=15

Using this example, the rates of the following journal file are sampled and output every 15 minutes to the journalingrates.csv file in the same directory. (The 15-minute sampling interval is used to calculate the rate values in the journalingrates.jra text file.)

d:\testjade\db\logs\current\db0000076894.csv

For more details, see "Producing Journaling Rates Reports", in Chapter 3.