|
DB2 ist ein Produkt der
IBM Corporation. Bitte Copyright- und Trademark-Hinweise beachten!
http://www-1.ibm.com/support/docview.wss?rs=865&context=SSEPEK&dc=DB510&dc=DB520&dc=D800&dc=D900&dc=DA900&dc=DA800&dc=DA440&dc=D600&dc=D700& dc=DB540&dc=DB400&dc=DA410&dc=DA450&dc=DA430&uid=swg27008509&loc=en_US&cs=UTF-8&lang=all
Determining if plans or packages have a private protocol remote location dependency Forum/discussion group
Abstract
The sample REXX program provided can analyze a DB2 subsystem catalog to see if any plans or packages that were bound with DBPROTOCOL(PRIVATE) have a remote location dependency. If they do have such a dependency, the tool generates commands to convert those plans or packages to use DRDA protocol.
Also, the programs analyze any three-part name aliases in the catalog to determine if corresponding two-part name aliases must be created at the indicated remote locations.
Content
The REXX program DSNTP2DP can be run against DB2® Version 7 or 8 subsystems. The file DSNTIJPD.JCL contains the recommended JCL to run the REXX program after the sample JCL has been modified as indicated in the comments in the file. Part of the JCL sample contains recommendations for creating indexes on the DB2 catalog to improve the performance of running DSNTP2DP.
Instructions on how to use the REXX program can be found in the comments of the program.
Example submitted by: IBM
Rate this example
Notice: This example is from the DB2 Examples Trading Post and is provided on an "as-is" basis. You can copy and modify this example in any form without payment to IBM®, for the purposes of designing and developing application programs conforming to the application programming interface for the z/OS® or OS/390® operating system for which these examples are written. This example has been tested, but it has not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of this example in your particular environment. Use this example as a model for your own situations.
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
DB2 Development
DB2 Information Management Software
© Gernot Ruban