Changing Maximum Rows

Previous topic - Next topic

DDEVENPORT

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

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

Alessandro Perucchi

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