Kbase 19146: How To Find What Database Startup Parameters Are Used?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/21/2006 |
|
Status: Verified
GOAL:
How can I find the Database Startup Parameters used?
GOAL:
How can I find the CodePages used?
GOAL:
How can I find the Collation used?
GOAL:
Where can I find the database startup parameters used?
GOAL:
How To Find What Database Startup Parameters Are Used?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.0x
FIX:
There are several methods to obtain the information:
- Data Administration (GUI) or Data Dictionary (TTY)
- Procedure Editor
- ProTools (Windows only)
- Progress Explorer Tool
- Promon
- Database Log file
- Session System Handle STARTUP-PARAMETERS Attribute (OpenEdge 10).
From Data Administration (GUI) or Data Dictionary (TTY) go to the Utilities menu > Information. An editor widget is displayed with several sections. The pertinent sections are:
- Currently Selected Database (database codepage and database collation)
- Environment/Startup Parameters
session stream - a value of the cpstream startup parameter.
session charset- the value of the cpinternal startup parameter.
From the Procedure Editor, run a code like the following:
FIND FIRST _db NO-LOCK.
DISPLAY _db-xl-name FORMAT "X(15)" LABEL "Db codepage"
_db-coll-name FORMAT "X(15)" LABEL "Db collation"
SESSION:CPINTERNAL FORMAT "X(15)" LABEL "4GL Codepage"
SESSION:CPCOLL FORMAT "X(15)" LABEL "4GL Collation"
SESSION:CPSTREAM FORMAT "X(15)" LABEL "4GL Stream"
WITH 1 COL. The code can be extended to display additional session attributes such as CPCASE, CPLOG, CPPRINT, DATE-FORMAT, etc. The functions DBCODEPAGE(n) and DBCOLLATION(n) can be used as well.
Please note that if you are working with Dataservers (Oracle, Progress/400, etc., you may want to replace the FIND with a FOR EACH so you can look at the schema holder and foreign database settings.
From ProTools (only on Windows), use the Session icon to present dialog that displays all session attributes. There is no information about the connected database(s).
From the Progress Explorer Tool: Highlight the specific database and expand the tree options for that database. The properties of the default configuration will list the start up options. This information is stored in <install Directory>\properties\conmgr.properties file.
From Promon: Select option 6: Shared Resources, to view some of the database startup parameters. The startup parameters can also be viewed by typing R&D and then selecting 1: Status Display from the subsequent menu. Select Option 12: Startup Parameters from the status display menu.
From the Database Log file: When the Database starts a Multi-user session, Progress will display in the Database log file the startup parameters that the dbase has acknowledged. It will look something like this:
15:34:51 BROKER 0: Multi-user session begin. (333)
15:34:51 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
15:34:51 BROKER 0: Physical Redo Phase Completed at blk 0 off 526 upd 0. (7161)
15:34:51 BROKER 0: Started for 2500 using TCP, pid 1068. (5644)
15:34:51 BROKER 0: Progress OpenEdge Release 10.0B build 1155 on WINNT . (4234)
15:34:51 BROKER 0: Server started by <user> on CON:. (4281)
15:34:51 BROKER 0: Started using pid: 1068. (6574)
15:34:51 BROKER 0: Physical Database Name (-db): <dbnam.e>. (4235)
15:34:51 BROKER 0: Database Type (-dt): PROGRESS. (4236)
15:34:51 BROKER 0: Force Access (-F): Not Enabled. (4237)
15:34:51 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
15:34:51 BROKER 0: Number of Database Buffers (-B): 168. (4239)
15:34:51 BROKER 0: Maximum private buffers per user (-Bpmax): 42. (9422)
15:34:51 BROKER 0: Excess Shared Memory Size (-Mxs): 16390. (4240)
15:34:51 BROKER 0: The shared memory segment is not locked in memory. (10014)
15:34:51 BROKER 0: Current Size of Lock Table (-L): 8192. (4241)
15:34:51 BROKER 0: Hash Table Entries (-hash): 43. (4242)
15:34:51 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
15:34:51 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
15:34:51 BROKER 0: Crash Recovery (-i): Enabled. (4244)
15:34:51 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
15:34:51 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
15:34:51 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
15:34:51 BROKER 0: Before-Image Truncate Interval (-G): 0. (4249)
15:34:51 BROKER 0: Before-Image Cluster Size: 524288. (4250)
15:34:51 BROKER 0: Before-Image Block Size: 8192. (4251)
15:34:51 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
15:34:51 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
15:34:51 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
15:34:51 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
15:34:51 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
15:34:51 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
15:34:51 BROKER 0: Maximum Number of Clients Per Server (-Ma): 5. (4257)
15:34:51 BROKER 0: Maximum Number of Servers (-Mn): 5. (4258)
15:34:51 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
15:34:51 BROKER 0: Maximum Number of Users (-n): 21. (4260)
15:34:51 BROKER 0: Host Name (-H): localhost. (4261)
15:34:51 BROKER 0: Service Name (-S): 2500. (4262)
15:34:51 BROKER 0: Network Type (-N): TCP. (4263)
15:34:51 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
15:34:51 BROKER 0: Parameter File: Not Enabled. (4282)
15:34:51 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
15:34:51 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
15:34:51 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
15:34:51 BROKER 0: Created shared memory with segment_id: 11403264 (9336)
15:34:51 BROKER 0: Database connections have been enabled. (10471).