OnDemand Users Group

Support Forums => CMOD for z/OS Server => Topic started by: 2ma2 on August 16, 2013, 09:30:06 AM

Title: Which Ondemand table holds information
Post by: 2ma2 on August 16, 2013, 09:30:06 AM
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. ?
Title: Re: Which Ondemand table holds information
Post by: Alessandro Perucchi on August 16, 2013, 11:42:54 AM
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
Title: Re: Which Ondemand table holds information
Post by: Greg Ira on August 16, 2013, 03:58:32 PM
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.
Title: Re: Which Ondemand table holds information
Post by: 2ma2 on September 25, 2013, 12:18:44 PM

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