HP 3000 Manuals HP 3000 Manuals
Administering IMAGE/SQL:An Overview
As an administrator, you are responsible for the IMAGE/SQL environment.
This chapter shows how to use IMAGE/SQL commands to perform tasks
necessary for setting up and maintaining this environment.
Setting Up the IMAGE/SQL Environment
The initial IMAGE/SQL setup involves the following steps:
* Establishing the connection between the DBEnvironment and the
TurboIMAGE/XL database.
* Adding users.
* Customizing the default mapping to meet your needs.
Maintaining the IMAGE/SQL Environment
Once the IMAGE/SQL environment is set up, nothing else is necessary until
one of the following occurs:
* The needs of the IMAGE/SQL environment change.
* The TurboIMAGE/XL database requires restructuring.
* The log file becomes full.
For your convenience, Table 2-1 , Table 2-2 , and Table 2-3 on
the next page are checklists for you to use as you set up and maintain
IMAGE/SQL. Each checklist contains an ordered list of tasks with space to
check off each task as it is completed.[REV BEG] The tables indicate
whether each task is optional (Opt) or required (Req).[REV END] You may
want to make a photocopy of these tables so you can refer to them as you
perform the tasks.
Table 2-1. Checklist for Setting Up the IMAGE/SQL Environment
----------------------------------------------------------------------------------------------------
| | | | | |
| x | Opt/ | Task# | Task | Notes[REV BEG] |
| | Req | | Description | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 1 | Configuring a | Perform to create a DBE--if the DBE created |
| | | | DBEnvironment. | by IMAGESQL using the defaults is not |
| | | | | suitable for relational access. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | 2 | Attaching a TurboIMAGE/XL | Perform to establish the connection between |
| | | | database. | the DBE and the TurboIMAGE/XL database for |
| | | | | relational access. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 3 | Adding users. | Perform to add users in addition to the DBC. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 4 | Updating data type | Perform to select alternative data type |
| | | | mapping. | mapping. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 5 | Splitting mapped columns. | Perform to divide a mapped column into two |
| | | | | or more mapped columns so that you can use |
| | | | | the split column names in SQL |
| | | | | statements.[REV END] |
| | | | | |
----------------------------------------------------------------------------------------------------
Table 2-2. Checklist for Maintaining the IMAGE/SQL Environment
----------------------------------------------------------------------------------------------------
| | | | | |
| x | Opt/ | Task# | Task | Notes |
| | Req | | Description | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 4 | Updating data type | Perform to select alternative data type |
| | | | mapping. | mapping.[REV BEG] |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 5 | Splitting mapped columns. | Perform to divide a mapped column into two |
| | | | | or more mapped columns so that you can use |
| | | | | the split column names in SQL |
| | | | | statements.[REV END] |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 6 | Updating information | Perform to update a user's class, password, |
| | | | about users. | or access mode. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 7 | Deleting users. | Perform to delete an IMAGE/SQL user's access |
| | | | | to the TurboIMAGE/XL database. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 8 | Creating new log files. | Add log files when you need more log file |
| | | | | space. |
| | | | | |
----------------------------------------------------------------------------------------------------
Table 2-3. Checklist for Restructuring in the IMAGE/SQL Environment
----------------------------------------------------------------------------------------------------
| | | | | |
| x | Opt/ | Task# | Task | Notes[REV BEG] |
| | Req | | Description | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | 9 | Detaching a TurboIMAGE/XL | Perform before restructuring the |
| | | | database. | TurboIMAGE/XL database, except when changing |
| | | | | the capacity of the database. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | NA | Restructuring the | Refer to the TurboIMAGE/XL Database |
| | | | TurboIMAGE/XL database. | Management System Reference Manual for |
| | | | (Some restructuring may | information about performing restructuring |
| | | | necessitate first | tasks.[REV END] |
| | | | performing a DETACH from | |
| | | | the DBEs.) | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | 2 - 5 | Restoring the IMAGE/SQL | Perform to reattach the database, to add |
| | | | environment; includes all | back users, and to redo any customized |
| | | | setup tasks originally | mapping. |
| | | | performed. | |
| | | | | |
----------------------------------------------------------------------------------------------------