HP 3000 Manuals

IMAGE/SQL Administration Guide

Executing SQLINSTL and ODBCVIEW 

If you are on a version of ALLBASE/SQL older than the G.2 version, you
must execute the SQLINSTL.PUB.SYS and ODBCVIEW.PUB.SYS files for each of
the existing DBEnvironments.

Read the SQLINSTL.PUB.SYS file on your system for precautionary measures
before executing it.  See the ALLBASE/SQL Database Administration Guide 
or the System Software Maintenance Manual for more information on using
SQLINSTL.

To install views required by the ODBC client-server interface, execute
ODBCVIEW.PUB.SYS file for each existing DBEnvironment.  For example:
_____________________________________
|                                   |
|     :ISQL                         |
|     isql=> connect to 'testdbe';  |
|     isql=> start odbcview.pub.sys;|
|                        ...        |
|     isql=> commit work;           |
|     isql=> connect to 'rtdbe';    |
|     isql=> start odbcview.pub.sys;|
|     isql=> commit work;           |
|     isql=> exit;                  |
_____________________________________

            

You may see errors if you are executing this file for the DBEnvironment
for the first time.  These errors may be ignored.  You can execute this
command for all DBEnvironments in one session.

The B-Tree indices can be observed in the existing views, SYSTEM.INDEX by
the DBA and CATALOG.INDEX by others.  However, four new views have been
added to the SQL system catalog to enable the DBA and other users to view
TurboIMAGE/XL indices (key items and search items) as well as TPIs made
aware to the SQL Optimizer.  The Optimizer determines the most efficient
path to the desired data, such as the type of scan to use and the proper
order of operations.  The DBA should periodically issue an UPDATE
STATISTICS command on each TurboIMAGE/XL data set to refresh the
statistics which are used by the Optimizer to derive an access plan.
After all statistics have been updated, the DBA should issue VALIDATE
commands to revalidate any stored sections that may exist on the data
sets.
___________________________________________________________
|                                                         |
|      isql=> update statistics for table music.albums;   |
|      isql=> update statistics for table music.composers;|
|      isql=> validate all modules with autocommit;       |
|      isql=> validate all procedures with autocommit;    |
___________________________________________________________

            

For more information, see the "Maintenance" chapter of the ALLBASE/SQL 
Database Administration Guide.

MPE/iX 5.5 Documentation