Folder hit limit in case of multiple AG

Previous topic - Next topic

dmalvi

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

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

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

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

ewirtz

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

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

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

dmalvi

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

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.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

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