SYSTEMS AND METHODS FOR REMOTE ACCESS TO DB2 DATABASES

摘要

Systems and methods are provided that allow client programs using APIs for accessing local DB2 databases to access DB2 systems on remote logical partitions and remote zSeries mainframes rather than from a local DB2 system. For example, a method may include intercepting a DB2 request using a documented API for accessing local DB2 databases from a client program executing on a source mainframe system. The method may also include selecting a destination mainframe system and sending a buffer including information from the request from the source mainframe system to the destination mainframe system and establishing, at the destination mainframe system, a DB2 connection with the DB2 system from the request. The method may further include receiving a response from the DB2 system, sending a buffer having information from the response from the destination mainframe system to the source mainframe system, and providing the information to the client program.

主权项

1. A mainframe computing system comprising:
at least one general processor; a client program executing on the mainframe computing system, the client program configured to make a DB2 request using a documented application program interface (API) for accessing local DB2 databases; and a redirect subsystem configured to perform operations comprising:
intercepting the DB2 request,normalizing the DB2 request,selecting a destination mainframe computing system to respond to the request, the selection being based on a map that associates remote DB2 systems with corresponding mainframe computing systems,scheduling a communication request directed to the destination mainframe computing system, the request including the normalized DB2 request,receiving a normalized response from the destination mainframe computing system,converting the normalized response into a format appropriate for the documented API, andproviding the converted response to the client program.