This section shows you the steps to set up the database and DBEnvironment.
Before beginning, change into the group and account where you want to create
MUSIC and MusicDBE.
For clarity, use an empty group, if possible.
This chapter uses the group PUB and the account ACCOUNT.
A script is provided with the IMAGE/SQL product
that simplifies the database creation and purging processes.
To execute the script, type:
:RUN IMSQL.SAMPLEDB.SYS Return
|
A menu like the one in Figure 6-1 “SQLSetup Menu” appears on your screen (some details may differ on your system).
Figure 6-1 SQLSetup Menu
Options for Setting Up IMAGE/SQL Sample DBEnvironments
===============================================================
Choose one:
1. Create MUSIC IMAGE database
2. Display Music schema
3. Attach Music to MusicDBE
4. Display schema for MusicDBE
5. Purge Music
6. Purge MusicDBE
7. Help
0. Exit
===============================================================
Enter your choice=>
|
The options are described in Table 6-1 “Menu Options”.
Table 6-1 Menu Options
Option | Description |
---|
1 | Creates the TurboIMAGE/XL MUSIC database in your current group and
account. |
2 | Displays the MUSIC schema. |
3 | Uses IMAGE/SQL utility to attach MUSIC to MusicDBE. |
4 | Displays catalog information about MusicDBE. |
5 | Purges MUSIC. You must be the Creator or System Manager to use
this option. |
6 | Purges MusicDBE. You must be the DBECreator or System
Manager to use this option. |
7 | Displays the current help screen. |
0 | Exists IMSQL.
|
From the above menu, select Option 1 to create the TurboIMAGE/XL MUSIC database
in your group and account.
Next, select Option 3. This will execute IMAGESQL.PUB.SYS, set the TURBODB
parameter to MUSIC, and set the SQLDBE parameter to the non-existent MusicDBE.
The DBE will be automatically created for you at this time.
This option then attaches MUSIC to MusicDBE.
When you return to the menu, select Option 0 to exit.
After completing Options 1 and 3, list the files in the current
group and account. You will find the following files in your group:
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX
MUSIC PRIV 128W FB 8 8 1 16 1 1
MUSIC01 PRIV 512W FB 250 250 1 1008 1 4
MUSIC02 PRIV 384W FB 250 250 1 752 1 4
MUSIC03 PRIV 384W FB 100 100 1 304 1 2
MUSIC04 PRIV 512W FB 250 250 1 1008 1 4
MUSIC05 PRIV 512W FB 143 143 1 576 1 3
MUSICDBE PRIV 2048W FB 3 11 1 48 1 *
MUSICDCR PRIV 2048W FB 128 131072 1 256 1 *
MUSICDFL PRIV 2048W FB 1000 1000 1 16000 1 32
MUSICDLG PRIV 256W FB 1000 1000 1 2000 1 32
MUSICTC PRIV 28W FB 1 1023 4 208 1 *
|
The files are all PRIV files, which means you cannot
purge them without special system authority.
The DBUTIL and SQLUtil utilities provide this authority.