The .st file of a database must reflect the current information in the database structure (.db) file to ensure continuity and consistency of database administration. So, every time you make changes to the structure of a database, such as adding, moving, or removing extents, you must update the .st file.

To do this, you use the PROSTRCT LIST utility. This utility uses the current information in the database structure (.db) file to show extent information in a database such as storage area names and types, records per block, blocks per cluster, as well as extent names, types, and sizes. It also generates a new .st file based on the database name and overwrites the existing .st file.

If you want to retain the existing .st file, rename the file before using PROSTRCT LIST. You can invoke PROSTRCT LIST online or offline.

The command to update the .st file of a database is:
prostrct list db-name [.st-file]
After you have added extents to the sports database online, you can update the .st file of the database. Assuming that you want to overwrite the existing .st file, enter:
prostrct list sports

A new sports.st file is created.