Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: In one aspect, a computer-implemented method provides more efficient outages for databases. The method may include intercepting a database transaction request prior to connection to the database subsystem and determining whether the transaction will finish before an expected drain time for the database object, the transaction being associated with the database object. The method may also include allowing the transaction to proceed when it is determined that the transaction will finish before the expected drain time and suspending the transaction otherwise. The transaction may be associated with the database object in a table so that only transactions associated with the database object are considered for suspension. In another aspect, the method may include determining which transactions running when a drain for the object is initiated and associating the running transactions with the database object in the table.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Methods and systems for providing access to spaces in a database during a recovery process affecting the database. Spaces in the database that are affected by the recovery process are identified and I/O requests sent to a media manager associated with the database are intercepted. If the I/O request is for a read operation to a space affected by the recovery process and the corresponding page has been recovered, the data in the page may be read. If the page has not been recovered, the read operation may be held in a cache until the recovery utility indicates that the page has been recovered. If the I/O request is for a write operation to a space affected by the recovery process, the data may be written to a cache.

Abstract: Techniques to provide run-time access to a database image through a target database management system (DBMS) are described. An empty database in the target DBMS (the “target database”) is created having substantially the same schema as the database image. At run-time, queries directed to the target database are intercepted and redirected to the database image. Information returned in response to the redirected query is modified so that internal database identifiers retrieved from the database image are replaced with like database identifiers associated with the target database management system. Thus, run-time access to database image content is provided without the need to load the database image's data content into a target database.

Abstract: Techniques to provide run-time access to a database image through a target database management system (DBMS) are described. An empty database in the target DBMS (the “target database”) is created having substantially the same schema as the database image. At run-time, queries directed to the target database are intercepted and redirected to the database image. Information returned in response to the redirected query is modified so that internal database identifiers retrieved from the database image are replaced with like database identifiers associated with the target database management system. Thus, run-time access to database image content is provided without the need to load the database image's data content into a target database.