Starting a Database: Advanced Settings |
How
To |
Database administrators should ensure that all necessary
changes to settings are made to a database before startup. Advanced settings
include:
- Storage location of the
database's operating system files
- Upper memory caching of
data pages and system control
- Backup type, frequency
and location
- Location and frequency
of table or database replication
- Database startup mode
- User defined file name
- Network connection behavior
- SQL command upper memory
caching, CHAR data output padding, system File Object mapping, Cursor
Behavior, and Browse Mode
- Date and time formatting
for SQL statements, stored procedure settings
- Distributed database behavior
- Group commit settings
The settings in the JServer Manager correspond exactly
with the settings in the JConfiguration Tool. To learn more about how
these settings affect the management of databases, refer to the
JConfiguration Tool Reference.
Related topic:
Starting
a Database
Starting a Database: Basics
Using the Start Database Wizard