OnDemand User Group

Support Forums => z/OS Server => Topic started by: DDEVENPORT on January 30, 2019, 08:32:18 AM

Title: Changing Maximum Rows
Post by: DDEVENPORT 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? 

Title: Re: Changing Maximum Rows
Post by: Justin Derrick 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.

Title: Re: Changing Maximum Rows
Post by: Alessandro Perucchi 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.