Chapter 10 Setting Up the Database Server

Database creation procedure

The following procedure explains how to create a database in the Adaptive Server Anywhere server.

To create a database using Sybase Adaptive Server Anywhere:

1. Open the Sybase Adaptive Server Anywhere program group.
   
   Click the Sybase Central icon.
   
   or
   
   Run the executable SCVIEW.EXE in the Sybase Central\java directory.
   
   The Sybase Central Java Edition window is displayed.
2. Click on Adaptive Server Anywhere 9 in the left pane.
   
   The right pane displays several tabbed pages.
3. Click on the Utilities tab to display the corresponding page.
   
4. Double-click Create Database in the list view.
   
   The Create a Database welcome dialog box is displayed.
5. Click Next.
   
   Another Create a Database welcome dialog box is displayed asking you where you want to create the database. The Create a database on this machine radio button is automatically selected.
6. Click Next.
7. Type a path and a name for the database.
   
8. Click Next.
9. Make sure the check box Maintain the Following Transaction Log File is selected.
10. Accept the suggested name in the text box or type a different name. You can browse to select the log file location.
    
11. Click Next.
12. Make sure the check box Maintain the Following Mirror Log File is deselected.
    
13. Click Next.
14. Accept default selection for jConnect parameters.
    
15. Click Next.
16. Click the Adaptive Server Anywhere Defaults button to select the default options for Adaptive Server Anywhere.
    
17. Click Next.
18. Select a page size or accept the default selection.
    
19. Click Next.
20. Make sure the radio button Use the Default Collation is selected.
    
21. Click Next.
22. Make sure the Connect to the New Database check box is deselected.
23. Click Finish.
    
    A message box is displayed to tell you the database is being created.

Copyright (C) 2006. Sybase Inc. All rights reserved.