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.