Kbase P132786: Is there a way to determine if a database is running with directio?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/2/2008 |
|
Status: Unverified
GOAL:
Is there a way to determine if a database is running with directio?
GOAL:
How can I tell if my database was started with the -directio parameter?
GOAL:
How can identify if a database is running with directio?
GOAL:
Is there a command to show me if the database is running with directio?
GOAL:
How to identify which startup parameters were used when the database was started?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
To determine if a database was started with the database startup parameter, -directio, you will need to check in the database log file. The database log file is called dbname.lg (dbname indicates the name of the database). The following is an example of performing a UNIX more command against a dbname.lg file and then using the UNIX grep command to see if the file contains the Progress/OpenEdge message number 4238 which will signifies if the -directio parameter was enabled or not. The example below is for OpenEdge 10.1C. Although previous versions Progress/OpenEdge may have different formats for the log file. The Progress/OpenEdge message 4238 is not unique to a specific version.
Example:
solaris:101c$ more dbname.lg | grep directio
[2008/06/27@15:30:25.522-0400] P-19027 T-1 I BROKER 0: (4238) Direct I/O (-directio): Enabled.