Which Ondemand table holds information

[2ma2]

I want to get the size and amount of documents for specific documents in CMOD.

Which Ondemand DB2 table(s) holds information of references to OAM objects where I can obtain this information. ?

[Alessandro Perucchi]

Hello 2ma2,

well this information is in each segment table related to the application group you want to have some statistics.
Normally the object name is found in the doc_name field.

At least this is like that in the Multiplatform world, I suppose that in the Z world, it should be similar!

Sincerely yours,
Alessandro

[Greg Ira]

You can get the number of documents and the length of each document in the individual segment table for each application group.  To get the size of the object you would have to query the various OAM tables, such as OSM_32K_OBJ_TBL, to retrieve the size.  Depending on what information you need you could "cheat" and query the CMOD System Log table (SLn) and pull the sizes out of the MSG_TEXT column.

[2ma2]

I think the last "cheat" would fit,  and serach for "OutputSize"
Thanks