Enabling or disabling partitions

If you are installing IRC for the first time and you use an SQL server Enterprise edition for GRE based analysis or UAI extraction, the partition files are not created, by default.

However, for an IRC upgrade, if you use an SQL server Enterprise edition, partition files are created, by default.

To disable or enable the creation of partition, change the Enable Partitioned Storage value in the bizrightssetting table.

For fresh install, the Enable Partitioned Storage value is set to 0, by default. You can change the value to 1, to create the partition.
```
UPDATE BizRightsSettings SET SettingValue = 1 WHERE SettingName = 'Enable Partitioned Storage'
```
Note: You must configure this setting before scheduling the first analysis. Configuring the setting in between analyses is not recommended.
For upgrade, the Enable Partitioned Storage value is set to 1, by default. You can change the value to 0, to disable partition.
```
UPDATE BizRightsSettings SET SettingValue = 0 WHERE SettingName = 'Enable Partitioned Storage'
```
Note: You must configure this setting before scheduling the first analysis post upgrade. Configuring the setting in between analyses is not recommended.
Before you configure this setting, you must change the SQL server version from Enterprise to Standard. See the section Restoring database from Enterprise edition of the SQL server to the Standard edition in the Infor Risk & Compliance Planning and Deployment Guide