To create a database using the Create Database Wizard

  1. Select Create Database from the Wizard drop-down menu. The Create Database Wizard window will appear.

  2. Click the Next button after reading the brief explanation of how the wizard will guide you through the process of creating a database. The Database Name and Client/Server Setting window appears.

  3. Enter a name for the database in the Database name field.

  4. The user now has the choice of creating a single user or a multi-user database.

    1. To create a single user database uncheck the Multi user database check box. Now continue to step 7.

    2. To create a multi-user database check the Multi-user database check box. Continue to step 5.

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

    Note: If a host name is specified, ensure that Domain Name Server is set up on the server.

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

  7. Click the Next button. The Create Database Directory window appears.

  8. Enter the database directory into the Database Directory field, or select the browse button . If the browse button is selected, the Open Directory dialog box will appear:

  9. The default database directory path is DBMaker\4.0\bin\. A new directory should be created for the database. To create a new database directory, click the browse button

  10. In the Select file window, navigate to the desired root for the database directory.

  11. Click on the Create New Directory button to make a directory called New Folder.

  12. Select the New Folder directory and enter the desired name for the database directory.

  13. Select the new directory name from the list so that it appears in the File name field.

  14. Click OK, the Create Database Directory window appears.

  15. Click the Setup system and user tablespace file button to set the system and user tablespace files. The System and User Tablespace File Setup window appears.

  16. Enter a path or select the browse button next to the System data file name field to indicate the location of the System Data File.

  17. Enter a path or select the browse button next to the System BLOB file name field to indicate the location of the System BLOB File.

  18. Enter a path or select the browse button next to the User data file name field to indicate the location of the User Data File option.

  19. Enter a path or select the browse button next to the User BLOB file name field to indicate the location of the User BLOB File.

  20. Enter the number of pages to allocate from disk for each user data file in the User data file pages size field.

  21. Enter the number of frames to allocate from disk for each user BLOB file in the User BLOB file frames size field.

  22. Click OK. The Create Database Directory window reappears.

  23. Click the Setup temporary file button to set the temporary file name. The Specify Temporary File Name window appears.

  24. Double click in one of the fields to enter a name for the temporary system file.

  25. Enter a name for the temporary system file and click OK. The Create Database Directory window reappears.

  26. Click Next. The Specify Journal File window appears.

  27. Double click a field to enter the journal file name.

  28. Enter the journal file's name.

  29. Set the journal file size. Valid values are between 100 and 524287, with the default value set at 1000.

  30. Click Next. The Language and Case Sensitivity Setting window appears.

  31. To change the character set the database will use for CHAR type data, select one of the four options from the Language code menu.

  32. Enter a path or select the browse button next to the Order definition file field to indicate the location of the order definition file.

  33. To make all database objects case insensitive check the Convert identifier to uppercase check box.

  34. Click Next. The BLOB and File Object Setup window appears.

  35. Enter a BLOB frame size in bytes in the BLOB frame size (KB) field.

  36. Enter a path or select the browse button next to the System file object directory field to indicate the location of the database's system file objects.

  37. Check the Enable user file object check box to allow user file objects.

  38. Click Next. The Final Review window appears.

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

  40. Click the Finish button when satisfied with the database settings.


Related Topics:

Using the Create Database Wizard