# 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 Type | Field | Description
As long | ElapsedDb Time | Number of seconds the database has been loaded
As long | DataCache 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 long | IndexCache Size | Run-time index cache size (in Kbytes) currently in use by database
As long | IndexPage Size | Run-time index page size (in Kbytes) 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)