How many Documents are stored in CMOD Application Group grouped by Application

[Valentin Schmid]

Hello all,

With this SQL query it is possible to receive the number of documents per Application Group:
db2 "select arsag.name,sum(arsseg.ins_rows-arsseg.del_rows) as Total_Rows from arsag,arsseg where arsag.agid=arsseg.agid group by arsag.name"

Is there a way to receive the number of documents per Application?
(e.g. how many PDFs and how many AFPs are stored in given Application Group)

If yes, is there also a possibility to receive the required space (storage object size) per Application?

Thanks for your replies.

[Justin Derrick]

This is difficult because the Application ID field is assigned by the CMOD Admin, and probably isn't consistent across Application Groups.

You'll likely need a custom tool to do this work for you that is much more complex than your standard SQL query.

-JD.

[Alessandro Perucchi]

Hello Valentin,

if you look at this post, part of question is answered:

http://ODUG.net/index.php?topic=2166.0

Concerning the number per Application, you need to look at the segment directly, and know which field name is the "application ID" field (maybe agid / appid) and do like a SELECT appid, count(*) from SEGMENT_TABLE group by appid

I hope that helps.