getRequestStats

getRequestStats(jdo: JadeDynamicObject input);

The getRequestStats method of the System class returns system statistics relating to requests carried out by the database server node. The values are returned as Integer64 properties in the dynamic object specified by the jdo parameter.

The system statistics are held on the database server node. For details about the properties returned in the dynamic object, see "System Request Statistics Method" in Chapter 4 of the 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 getRequestStats method.

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

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

---SystemStatistics(105)---
committedTransactions = 114
abortedTransactions = 0
getObjects = 41561
queuedLocks = 0
createObjects = 433
deleteObjects = 160
updateObjects = 703
lockObjects = 22444
unlockObjects = 12310
beginNotifications = 686
endNotifications = 33
deliveredNotifications = 169
serverMethodExecutions = 0
totalLockQueueWaitTime = 0
causeEvents = 70