Performing a Database Restructure
If you have the Administrator role, you can perform a full restructure of a database (or block storage cube) to eliminate or reduce fragmentation. This process will also remove empty blocks.
It is best practice to have only users with the Administrator role perform the restructure of a database.
You can restructure a database by using either the Calculation Manager or Jobs Scheduler.
To proactively remove fragmentation from your database, you should use Jobs Scheduler to periodically run restructures.
You should schedule these periodic restructures during hours when users are not using the NetSuite Planning and Budgeting application because this task can be long-running and resource intensive.
You cannot undo this action.
To restructure a database by using Calculation Manager:
-
From the Home page, click the Navigator icon
.
-
Under Create and Manage, click Rules.
Note:You may need to disable any ad blockers plug-ins to view the Calculation Manager window.
-
In the Calculation Manager window, under the System View tab, click Actions > Database Properties.
-
Database Properties opens in a new tab. Under Enterprise View, expand Planning and then NetSuite.
-
Right-click a database, and then click Restructure Database.
-
Click OK.
To restructure a database by using Jobs Scheduler:
-
From the Home page, click the Navigator icon
.
-
Under Application, click Jobs.
-
Click Schedule Jobs.
-
Scroll down the list on the left pane and select Restructure Cube.
-
Choose to either Run Now or Schedule starting from.
-
If you choose Schedule starting from:
-
Select a starting date, time, and time zone.
-
Enter a name for this job and a recurrence pattern.
-
(Optional) Check the End Date box if you want to end the job, and then select an end date and time.
-
-
Click Next.
-
In the Cube field, select a database to restructure.
-
Click Next.
-
Review your choices in the Review page, then click Finish.