The DB2 data administrator should complete the following procedure after installing the DB2 UDB Options for CICS and IMS.
To authorize and verify installation
Everyone who uses the DB2 UDB Options for CICS and IMS to access DB2 UDB must be authorized to execute the DB2 application plan on each DB2 UDB system. This is the application plan created that contains all of the DB2 UDB application packages. Privileges can be granted to all users or only to specific DB2 UDB users. To issue the GRANT statement, use either of these forms:
For CICS:
GRANT EXECUTE ON PLAN AMD2PLAN TO userid GRANT EXECUTE ON PLAN AMD2PLAN TO PUBLIC
If the plan name has been changed during installation, change the plan name to the new name here.
For IMS:
GRANT EXECUTE ON PLAN SYRTIMS,SYBTEXT,SYCAIPGM TO userid GRANT EXECUTE ON PLAN SYRTIMS,SYBTEXT,SYCAIPGM TO PUBLIC
Users must have EXECUTE privileges granted on the packages created on each DB2 system. Use either of these forms:
GRANT EXECUTE ON PACKAGE AMD2PKG.* TO userid GRANT EXECUTE ON PACKAGE AMD2PKG.* TO PUBLIC
To use the CSPs, users must be authorized to select from the following tables on each DB2 UDB system:
SYSIBM.SYSCOLAUTH
SYSIBM.SYSCOLUMNS
SYSIBM.SYSDATABASE
SYSIBM.FOREIGNKEYS
SYSIBM.SYSINDEXES
SYSIBM.SYSKEYS
SYSIBM.SYSRELS
SYSIBM.SYSSYNONYMS
SYSIBM.SYSTABAUTH
SYSIBM.SYSTABLES
Some front-end applications access these system tables directly. See the application documentation for these applications for more information. Also, any users accessing DB2 objects must be granted the appropriate authorizations on those objects.
(For CICS only) Before configuring the DB2 UDB Options for CICS, you should verify that the link between the DB2 UDB Options for CICS and DB2 UDB is functioning correctly. To do this, sign on to CICS, clear the screen, and enter this command:
AMD2
A message similar to this displays:
MainframeConnect DB2 UDB Option for CICS/15.0.0/P/IBM Z/150-011 DB2 test successful
If the UDB DB2 Options for CICS and IMS cannot access DB2, a message with the DB2 SQLCODE appears, for example:
MainframeConnect DB2 UDB Option for CICS/12.6.0.0/P/IBM Z/126-011 DB2 Error was detected the SQL code is –805
See the IBM DB2 UDB manuals for an explanation of the SQL codes.
