Kbase 16677: What are Virtual System Tables (VST's)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/27/2009 |
|
Status: Verified
GOAL:
What are Virtual System Tables (VST)?
GOAL:
What are VSTs?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.x
FIX:
Virtual System Tables provide 4GL application access to the same database information that can be collected with the PROMON utility. The Virtual System Tables, or schema tables, have no physical records until the database manager generates them at runtime. This enables a 4GL application to retrieve information about users accessing the database at runtime. As we provide the table and field information for 4GL access, we do not provide routines to access this information. It is the responsibility of the Application developer or end user to develop and maintain the code that accesses this information.
Use the following command to enable VST's:
proutil dbname -C enablevst
Once VST's are enabled there is not a corresponding option within proutil to disable them.
VST's are ALREADY enabled on version 9 and above by default, so it is not necessary to run the above command.
On Version 9 and above, as new virtual system tables are made available, you can update the schemas in a database with the following command:
proutil dbname -C updatevst