Progress
Database Administration
Guide and Reference
Status Displays>Database
Displays general database status information. Figure A–1 shows a sample Database Status display.
Figure A–1: PROMON Database Status Display
The display in Figure A–1 contains the following fields:
- Database state — The current operating mode of the database. Table A–2 describes the possible states.
- Database damaged flags — The state of the database. Table A–3 lists the possible flags.
- Integrity flags — The integrity mode in which the database is running. Table A–4 lists the possible flags.
Table A–4: Integrity Flags State Description None Normal. Executing with -i A crash in this state will damage the database. Executing with -r A crash in this state might damage the database.- Most recent database open — The date and time when the broker for this database was started.
- Previous database open — The date and time when the database was previously started.
- Local cache file time stamp — The time stamp used to check the validity of the schema cache file. For more information, see the description of the Schema Cache File (-
cache
) parameter in Database Startup Parameters."- Database block size — The database block size in bytes.
- Number of blocks allocated — The total number of blocks allocated to the database.
- RM Blocks with free space — The total number of blocks in the RM chain.
- Highest table number defined — The number of tables defined in the database.
- Database version number — Identifies the structures of all database-related data that is resident on disk. Progress uses this number to match different executable versions with the correct database structures.
- Shared memory version number — Identifies the version of all data structures that are resident in shared memory and used by the database manager. Progress uses this number to ensure that all executables accessing shared memory agree on what data is kept in shared memory and how that data is accessed. The shared-memory version number changes more frequently than the database version number.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |