ESB_DBINFO_T

This database Info Structure gets information about a specific database. Fields in this structure cannot be modified using the VB API. See also the ESB_DBSTATE_T structure, which contains additional database state parameters that can be modified, and the ESB_DBSTATS_T structure. The fields are:

Type ESB_DBINFO_T

   ElapsedDbTime  As Long                  
   DataCacheSize  As Long                   
   IndexCacheSize As Long                   
   IndexPageSize  As Long                    
   nDims          As Long                    
   DbType         As Integer                
   status         As Integer                 
   nConnects      As Integer                 
   nLocks         As Integer                 
   Data           As Integer                 
   AppName        As String * ESB_APPNAMELEN 
   Name           As String * ESB_DBNAMELEN  
   Country        As String * ESB_MBRNAMELEN 
   Time           As String * ESB_MBRNAMELEN 
   Category       As String * ESB_MBRNAMELEN 
   Type           As String * ESB_MBRNAMELEN 
   CrPartition    As String * ESB_MBRNAMELEN 
End Type
VB Data TypeFieldDescription
As longElapsedDb
Time
Number of seconds the database has been loaded
As longDataCache
Size
Run-time data cache size (in Kbytes) currently in use by database. Note that once you have changed the data cache size you must stop and restart the database in order for the new data cache size to take effect.
As longIndexCache
Size
Run-time index cache size (in Kbytes) currently in use by database
As longIndexPage
Size
Run-time index page size (in Kbytes) currently in use by database
As LongnDimsThe number of dimensions in database
As IntegerDbTypeDatabase type (normal or currency). This field can contain the following values :
ESB_DBTYPE_NORMAL
ESB_DBTYTPE_CURRENCY
As IntegerStatusThe Ddatabase load status (loaded or not loaded) - one of:
ESB_STATUS_NOTLOADED
ESB_STATUS_LOADING
ESB_STATUS_LOADED
ESB_STATUS_UNLOADING
As IntegernConnectsNumber of users currently connected to the database
As IntegernLocksThe Nnumber of data blocks currently exclusively locked
As IntegerDataFlag to indicate the loading state of the data in the database (either no data is loaded, data has been loaded but not calculated, or data is loaded and calculated). This field may contain one of the following values:
ESB_DBDATA_NONE /* no data */

ESB_DBDATA_LOADNOCALC /*data loaded without calc */

ESB_DBDATA_CLEAN /* data has been calculated */

As String * ESB_APPNAMELENAppName Associated application name
As String * ESB_DBNAMELENNameDatabase name
As String * ESB_MBRNAMELENCountry The currency country dimension member, if any. If none, this field is an empty string.
As String * ESB_MBRNAMELENTimeThe currency time dimension member, if any. If none, this field is an empty string.
As String * ESB_MBRNAMELENCategory The currency category dimension member, if any. If none, this field is an empty string.
As String * ESB_MBRNAMELENTypeThe currency type dimension member (currency databases only) . If none exists, this field is an empty string.
As String * ESB_MBRNAMELENCrPartition The currency partition member (non-currency databases only)