Updating the Estimated Capacity Table
Use the following procedure to insert rows into the NetBackup Estimated Capacity database table.
1. Log on to the Portal Server as user aptare.
2. Type the following command:
3. 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.
4. 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.
5. To verify estimated capacities after updating the database table, execute the following commands, supplying the NetBackup Master Server ID:
sqlplus portal/portal execute media_package.setupTapeMediaCapacity(<master server ID>); |