To start a database in Normal or Read Only Mode

  1. Start the database in Normal mode or Read Only mode from the Select Database and Startup Mode window.

  2. The Server Setting window appears.

    Note:At any point during the wizard, click Last to skip to the last step of the wizard (the Final Review window). Refer to step 41in this procedure.

  3. Enter the IP address or host name of the server in the Server Address field.

  4. Enter the port number of the server in the Server Port Number field. This must be an integer between 1025 and 65535.

  5. Enter the idle time out value of the server in the Idle time-out value field.

  6. Enter a value for the maximum number of connections to the database in the Maximum number of connections field.

  7. Check the Network encryption check box to allow for network encryption.

  8. Check the Save dmServer log to file check box to save the dmServer log to file.

  9. Check the Start I/O server check box to start the I/O server for the database.

  10. Check the Automatically update statistics check box to have the database's statistics updated automatically.

  11. Mail setting of error report system.

  12. Click the Next button. The DCCA Setting window appears.

  13. Enter the number of data buffer pages to allocate from memory in the Data buffer (page) field or select Auto-configuration to have DBMaker select the value.

  14. Enter the number of journal buffer pages to allocate from memory in the Journal buffer (page) field.

  15. Enter the number of pages to allocate from memory for the System Control Area in the System control area (page) field.

  16. Click the Next button. The Backup Server Settings window appears.

  17. To enable full and incremental backups, check the Start backup server check box. The Backup directory field, the Full backup and schedule setup, and the Incremental backup and schedule setup buttons become active.

  18. Enter a path into or select the browse button next to the Backup directory field for the location of the backup data.

  19. Click the Full backup and schedule setup button to setup the full backup settings. The Full Backup Settings window appears.

  20. Enter a path into or select the browse button next to the Directory of previous full backup field for the location of the data from a previous backup. If this field is left blank, DBMaker will overwrite the previous backup.

  21. Enter a start time for the full backup in the Start time of full backup field.

  22. Enter the interval for the full backup replication daemon to update in the Full backup daemon interval field.

  23. Select whether system or user file objects are backed up.

  24. Click the OK button. The user is returned to the Backup Server Settings window.

  25. Click the Incremental backup and schedule setup button to setup the full backup settings. The Incremental Backup Settings window appears.

  26. To enable incremental backups check the Backup data or the Backup data and BLOB check box.

  27. Enter a start time for the backup in the Backup start time field.

  28. Enter the interval for the incremental backup replication daemon to update in the Backup time interval field.

  29. Enter a value for the journal files to be backed up in the Start incremental backup when journal file _% Full, or check the Backup when any journal file is full check box.

  30. Enter a file format for the backup data in the Incremental backup file format field.

  31. Click the OK button. The user is returned to the Backup Server Settings window.

  32. Click the Next button. The Advanced Settings window appears.

  33. To set file object options click the File object settings button. The File Object Settings window appears.

    1. Enter a path into or select the browse button next to the System file object directory field for the location of the system file objects.

    2. Enter a value for the number of files per file object in the file object directory in the Number of files per file object in sub directory or check the Always in the same directory check box.

    3. Check the Enable user file object check box to enable the use of user file objects.

    4. Click the OK button. The user is returned to the Advanced Settings window.

  34. To set up asynchronous table replication settings click the Asynchronous table settings button. The Asynchronous Table Settings window appears.

    1. Check the Start asynchronous table replication distributor check box to start asynchronous table replication.

    2. Enter a path into or select the browse button next to the ATR log file directory field for the location of the ATR log files.

    3. Check the Start express asynchronous table replication subscriber check box to start express asynchronous table replication. The Port number of the express ATR subscriber field becomes active.

    4. Enter a port number in the Port number of the express ATR subscriber field.

    5. Click the OK button. The user is returned to the Advanced Settings window.

  35. To set the distributed database settings click the Distributed database environment settings button. The Distributed database environment settings window appears.

  36. To enable DBMaker to function as a distributed database check the Enable distributed database mode check box. The remaining options in the window become active.

    1. Set a time-out value in the Remote database connection time-out value field.

    2. Set a lock time-out value in the Remote database lock time-out field.

    3. Check the Start global transaction recovery daemon check box to start the daemon.

    4. Set a time interval to recover pending transactions in the Time interval to recover pending transactions fields.

    5. Click the OK button. The user is returned to the Advanced Settings window.

  37. To set SQL attribute settings click the SQL attribute settings button. The SQL Attributes Settings window appears.

    1. Select an input date format from the Date input format drop down list.

    2. Select an output date format from the Date output format drop down list.

    3. Select an input time format from the Time input format drop down list.

    4. Select an output time format from the Time output format drop down list.

    5. Select the whether the last SQL command and its time of execution are displayed in the system catalog table from the Display SQL command monitor check boxes.

    6. Select Remove space padding for CHAR data to remove space padding before a CHAR type data.

    7. Select Remove space padding in string concatenation to remove space padding before a string concatenation.

  38. Click the OK button. The user is returned to the Advanced Settings window.

  39. To set temporary file settings click the Temporary file settings button. The Temporary File Settings window appears.

    1. Double click a field to enter the temporary file name.

    2. Enter the temporary file's name.

    3. Click the OK button. The user is returned to the Advanced Settings window.

  40. To set stored procedure options click the Stored procedure settings button. The Stored Procedure Settings window appears.

    1. Enter a path into or select the browse button next to the Directory of stored procedures field for the location of stored procedures.

    2. Enter a path into or select the browse button next to the Stored procedures include files directory field for the location of the ATR log files.

    3. Enter a path into or select the browse button next to the Directory of stored procedure info file field for the location of information files for stored procedures.

    4. Click the OK button. The user is returned to the Advanced Settings window.

  41. Click the Next button. The Final Review window appears.

  42. Check over the database settings. If any of the settings need to be changed click the Previous button to the appropriate window and make the changes. Then return to the Final Review window.

  43. Click the Finish button when satisfied with the database settings. The following dialog box will appear.


Related Topics:

Normal or Read Only Mode Startup