BMC Software, Inc., Confidential and Proprietary Information
3-12 Administrative Products for DB2 Installation Guide
Interacting with Other BMC Software Products
Pointing the SQL Explorer Synonyms to the DASD MANAGER PLUS Tables
Table 3-5 shows the SQL Explorer synonyms that are used to access the
DASD MANAGER PLUS tables in the Migrate Statistics function when
BMCSTATS is the source of the data. You must not change the synonym
names. The default naming standard for the tables assumes that yy is the
version and release number of the DASD MANAGER PLUS product. These
table names are the default names as shipped and may have changed when
DASD MANAGER PLUS was installed.
Examine these synonyms and verify that the table names are correct. If your
current SQL Explorer synonyms do not point to the correct DASD
MANAGER PLUS tables, complete the following steps to point the
synonyms to the correct tables:
1. Drop the seven SQL Explorer synonyms.
2. Recreate new SQL Explorer synonyms by using the same synonym
names, but pointing to the correct DASD MANAGER PLUS table
names. The synonym qualifier must be the same one that was used to
perform the BINDS for the SQL Explorer installation.
The HLQ.INSTALL member DCI#PSSD provides examples of a worklist.
Table 3-5 SQL Explorer Synonyms
Synonym DASD MANAGER PLUS Table
BMCPSS_SCOLDIST BMCASU
yy
.V
yy
_RS_COLDIST
BMCPSS_SCOLDISTSTA BMCASU
yy
.V
yy
_RS_COLDISTSTAT
BMCPSS_SCOLSTATS BMCASU
yy
.V
yy
_RS_COLSTATS
BMCPSS_SCOLUMNS BMCASU
yy
.V
yy
_RS_COLUMNS
BMCPSS_SINDEXES BMCASU
yy
.V
yy
_RS_INDEXES
BMCPSS_STABLES BMCASU
yy
.V
yy
_RS_TABLES
BMCPSS_STABLESPACE BMCASU
yy
.V
yy
_RS_TABLESPACE
