Click above to get retro games delivered to your door ever month!

 AX_GetActivityInfo()
 Returns information about current activity on the Advantage Database Server
------------------------------------------------------------------------------

Syntax

     AX_GetActivityInfo() -> array

Returns
     Returns a 13 element array (with some elements being arrays themselves)
     with current Advantage Database Server activity information containing
     the following data:

     [1] = (numeric) Number of operations performed since Advantage server
                     was started/loaded
     [2] = (numeric) Number of logged errors/warnings
     [3][1] = (numeric) Number of days Advantage server has been running
     [3][2] = (numeric) Number of hours Advantage server has been running
     [3][3] = (numeric) Number of minutes Advantage server has been running
     [3][4] = (numeric) Number of seconds Advantage server has been running
     [4][1] = (numeric) Number of users currently in use
     [4][2] = (numeric) Maximum number of users ever used
     [4][3] = (numeric) Number of users rejected
     [5][1] = (numeric) Number of connections currently in use
     [5][2] = (numeric) Maximum number of connections ever used
     [5][3] = (numeric) Number of connections rejected
     [6][1] = (numeric) Number of work areas currently in use
     [6][2] = (numeric) Maximum number of work areas ever used
     [6][3] = (numeric) Number of work areas rejected
     [7][1] = (numeric) Number of tables currently in use
     [7][2] = (numeric) Maximum number of tables ever used
     [7][3] = (numeric) Number of tables rejected
     [8][1] = (numeric) Number of index files currently in use
     [8][2] = (numeric) Maximum number of index files ever used
     [8][3] = (numeric) Number of index files rejected
     [9][1] = (numeric) Number of locks currently in use
     [9][2] = (numeric) Maximum number of locks ever used
     [9][3] = (numeric) Number of locks rejected
     [10][1] = (numeric) Number of Transaction list header elements currently
                         in use
     [10][2] = (numeric) Maximum number of Transaction list header elements
                         ever used
     [11][1] = (numeric) Number of Transaction list table/index visibility
                         elements currently in use
     [11][2] = (numeric) Maximum number of Transaction list table/index
                         visibility elements ever used
     [12][1] = (numeric) Number of Transaction list memo elements currently
                         in use
     [12][2] = (numeric) Maximum number of Transaction list memo elements
                         ever used
     [13][1] = (numeric) Number of worker threads currently in use
     [13][2] = (numeric) Maximum number of worker threads ever used

     - or -

     Returns an empty array if an error occurred. If an error occurred,
     AX_Error() will return information on why the function failed.

Description

     AX_GetActivityInfo() returns an array containing information about
     current activity on the Advantage Database Server.  Included is such
     information as the number of operations that have been performed by the
     Advantage Database Server since it has been running, the length of time
     the Advantage Database Server has running, and the "in use", "max used",
     and "rejected" number of such values as connections, tables, and index
     files.

     It is possible that the number of elements in the activity information
     array will increase in future releases of Advantage.  Since it is
     possible to use a newer version of the Advantage Database Server with an
     older version of the Advantage CA-Clipper Client, any new and additional
     activity data that may exist if using a newer version of the Advantage
     Database Server will not be returned in the array.

     Since it is possible that the number of elements in the activity
     information array will increase in future releases of Advantage, it is
     highly recommended that the length of the returned array be calculated
     using the Len() function, rather than hard-coding the expected length to
     a literal value.

Example

     // Must first get a connection to the Advantage Database Server
     USE x:dummy.dbf VIA "DBFCDXAX"

     aActivityInfo := AX_GetActivityInfo()

     // Display number of operations and logged errors/warnings
     ? aActivityInfo[1]
     ? aActivityInfo[2]

     // Display the remaining activity info
     for i := 3 to Len( aActivityInfo )
        for j := 1 to Len( aActivityInfo[i] )
           ? aActivityInfo[i][j]
        next
        ?
     next