ESS_DBINFO_T

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

typedef struct  ESS_DBINFO_T
{
   ESS_APPNAME_T      AppName;
   ESS_DBNAME_T       Name;
   ESS_USHORT_T       DbType;
   ESS_USHORT_T       Status;
   ESS_USHORT_T       nConnects;
   ESS_USHORT_T       nLocks;
   ESS_ULONG_T        nDims;
   ESS_USHORT_T       Data;
   ESS_MBRNAME_T      Country;
   ESS_MBRNAME_T      Time;
   ESS_MBRNAME_T      Category;
   ESS_MBRNAME_T      Type;
   ESS_MBRNAME_T      CrPartition;
   ESS_TIME_T         ElapsedDbTime;
   ESS_ULONG_T        DataFileCacheSetting;
   ESS_ULONG_T        DataFileCacheSize;
   ESS_ULONG_T        DataCacheSetting;
   ESS_ULONG_T        DataCacheSize;
   ESS_ULONG_T        IndexCacheSetting;
   ESS_ULONG_T        IndexCacheSize;
   ESS_ULONG_T        IndexPageSetting;
   ESS_ULONG_T        IndexPageSize;
   ESS_DBREQINFO_T    DbReqInfoAry[ESS_DBREQNUM];
   ESS_BOOL_T         bDbReadOnly;
   ESS_BOOL_T         bDataCompress;
   ESS_USHORT_T       usDataCompressType;
   ESS_ULONG_T        ulRetrievalBuffer;
   ESS_ULONG_T        ulRetrievalSortBuffer;
   ESS_BOOL_T         bCacheMemLocking;
   ESS_BOOL_T         bPreImage;
   ESS_USHORT_T       usIsolationLevel;
   ESS_LONG_T         lTimeOut;
   ESS_ULONG_T        ulCommitBlocks;
   ESS_ULONG_T        ulCommitRows;
   ESS_ULONG_T        ulDiskVolumeCount;
   ESS_DISKVOLUME_T   aDiskVolume[1];
} ESS_DBINFO_T, *ESS_PDBINFO_T, **ESS_PPDBINFO_T;

Data TypeFieldDescription
ESS_APPNAME_TAppNameThe associated application name
ESS_DBNAME_TNameThe database name
ESS_USHORT_TDbTypeDatabase type. Values:
  • ESS_DBTYPE_NORMAL

  • ESS_DBTYTPE_CURRENCY

ESS_USHORT_TStatusDatabaseLoad status (loaded or not loaded . Values:
  • ESS_STATUS_NOTLOADED

  • ESS_STATUS_LOADING

  • ESS_STATUS_LOADED

  • ESS_STATUS_UNLOADING

ESS_USHORT_TnConnectsNumber of users currently connected to the database
ESS_USHORT_TnLocksNumber of data blocks currently exclusively locked
ESS_ULONG_TnDimsNumber of dimensions in database
ESS_USHORT_TDataFlag indicating loading state of the data in the database. Values:

ESS_DBDATA_NONE: no data loaded

ESS_DBDATA_LOADNOCALC: data loaded but not calculated

ESS_DBDATA_CLEAN: data loaded and calculated

ESS_MBRNAME_TCountryThe currency country dimension member, if any. If none, the first byte is NULL.
ESS_MBRNAME_TTimeCurrency time dimension member, if any. If none, the first byte is NULL.
ESS_MBRNAME_TCategoryThe currency category dimension member, if any. If none, the first byte is NULL.
ESS_MBRNAME_TTypeCurrency type dimension member (currency databases only). If none exists, the first byte is NULL.
ESS_MBRNAME_TCrPartitionThe currency partition member (non-currency databases only)
ESS_TIME_TElapsedDbTimeNumber of seconds the database has been loaded
ESS_ULONG_TDataFileCacheSettingThe Data File Cache Size setting value currently in effect.
ESS_ULONG_TDataFileCacheSizeThe Run-time data file cache size (in KB) currently in use by database. Note that once you have changed the data file cache size you must stop and restart the database in order for the new data file cache size to take effect.
ESS_ULONG_TDataCacheSettingThe Data Cache Size setting value (in KB) currently in effect.
ESS_ULONG_TDataCacheSizeThe run-time size (in KB) of the Data Cache/
ESS_ULONG_TIndexCacheSettingThe Index Cache Size (in KB) setting value currently in effect.
ESS_ULONG_TIndexCacheSizeRun-time size (in KB) of the Index Cache.
ESS_ULONG_TIndexPageSettingThe Index Page Size setting (in KB) currently in effect.
ESS_ULONG_TIndexPageSizeRun-time size (in KB) of an Index Page.
ESS_DBREQINFO_TDbReqInfo, Ary[ESS_DBREQNUM]Array for request information, including last calc, dataLoad, and outline update
ESS_BOOL_TbDbReadOnlyTRUE if the database is in read-only mode; FALSE otherwise.
ESS_BOOL_TbDataCompressOptional compression flag (the default is YES).
ESS_USHORT_TusDataCompressTypeThe data compression type if the optional compression flag is set (the default is BitMap).
ESS_ULONG_TulRetrievalBufferRetrieval buffer size allocated per retrieval request (the default is 2048 bytes).
ESS_ULONG_TulRetrievalSortBufferRetrieval sort buffer size allocated per retrieval request (the default is 10240 bytes).
ESS_BOOL_TbCacheMemLockingTRUE if index and data cache memory pages are locked into physical memory.
ESS_BOOL_TbPreImageFlag to read previously committed.
ESS_USHORT_TusIsolationLevelIsolation level (the default is UNCOMMITTED).
ESS_LONG_TlTimeOutTime out set in seconds for COMMITTED access only.
ESS_ULONG_TulCommitBlocksThe number of data blocks updated before the explicit commit is performed (during calculation and spreadsheet updates).
ESS_ULONG_TulCommitRowsThe number of rows of the input file processed before the explicit commit is performed during the dataload.
ESS_ULONG_TulDiskVolumeCountThe number of disk volume settings for this database.
ESS_DISKVOLUME_TaDiskVolume[1]an array of disk volume settings