Updating the estimated capacity table

Use the following procedure to insert rows into the NetBackup Estimated Capacity database table.

Type the following command:

sqlplus portal/portal@//localhost:1521/scdb

Insert a row into the apt_nbu_tape_capacity_est table. The following example shows how to insert the values.
```
INSERT INTO apt_nbu_tape_capacity_est (volume_pool_id, media_type, estimated_mbyte_capacity)
VALUES (100304, 10, 35850);
commit;
```
In this example, both the volume_pool_id and media_type will be used to establish the estimated capacity.
You also can insert a row into this table using media_type only (omitting the volume_pool_id), as shown in the following example.
```
INSERT INTO apt_nbu_tape_capacity_est (volume_pool_id, media_type, estimated_mbyte_capacity)
VALUES (NULL, 9, 30000);
commit;
```
In this example, only the media_type will be used when the calculation searches for an estimated capacity override.
To verify estimated capacities after updating the database table, execute the following commands, supplying the NetBackup Primary Server ID:
```
sqlplus portal/portal@//localhost:1521/scdb 
execute media_package.setupTapeMediaCapacity(<primary server ID>);
```