Author Topic: Changing Maximum Rows  (Read 1727 times)

DDEVENPORT

  • Guest
Changing Maximum Rows
« on: January 30, 2019, 08:32:18 AM »
Can the Maximum Rows (SEG_ROWS) be changed\updated in the ARS.ARSAG for an existing Application Group without adversely affecting the system or do I need to create and use a new Application Group? 

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Changing Maximum Rows
« Reply #1 on: January 30, 2019, 10:56:22 AM »
Don't change this in the database, go to the Admin Client, Update the Application Group, and under the advanced tab, change 10,000,000 to your new number.  I've seen between 100 and 250 million rows used effectively -- but you'll want to review your indexes.

-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

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Changing Maximum Rows
« Reply #2 on: January 31, 2019, 12:53:59 PM »
Yep, as Justin said use the admin client, OR the XML with arsxml.

Just be aware that after you change that value, CMOD will effectively use that value ONLY when you create a new segment table: close your active segment table, and then create a new one, or just load new documents.
Otherwise your current active segment table won't be able to use the new value.
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML