HP 3000 Manuals HP 3000 Manuals
Setting Up MUSIC and MusicDBE
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 appears on your screen (some
details may differ on your system).
________________________________________________________________________
| |
| |
| 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=> |
| |
________________________________________________________________________
Figure 6-1. SQLSetup Menu
The options are described in Table 6-1 .
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.