getDatabaseStats

getDatabaseStats(jdo: JadeDynamicObject input);

The getDatabaseStats method of the System class returns statistics relating to persistent database activity. The values are returned as Integer64 properties in the dynamic object specified by the jdo parameter.

The returned values are cumulative Integer64 values representing counts of actions (fetching objects, updating objects, opening files, and so on) that do not get reset during the lifetime of the database server node. JADE applications that use the getDatabaseStats method defined in the System class therefore need to compare values from one call to the next, to work out the value differences.

The calling process is responsible for creating and deleting the JadeDynamicObject instance.

For details about the properties returned in the dynamic object, see "System::getDatabaseStats Method", in Chapter 4 of the JADE Object Manager Guide.

The calling process is responsible for creating and deleting the JadeDynamicObject instance. Properties are added to the object when the method is first called. The object can then be used in subsequent calls.

If the dynamic object passed to the method already contains properties that do not match the properties to be returned, the existing dynamic object properties are removed and replaced with the appropriate properties. This method is most efficient when the properties match those to be returned.

The cumulative values are held as 64-bit unsigned integer values, and are copied to the dynamic object as Integer64 values. The maximum value before they wrap around to negative values is therefore 2^63 - 1 (approximately 8 Exabytes).

The following example shows the use of the getDatabaseStats method.

tryDbStats();
vars
   jdo : JadeDynamicObject;
begin
   create jdo transient;
   system.getDatabaseStats(jdo);
   write jdo.display;
epilog
   delete jdo;
end;

The output from the getDatabaseStats method shown in the previous example is as follows.

---DatabaseStatistics(207)---
fileOpens = 30
fileCloses = 10
committedTrans = 13
abortedTrans = 0
checkPoints = 1
lastCheckPointDate = 14 May 2012
lastCheckPointTime = 15:40:39
lastCheckPointDuration = 1
maxCheckPointDuration = 1
avgCheckPointDuration = 1
editionGets = 190
objectGets = 17216
objectCreates = 23
objectUpdates = 34
objectDeletes = 0
dirtyReads = 0
osmReads = 0
priorEditionReads = 0
absentCollGets = 0
overflowDeleteGets = 0