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.
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 |
| | Req | | Description | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 1 | Configuring a DBEnvironment. | Perform to create a DBE if no suitable |
| | | | | DBE is available for ATTACH purposes. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | 2 | Attaching a TurboIMAGE/XL | Perform to establish the connection |
| | | | database. | between the DBE and the TurboIMAGE/XL |
| | | | | database. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 3 | Adding users. | Perform to add users in addition to the |
| | | | | DBC. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 4 | Updating data type mapping. | Perform to select alternative data type |
| | | | | mapping. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 5 | Splitting mapped columns. | Perform to divide a mapped column into |
| | | | | two or more mapped columns. |
| | | | | |
----------------------------------------------------------------------------------------------------
Table 2-2. Checklist for Maintaining the IMAGE/SQL Environment
----------------------------------------------------------------------------------------------------
| | | | | |
| x | Opt/ | Task# | Task | Notes |
| | Req | | Description | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 4 | Updating data type mapping. | Perform to select alternative data type |
| | | | | mapping. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 5 | Splitting mapped columns. | Perform to divide a mapped column into |
| | | | | two or more mapped columns. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Opt | 6 | Updating information about | Perform to update a user's password or |
| | | | users. | 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 |
| | Req | | Description | |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | 9 | Detaching a TurboIMAGE/XL | Perform before restructuring the |
| | | | database. | TurboIMAGE/XL database. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | NA | Restructuring the | Refer to the TurboIMAGE/XL Database |
| | | | TurboIMAGE/XL database. | Management System Reference Manual for |
| | | | | information about performing |
| | | | | restructuring tasks. |
| | | | | |
----------------------------------------------------------------------------------------------------
| | | | | |
| | Req | 2 - 5 | Restoring the IMAGE/SQL | Perform to reattach the database, to |
| | | | environment; includes all | add back users, and to redo any |
| | | | setup tasks originally | customized mapping. |
| | | | performed. | |
| | | | | |
----------------------------------------------------------------------------------------------------