When I try copying procedures from one DB2 ssid to another I get -904 and 00D31057. Why?

book

Article ID: 53103

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle CA Database Analyzer (IMS Tools) CA Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC CA Compress Data Compression (IMS Tools) CA Database Analyzer for IMS for z/OS CA Database Copier for IMS for z/OS CA Database Organizer for IMS for z/OS CA Mainframe Extended Terminal Manager (IMS Tools) CA High Performance Recovery for IMS for z/OS CA Database Organizer (IMS Tools) CA Mainframe Program Restart Manager for IMS for z/OS CA Secondary Index Builder for IMS for z/OS CA Secondary Index for IMS for z/OS

Issue/Introduction

Description:

I am trying to use PDA to copy procedures from one DB2 ssid to another using DRDA but this is not working. The tables of the Communications DB seem to be fine and these links are used elsewhere with no problems.

Solution:

DRDA is used via the definitions held in SYSIBM.LOCATIONS and corresponding entries in SYSIBM.LUNAMES and/or SYSIBM.IPNAMES.

If the LINKNAME in LOCATIONS is matched with an entry in IPNAMES then TCP/IP is used for the DRDA connection.

If the LINKNAME is LOCATIONS is matched with an entry in LUNAMES then SNA is used for the DRDA connection.

IF the LINKNAME in LOCATIONS is matched with an entry in both IPNAMES and LUNAMES then TCP/IP is used.

TCP/IP can only be used for Plans/Packages bound with DBPROTOCOL(DRDA).

SNA can only be used for Plans/Packages bound with DBPROTOCOL(PRIVATE).

Up to and including R11 of PDA, plans should be bound with DBPROTOCOL(PRIVATE) - this requires SNA. As of R11.5 release and later there is now support for DBPROTOCOL(DRDA)

So please check to see what DBPROTOCOL value has been used in the binds for your plans/packages for PDA. (Plan names are listed in your highlvl.PARMLIB(PLANS00) member)

Then check to see that you have IPNAMES or LUNAMES correctly defined based on the DBPROTOCOL value used.

Environment

Release:
Component: DBA