Answer

As part of the Support-contributed toolkit, nz_db_size reports allocated SPU disk usage. By default, nz_db_size checks the entire appliance and produces a usage line for the appliance, each database and every table in that database. To generate this report for a specific database, add the database name to the end of the command line as shown below:

[nz@cs-spubox2 bin]$ nz_db_size mydatabase

nz_db_size reports allocated disk usage which is different than the actual amount being used. Because storage is allocated in 3MB allocations, it is likely that the used bytes will differ. To report on allocated extents, run a command similar to to the following:

[nz@cs-spubox2 bin]$ nz_db_size mydatabase -extents

And because extents are made up of 128KB pages, you might want to report on page utilization instead. Run a command similar to the following:

[nz@cs-spubox2 bin]$ nz_db_size mydatabase -pages

All three forms of this command produce the output shown above. You can further customize the output by adding one or more of the following options, which will restrict the columns output to the specified measure of disk:

• -kb, which reports usage in kilobytes
• -mb, which reports usage in megabytes
• -gb, which reports usage in gigabytes
• -tb, which reports usage in terabytes

You can specify multiple measures of disk. For example, to report on database usage in gigabytes and terabytes, you could run the following command:

[nz@cs-spubox2 bin]$ nz_db_size mydatabase -gb -tb

The default sort order of the output is alphabetic. Alternatively, you can order the output by descending size by adding the -s option to your command. For example, to list all the objects in mydatabase in descending size order, you could run the following command:

[nz@cs-spubox2 bin]$ nz_db_size mydatabase -s

You can also generate a database summary report with the -summary option. For example, to list all the databases in descending size order:

[nz@cs-spubox2 bin]$ nz_db_size -summary -s

You can also generate this report for a singular table. To do this, simply add the table name after the database argument. The following example reports on one table with sizes shown in gigabytes:

[nz@cs-spubox2 bin]$ nz_db_size mydatabase sa_cust_sales

For additional help, run the help command for the script as follows:

nz_db_size -h