Post-installation steps

The DB2 The DB2 data administrator should complete the following procedure after installing the DB2 UDB Option for CICS.

Authorizing and verifying

1. Everyone who uses the DB2 UDB Option for CICS to access DB2 must be authorized to execute the DB2 application plan on each DB2 system. This is the application plan created that contains all of the DB2 application packages. Privileges can be granted to all users or only to specific DB2 users. To issue the GRANT statement, use either of the following forms:

   GRANT EXECUTE ON PLAN AMD2PLAN TO userid
   GRANT EXECUTE ON PLAN AMD2PLAN TO PUBLIC
   

   If the plan name has been changed during installation, change AMD2PLAN to the new name here.

2. Users must have EXECUTE privileges granted on the packages created on each DB2 system. Use either of the following forms:

   GRANT EXECUTE ON PACKAGE AMD2PKG.* TO userid
   GRANT EXECUTE ON PACKAGE AMD2PKG.* TO PUBLIC
   

   If the collection name has been changed during installation, change AMD2PKG to the new name here.

3. To use the CSPs, users must be authorized to select from the following tables on each DB2 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.

4. Before configuring the DB2 UDB Option for CICS, you should verify that the link between the DB2 UDB Option for CICS and DB2 is functioning correctly. To do this, sign on to CICS, clear the screen, and enter the following command:

   AMD2
   

   A message similar to the following displays:

   MainframeConnect DB2 UDB Option for CICS/12.6.0.0/P/IBM Z/126-011
   DB2 test successful
   

   If the UDB DB2 Option for CICS 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 manuals for an explanation of the SQL codes.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF