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 !!