Optim runs against its own synonyms for the DB2® Catalog table and the Directory tables. Use this option to create the synonyms.
When you select Option 1 on the Provide Access to Optim at Remote/Local Subsystems menu, you are given the opportunity to override the DB2 Catalog specification prior to creating the synonyms for the Directory and the DB2 Catalog. The Specify Synonyms for Catalog Access panel is shown. On this panel, you can specify the Default Creator ID for the catalog tables or views and the names of those catalog tables or views.
In the following figure, the defaults are displayed mapping the Optim synonyms to the DB2 Catalog. If you wish to run against other tables you can change the Default Creator ID and/or the catalog table names to map the synonyms to other tables or views.
Figure: Specify Synonyms for Catalog Access - Install
--------------------- Specify Synonyms for Catalog Access ------------------- Command ===> SCROLL ===> PAGE To execute Optim using the DB2 system catalog, press ENTER key To execute using alternate tables or views, change the catalog table names to the desired alternate names and press ENTER key Default Creator ID ===> SYSIBM 1 of 34 Synonym: Catalog Table: ********************************** TOP ************************************** FOP_SYSCOLUMNS ===> SYSIBM.SYSCOLUMNS FOP_SYSCOPY ===> SYSIBM.SYSCOPY FOP_SYSDATABASE ===> SYSIBM.SYSDATABASE FOP_SYSFIELDS ===> SYSIBM.SYSFIELDS FOP_SYSFOREIGNKEYS ===> SYSIBM.SYSFOREIGNKEYS FOP_SYSINDEXES ===> SYSIBM.SYSINDEXES FOP_SYSINDEXPART ===> SYSIBM.SYSINDEXPART FOP_SYSKEYS ===> SYSIBM.SYSKEYS FOP_SYSRELS ===> SYSIBM.SYSRELS FOP_SYSSTOGROUP ===> SYSIBM.SYSSTOGROUP FOP_SYSSYNONYMS ===> SYSIBM.SYSSYNONYMS FOP_SYSTABLES ===> SYSIBM.SYSTABLES FOP_SYSTABLESPACE ===> SYSIBM.SYSTABLESPACE FOP_SYSVIEWS ===> SYSIBM.SYSVIEWS FOP_SYSVIEWDEP ===> SYSIBM.SYSVIEWDEP FOP_SYSTABLEPART ===> SYSIBM.SYSTABLEPART FOP_SYSPLANDEP ===> SYSIBM.SYSPLANDEP FOP_SYSPACKDEP ===> SYSIBM.SYSPACKDEP FOP_SYSPACKAGE ===> SYSIBM.SYSPACKAGE FOP_SYSPLAN ===> SYSIBM.SYSPLAN FOP_SYSCHECKS ===> SYSIBM.SYSCHECKS FOP_LOCATIONS ===> SYSIBM.LOCATIONS FOP_SYSAUXRELS ===> SYSIBM.SYSAUXRELS FOP_SYSCHECKDEP ===> SYSIBM.SYSCHECKDEP FOP_SYSCONSTDEP ===> SYSIBM.SYSCONSTDEP FOP_SYSDATATYPES ===> SYSIBM.SYSDATATYPES FOP_SYSLOBSTATS ===> SYSIBM.SYSLOBSTATS FOP_SYSPARMS ===> SYSIBM.SYSPARMS FOP_SYSROUTINES ===> SYSIBM.SYSROUTINES FOP_SYSTRIGGERS ===> SYSIBM.SYSTRIGGERS FOP_SYSSEQUENCES ===> SYSIBM.SYSSEQUENCES FOP_SYSSEQUENCESDP ===> SYSIBM.SYSSEQUENCESDEP FOP_SYSTABCONST ===> SYSIBM.SYSTABCONST FOP_SYSTBLSPCSTATS ===> SYSIBM.SYSTBLSPCSTATS ******************************** BOTTOM ************************************* Review SQL prior to execution ===> YES (Y-Yes, N-No)
Any existing plans that are bound with the names used for the Optim synonyms will be invalidated. Any existing synonyms that match those on this panel are dropped and new synonyms are created to satisfy this request. It is recommended that you check any names beginning with FOP_SYS since all the synonyms defined by Optim begin with this string.
If you enter Yes to the prompt Review SQL prior to execution, the SQL for synonyms that are to be dropped and created is displayed.
The Review DROP Synonym SQL to Bind Plan panel is displayed if the name of a synonym on the Specify Synonyms for Catalog Access panel matches that of an existing synonym. This condition occurs most frequently when you choose to re-specify the Catalog Access.
The Review DROP Synonym SQL to Bind Plan panel is displayed prior to the Review CREATE Synonym SQL to Bind Plan panel to warn that an existing synonym will be affected. The SQL statements for dropping and creating synonyms are executed at one time, after all specifications are complete and, if desired, reviewed.
If Review SQL prior to execution is selected the first time this mapping is executed in the initial install process, the SQL to create all synonyms is displayed. The following figure shows the default names on the Review CREATE Synonym SQL to Bind Plan panel for the initial install. Synonyms for Optim™ directory tables (ADB2AUDIT, ADDEF, CMDEF, RELDEF, TMDEF, CDDEF, MDB2PROCESS, ARCHDEF, ARCHIDX, PKDEF, LTDEF, ARCHLOG, ENVDEF, RDDEF, AFCOLLCT, CPMETER, CMPROC) are also created. The names for these tables, including the Creator ID, are as entered on the Specify Synonyms for Catalog Access panel. The default values are displayed in the following figure.
Figure: Review CREATE Synonym SQL to Bind Plan - Install
----------------- Review CREATE Synonym SQL to Bind Plan -------------------- Command ===> SCROLL ===> PAGE SQL to be executed: 1 of 47 ********************************* TOP ************************************* CREATE SYNONYM FOP_SYSCOLUMNS FOR SYSIBM.SYSCOLUMNS CREATE SYNONYM FOP_SYSCOPY FOR SYSIBM.SYSCOPY CREATE SYNONYM FOP_SYSDATABASE FOR SYSIBM.SYSDATABASE CREATE SYNONYM FOP_SYSFIELDS FOR SYSIBM.SYSFIELDS CREATE SYNONYM FOP_SYSFOREIGNKEYS FOR SYSIBM.SYSFOREIGNKEYS CREATE SYNONYM FOP_SYSINDEXES FOR SYSIBM.SYSINDEXES CREATE SYNONYM FOP_SYSINDEXPART FOR SYSIBM.SYSINDEXPART CREATE SYNONYM FOP_SYSKEYS FOR SYSIBM.SYSKEYS CREATE SYNONYM FOP_SYSRELS FOR SYSIBM.SYSRELS CREATE SYNONYM FOP_SYSSTOGROUP FOR SYSIBM.SYSSTOGROUP CREATE SYNONYM FOP_SYSSYNONYMS FOR SYSIBM.SYSSYNONYMS CREATE SYNONYM FOP_SYSTABLES FOR SYSIBM.SYSTABLES CREATE SYNONYM FOP_SYSTABLESPACE FOR SYSIBM.SYSTABLESPACE CREATE SYNONYM FOP_SYSVIEWS FOR SYSIBM.SYSVIEWS CREATE SYNONYM FOP_SYSVIEWDEP FOR SYSIBM.SYSVIEWDEP CREATE SYNONYM FOP_SYSTABLEPART FOR SYSIBM.SYSTABLEPART CREATE SYNONYM FOP_SYSPLANDEP FOR SYSIBM.SYSPLANDEP CREATE SYNONYM FOP_SYSPACKDEP FOR SYSIBM.SYSPACKDEP CREATE SYNONYM FOP_SYSPACKAGE FOR SYSIBM.SYSPACKAGE CREATE SYNONYM FOP_SYSPLAN FOR SYSIBM.SYSPLAN CREATE SYNONYM FOP_SYSCHECKS FOR SYSIBM.SYSCHECKS CREATE SYNONYM FOP_LOCATIONS FOR SYSIBM.LOCATIONS CREATE SYNONYM FOP_SYSAUXRELS FOR SYSIBM.SYSAUXRELS CREATE SYNONYM FOP_SYSCHECKDEP FOR SYSIBM.SYSCHECKDEP CREATE SYNONYM FOP_SYSCONSTDEP FOR SYSIBM.SYSCONSTDEP CREATE SYNONYM FOP_SYSDATATYPES FOR SYSIBM.SYSDATATYPES CREATE SYNONYM FOP_SYSLOBSTATS FOR SYSIBM.SYSLOBSTATS CREATE SYNONYM FOP_SYSPARMS FOR SYSIBM.SYSPARMS CREATE SYNONYM FOP_SYSROUTINES FOR SYSIBM.SYSROUTINES CREATE SYNONYM FOP_SYSTRIGGERS FOR SYSIBM.SYSTRIGGERS CREATE SYNONYM FOP_SYSTBLSPCSTATS FOR SYSFOP.SYSTBLSPCSTATS CREATE SYNONYM FOP_ADB2AUDIT FOR SYSFOP.ADB2AUDIT CREATE SYNONYM FOP_ADDEF FOR SYSFOP.ADDEF CREATE SYNONYM FOP_CMDEF FOR SYSFOP.CMDEF CREATE SYNONYM FOP_RELDEF FOR SYSFOP.RELDEF CREATE SYNONYM FOP_MDB2PROCESS FOR SYSFOP.MDB2PROCESS CREATE SYNONYM FOP_PKDEF FOR SYSFOP.PKDEF CREATE SYNONYM FOP_CDDEF FOR SYSFOP.CDDEF CREATE SYNONYM FOP_TMDEF FOR SYSFOP.TMDEF CREATE SYNONYM FOP_ARCHDEF FOR SYSFOP.ARCHDEF CREATE SYNONYM FOP_ARCHIDX FOR SYSFOP.ARCHIDX CREATE SYNONYM FOP_LTDEF FOR SYSFOP.LTDEF CREATE SYNONYM FOP_ARCLG FOR SYSFOP.ARCHLOG CREATE SYNONYM FOP_ENVDEF FOR SYSFOP.ENVDEF CREATE SYNONYM FOP_RDDEF FOR SYSFOP.RDDEF CREATE SYNONYM FOP_AFCOLLCT FOR SYSFOP.AFCOLLCT CREATE SYNONYM FOP_CPMETER FOR SYSFOP.CPMETER CREATE SYNONYM FOP_CMPROC FOR SYSFOP.CMPROC ******************************* BOTTOM ************************************ Press ENTER key to continue Press END key to respecify
Press ENTER to execute the SQL. However, if you wish to change any values, press END to redisplay the Specify Synonyms for Catalog Access panel.