EssGetDatabaseInfoEx() retrieves information for one or more databases, which contains non user-configurable parameters for the databases.
ESS_FUNC_M EssGetDatabaseInfoEx (hCtx, AppName, DbName, pusCount; ppDbInfo);
ESS_HCTX_T | hCtx |
ESS_STR_T | AppName |
ESS_STR_T | DbName |
ESS_PUSHORT_T | pusCount |
ESS_PPDBINFO_T | ppDbInfo |
hCtx | Essbase API context handle. |
AppName | Name of application for which to return database information. If NULL, returns information for all applications and databases. |
DbName | Name of database for which to return database information. If NULL, returns information for all databases. |
pusCount | Number of information structures to be returned |
ppDbInfo | Pointer to array of information structures. |
If successful, this function returns an array of database information structures.
This function requires the caller to have at least read access (ESS_PRIV_READ) to the specified database.
ESS_FUNC_M ESS_GetDatabaseInfoEx (ESS_HCTX_T hCtx, ESS_HINST_T hInst) { ESS_FUNC_M sts = ESS_STS_NOERR; ESS_STR_T AppName; ESS_STR_T DbName; ESS_PDBINFO_T DbInfo = NULL; ESS_USHORT_T Count; ESS_USHORT_T ind; AppName = "Sample"; DbName = ""; sts = EssGetDatabaseInfoEx(hCtx, AppName, DbName, &Count, &DbInfo); if(!sts && DbInfo) { printf("\r\n------- Database Info Ex --------\r\n\r\n"); for(ind = 0; ind < Count; ind++) { printf("AppName: %s\r\n",DbInfo[ind].AppName); printf("DbName: %s\r\n",DbInfo[ind].Name); printf("DbType: %d\r\n",DbInfo[ind].DbType); printf("Status: %d\r\n",DbInfo[ind].Status); printf("nConnects: %d\r\n",DbInfo[ind].nConnects); printf("nLocks: %d\r\n",DbInfo[ind].nLocks); printf("----------------------------------\r\n\r\n"); } EssFree(hInst, DbInfo); } return (sts); }
EssGetApplicationInfo()
EssGetDatabaseInfo()
EssGetDatabaseState()
EssGetDatabaseStats()