Consultor Eletrônico

Status: Unverified

GOAL:

What is the Local schema cache time stamp under promon?

FIX:

Under promon > 7. Database Status there is an entry for Local schema cache time stamp. This refers to the local schema for the database. This time stamp is updated when the schema is updated. This local schema cache is that used by the broker when starting the database.

The following example used Progress 9.106 -

1. prodb sports sports
2. proserve sports; promon sports
3. 7. Database Status:

Database Status:
Database version number: 1115
Database state: Not modified since last open (2)
Database damaged flags: None (0)
Integrity flags: None (0)
Database block size (bytes): 1024
Total number of database blocks: 828
Database blocks high water mark: 784
Free blocks below highwater mark: 0
Record blocks with free space: 4
Before image block size (bytes): 8192
Before image cluster size (kb): 512
After image block size (bytes): 8192
Last transaction number: 173
Highest file number defined: 0
Database created (multi-volume): 08/25/03 16:05
Most recent database open: 08/25/03 16:06
Previous database open: 08/25/03 16:06
Local schema cache time stamp: 05/08/02 01:57
Most recent .bi file open: 08/25/03 16:06

Note that the Local schema cache time stamp is actually earlier than the database creation date. Copied or restored databases (procopy, prodb, prorest) keep the local schema cache time stamp of the source, whereas with databases created with prostrct create and a subsequent load it can be seen that the database creation date will be earlier than the local schema cache time stamp.

4. Shut down the database, then e.g. add a table. Checking promon then shows that the entry has been updated, e.g.

Local schema cache time stamp: 08/25/03 16:30

Note that this isn't the same concept as the local schema cache accessed by clients using the -cache parameter, though it is related.