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 “Checklist for Setting Up the IMAGE/SQL Environment”, Table 2-2 “Checklist for Maintaining the IMAGE/SQL Environment”, and Table 2-3 “Checklist for Restructuring in the IMAGE/SQL Environment” 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. The tables indicate whether each task is optional (Opt) or required (Req). 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

Opt/Req	Task#	Task Description	Notes
Opt	1	Configuring a DBEnvironment.	Perform to create a DBE—if the DBE created by IMAGESQL using the defaults is not suitable for relational access.
Req	2	Attaching a TurboIMAGE/XL database.	Perform to establish the connection between 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 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 so that you can use the split column names in SQL statements.

Table 2-2 Checklist for Maintaining the IMAGE/SQL Environment

Opt/Req	Task#	Task Description	Notes
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 so that you can use the split column names in SQL statements.
Opt	6	Updating information about users.	Perform to update a user's class, password, 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

Opt/Req	Task#	Task Description	Notes
Req	9	Detaching a TurboIMAGE/XL database.	Perform before restructuring the TurboIMAGE/XL database, except when changing the capacity of the database.
Req	NA	Restructuring the TurboIMAGE/XL database. (Some restructuring may necessitate first performing a DETACH from the DBEs.)	Refer to the TurboIMAGE/XL Database Management System Reference Manual for information about performing restructuring tasks.
Req	2 - 5	Restoring the IMAGE/SQL environment; includes all setup tasks originally performed.	Perform to reattach the database, to add back users, and to redo any customized mapping.

Administering IMAGE/SQL:An Overview

Technical documentation

» Table of Contents

» Glossary

» Index

Setting Up the IMAGE/SQL Environment

Maintaining the IMAGE/SQL Environment