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_T structure, 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   	DataCacheSize;         
   ESS_ULONG_T   	IndexCacheSize;        
   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_USHORT_T  	usIsolationLevel;    
   ESS_BOOL_T    	bPreImage;          
   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_TElapsedDb
Time
Number of seconds the database has been loaded
ESS_ULONG_TDataCache
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.
ESS_ULONG_TIndexCache
Size
Run-time index cache size (in Kbytes) currently in use by database
ESS_ULONG_TIndexPage
Size
Run-time index page size (in Kbytes) currently in use by database
ESS_DBREQINFO_T DbReqInfo
Ary[ESS_DB REQNUM]
Array for request information, including last calc, dataLoad, and outline update