Upgrading › How to Upgrade CA Performance Management Data Aggregator - Command Line › Verify That All Database Tables Are Segmented

Verify That All Database Tables Are Segmented

Verify that all database tables are segmented. Segmenting the tables reduces the amount of disk space that is required for the database. Segmenting the tables also improves general query performance.

Follow these steps:

1. As the Vertica Linux database administrator user, log in to one of the computers in the cluster where Data Repository is installed.
2. Download the segment.py script from where you extract the installation media. Put the script within a directory that is writeable to the Vertica Linux database administrator user. This procedure assumes that the segment.py script is in the home directory of the Vertica Linux database administrator user.
3. Open a command prompt and type the following command:

   ./segment.py --task tables --pass database_admin_user_password  [--name database_name] [--port database_port]
   

   database_admin_user_password

   Indicates the Vertica Linux database administrator user password.

   database_name

   Indicates the name of the database. Optional, if the database name is not the default, drdata.

   database_port

   Indicates the port to use to connect to Vertica. Optional, if the port number is not the default, 5433.

   For example:

   ./segment.py --task tables --pass password  --name mydatabase
   

   Any currently unsegmented table projections, which are sorted from largest to smallest, are returned.

4. If unsegmented database table projections are returned, segment the tables.

More information:

How to Upgrade CA Performance Management Data Aggregator - Command Line