Kbase P78805: How to get a listing of the current database structure?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/9/2008 |
|
Status: Verified
GOAL:
How to get a listing of the current database structure?
GOAL:
Why isn't the .st file for my database updated after running the prostrct add command?
GOAL:
How to overwrite my database's current .st file?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
The command for listing the Progress Database File Structure is 'prostrct list'.
As a database grows additional extents are added to the database using the prostrct add command and a new .st file, which only contains a list of extents to be added to the current database structure.
The .st file for the database is not updated with these changes unless the prostrct list utility is run to do so. This command is used to generate a list of the current file structure for a database.
If a database is relocated prostrct list should be run to insure all extents will be in the .st file. Once this is done corrections for the new directory path will have to be made to the .st file.
examples:
The following syntax will over write the current db-name.st file:
prostrct list <db-name>
The following syntax will not over write the current .st file but generate an .st file with the name 'current.st':
prostrct list <db-name> current.st
Reference Written Documentation:
Database Administration Guide and Reference Manual:Prostrct List Qualifier.