Author Topic: counting number of documents in CMOD  (Read 3598 times)

kader

  • Guest
counting number of documents in CMOD
« on: September 23, 2016, 08:56:44 AM »
Hi folks,

Is there a way to count the number of documents stored in CMOD?

Thanks,

Kader

Joe Wolken

  • Full Member
  • ***
  • Posts: 113
  • CMOD iSeries Consultant
    • View Profile
    • OAS Corp.
Re: counting number of documents in CMOD
« Reply #1 on: September 23, 2016, 10:10:27 AM »
You may find the information you are looking for by running various queries on the ARSSEG file.
#Installation #Upgrade #Migration #Administration #Integration #Customization #Training, and more!

Call: 512-402-1123
email: wolkenj@oascorp.com 
Click: http://www.OASCorp.com

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: counting number of documents in CMOD
« Reply #2 on: September 24, 2016, 04:02:13 AM »
Yup, there's an article on the Wiki that demonstrates exactly what you're asking:

http://cmod.wiki/index.php/Useful_SQL_Queries_for_Content_Manager_OnDemand

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ODSA

  • Jr. Member
  • **
  • Posts: 15
    • View Profile
Re: counting number of documents in CMOD
« Reply #3 on: June 08, 2022, 01:18:33 PM »
Hi Justin,

Thanks for sharing useful tips here.

I am trying to get count of all the documents that we have in our CMOD today, I tried below command but the AG count doesn't match with what I have in CMOD (the count comes to be less than what I have in CMOD).

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"

I get 1137 record(s) selected vs I have 1461 AGs in CMOD.

Would you know why there is the difference in the record count?

Thanks Ahead !!

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: counting number of documents in CMOD
« Reply #4 on: June 08, 2022, 02:33:49 PM »
I'm guessing you have a large number of empty App Groups.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ODSA

  • Jr. Member
  • **
  • Posts: 15
    • View Profile
Re: counting number of documents in CMOD
« Reply #5 on: June 10, 2022, 03:07:48 PM »
I spot checked some of the AGs that are missing from the list, they are actually empty. Yeah, seems like we have few 100 empty AGs.

Thanks for the help!!