Chapter 3 Setting up the Database Server

Database creation procedure

The following procedure explains how to create a database on 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 SCJVIEW.EXE in the Sybase Central directory.
   
   The Sybase Central 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 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 in the Create a Database dialog box.
   
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 the 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 checkbox 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.