Collecting Performance Statistics › Monitor the Encyclopedia Profile

Monitor the Encyclopedia Profile

Use the following SQL queries to gather statistics about the encyclopedia profile.

Number of models in encyclopedia:

SELECT COUNT (*)
FROM DMDL

Number of models updated during last month:

SELECT COUNT (*)
FROM DMDL
MODEL_DATE > CURRENT DATE - 1 MONTH

Size of models and number of objects:

   SELECT MODEL_NAME, COUNT (*)
   FROM DMDL,
   DOBJ
   WHERE OBJ_MODEL_ID = MODEL_ID
   GROUP BY MODEL_NAME
   ORDER BY 2 DESC

Number of objects in model and subset checkouts:

 SELECT MODEL_NAME, S_SUBSET_NAME, CKO_USER_ID, COUNT (*)
 FROM DMDL, DCKOID, DSUBID, DSUBEX
 WHERE CKO_MODEL_ID = MODEL_ID
 AND CKO_STATUS = 'C'
 AND CKO_SUBSET_ALL = 'N'
 AND CKO_SUBSET_ID = S_SUBSET_ID
 AND SE_CKO_ID = CKO_ID
 GROUP BY MODEL_NAME, S_SUBSET_NAME, CKO_USER_ID
 UNION
 SELECT MODEL_NAME, 'ALL', CKO_USER_ID, COUNT (*)
 FROM DMDL, DCKOID, DSUBEX
 WHERE CKO_MODEL_ID = MODEL_ID
 AND CKO_STATUS = 'C'
 AND CKO_SUBSET_ALL = 'Y'
 AND SE_CKO_ID = CKO_ID
 GROUP BY MODEL_NAME, CKO_USER_ID

User IDs authorized to encyclopedia:

SELECT U_USER_TYPE, COUNT (*)
FROM DUSR
GROUP BY U_USER_TYPE