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 ESB_DBSTATE_T, which contains additional database state parameters that can be modified, and ESB_DBSTATS_T. 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 Type	Field	Description
As long	ElapsedDbTime	Number of seconds the database has been loaded
As long	DataCacheSize	Run-time data cache size (in KB) 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 long	IndexCacheSize	Run-time index cache size (in KB) currently in use by database
As long	IndexPageSize	Run-time index page size (in KB) currently in use by database
As Long	nDims	The number of dimensions in database
As Integer	DbType	Database type (normal or currency). This field can contain the following values : ESB_DBTYPE_NORMAL ESB_DBTYTPE_CURRENCY
As Integer	Status	The Ddatabase load status (loaded or not loaded) - one of: ESB_STATUS_NOTLOADED ESB_STATUS_LOADING ESB_STATUS_LOADED ESB_STATUS_UNLOADING
As Integer	nConnects	Number of users currently connected to the database
As Integer	nLocks	The Nnumber of data blocks currently exclusively locked
As Integer	Data	Flag 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_APPNAMELEN	AppName	Associated application name
As String * ESB_DBNAMELEN	Name	Database name
As String * ESB_MBRNAMELEN	Country	The currency country dimension member, if any. If none, this field is an empty string.
As String * ESB_MBRNAMELEN	Time	The currency time dimension member, if any. If none, this field is an empty string.
As String * ESB_MBRNAMELEN	Category	The currency category dimension member, if any. If none, this field is an empty string.
As String * ESB_MBRNAMELEN	Type	The currency type dimension member (currency databases only) . If none exists, this field is an empty string.
As String * ESB_MBRNAMELEN	CrPartition	The currency partition member (non-currency databases only)