Author Topic: Folder hit limit in case of multiple AG  (Read 2483 times)

dmalvi

  • Guest
Folder hit limit in case of multiple AG
« on: January 11, 2018, 02:31:05 AM »
Hi Everyone,

I have a folder where 2 AGs are mapped. Max Hit Limit for a User is 200.

In this case, for a single search there are 209 documents present, 201 in a 1st AG and 8 is in 2nd AG.

ideally query should go to both the AGs and top 200 result should be shown.

Problem Statements :

The query which is having more then 200 result are not going into 2nd AG and only Old Documents are visible.
I don't want to increase the limit on this folder.

Could someone please help me with this issue.

Nolan

  • Full Member
  • ***
  • Posts: 152
    • View Profile
Re: Folder hit limit in case of multiple AG
« Reply #1 on: January 11, 2018, 07:39:54 AM »
Is this not just having the user adjust the date value to the current date?  When you say only Old Documents are visible that implies the date range can be adjusted.
You could adjust the default date range to only current day if you don't want the users to get older documents unless requested.

J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Folder hit limit in case of multiple AG
« Reply #2 on: January 11, 2018, 01:01:14 PM »
This is just a limitation of using MaxHits.  I think you can force a sort on the returned results, and then take to top X hits from that list -- but that presumes that you know how the users want to see the results displayed to them.

-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

ewirtz

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Re: Folder hit limit in case of multiple AG
« Reply #3 on: January 15, 2018, 04:24:38 AM »
Hi Justin,
this does only work if you activate a server based sort. But this implies that it might have a performance impact if the result set is big.

regards

Egon

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Folder hit limit in case of multiple AG
« Reply #4 on: January 15, 2018, 07:55:44 AM »
Hi Egon,

Yup, you're absolutely right -- which is why I think the option isn't used very much.  It only takes one or two bad queries to drag a machine down and make it impossible for other users to get anything done.

-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

dmalvi

  • Guest
Re: Folder hit limit in case of multiple AG
« Reply #5 on: January 17, 2018, 03:40:36 AM »
Hi Justin/Egon,

That for your views on this.  :)

Is there something we can achieve this with Query restriction? Just a thought ....

The problem is,  there is no date range available for the client to search on front end.

-Deep

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Folder hit limit in case of multiple AG
« Reply #6 on: January 17, 2018, 07:09:46 AM »
Not having a date range to search is NOT a good idea.  That means that every search must query EVERY Application Group table in CMOD.

The 'best practice' for CMOD is to have a narrow date search by default which should meet the majority of user's needs, and then allow users to expand the dates they search if they need more information.

-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