Number of documents loaded in CMOD?

[jose.arotinco]

Hi all,

Is there any way of knowing how many there are documents loaded in CMOD of all the AG?  there may be a command or example that can give me

Thank you very much..

Regards;

[Alessandro Perucchi]

Hello Jose,

Well the most direct way would be to do a "SELECT COUNT(*) FROM AGTableSegment"

where AGTableSegment is the all the tablename of an Application Group.

exemple

SELECT COUNT(*) FROM ADA1

To find the active table segment:

SELECT AGID, TABLE_NAME FROM ARSSEG

or if you love better to see the actual name instead of the AGID:

SELECT DISTINCT A.NAME, B.TABLE_NAME FROM ARSAG AS A,  ARSSEG AS B WHERE A.AGID=B.AGID

I hope this helps.

Cheers,
Alessandro

[jose.arotinco]

Thanks Alessandro! with the help of your example, I did the following query:

SELECT
DISTINCT A.NAME
B.TABLE_NAME,
SUM (B.INS_ROWS) AS INSERTED,
SUM (B.DEL_ROWS) AS DELETED
ARSAG FROM AS A AS B ARSSEG
WHERE A.AGID = B.AGID
GROUP BY A.NAME, B.TABLE_NAME
ORDER BY 3

Regards,