Determining server database requirements for node replication

Node replication requires more Tivoli® Storage Manager database space to track the files that are replicated.

About this task

To determine whether the database can manage more space requirements, you must estimate how much more database space that node replication will use.

Requirement: Place the database and database logs on separate disks that have a high performance capability. Use a separate disk or mount point for the following options:

Other applications that use the database and logs
System tasks, such as system paging

Procedure

Determine number of files for each node and data type that is in use. Issue the QUERY OCCUPANCY command for each node and data type that you plan to replicate. For example, you can display information about the file spaces that are assigned to the node named PAYROLL by issuing the following command:
```
query occupancy payroll
```
Determine how much more database space is required by using the value for the total number of files that are used by all nodes and data types. Use the following formula to calculate the amount of database space that is required:
Total_number_of_files_from_all_nodes_and_data_types * 300 (the number of additional bytes needed for each replicated file)

Important: You must increase the available database space when the additional required space approaches or exceeds the size of your database. Ensure that you examine both replication servers and their databases and increase the database size if necessary.
Increase the size of the database by the additional database space required and include an additional 10% of the database size.