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: 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: Systems and methods for comparing one database structure to another to identify differences between the two. In one embodiment, tree structures corresponding to each database are generated. The tree structures have nodes corresponding to objects in the databases. Each node has an individual check value based on the node attributes and a cumulative check value based on the attributes of the node and its sub-nodes. Beginning with the uppermost nodes of each tree, the check values are compared to identify differences in the check values, hence the node/tree attributes. If the cumulative check values match, the sub-nodes match and do not need to be compared directly. Only the portions of the tree structures that do not have matching check values are traversed. If individual check values do not match, the attributes of the corresponding nodes are compared to determine the exact differences.

Abstract: Techniques to repair overflow rows in a relational database table are described. In one implementation, a source table's physical memory pages are interrogated to identify overflow rows. In another implementation, overflow rows generated during database update operations are identified from non-table sources (e.g., log files). In general, overflow rows are repaired by: unloading one or more rows identified as overflow rows; locking the source table from outside access; disabling or deleting any associations associated with the unloaded rows; deleting the identified overflow/unloaded rows from the source table; reloading the previously unloaded rows back into the source table; restoring any associations previously disabled/deleted; and unlocking the tables. Rows may be processed in groups small enough not to significantly impact users accessing either the source or associated tables.

Abstract: An improved method and system for comparing database data. Data comparison may be performed either within a database or between two databases. Sets of cyclical redundancy check values may be created, at various points in time. Corresponding cyclical redundancy check values may be compared with each other to determine if the underlying data is different; differences may be displayed. Each cyclical redundancy check value may correspond to a user-determined amount of data within the database. The user-determined amount of data may be: (1) user-specified columns within one of the plurality of tables within the database; (2) a row within one of the plurality of tables within the database; (3) a table within the database; (4) the database in its entirety; or (5) any other subset of the database. A user-determined number of bytes corresponding to a user-determined subset of the user-determined amount of data may be stored for future use.

Abstract: An improved method and system for comparing database data. Data comparison may be performed either within a database or between two databases. Sets of cyclical redundancy check values may be created, at various points in time. Corresponding cyclical redundancy check values may be compared with each other to determine if the underlying data is different; differences may be displayed. Each cyclical redundancy check value may correspond to a user-determined amount of data within the database. The user-determined amount of data may be: (1) user-specified columns within one of the plurality of tables within the database; (2) a row within one of the plurality of tables within the database; (3) a table within the database; (4) the database in its entirety; or (5) any other subset of the database. A user-determined number of bytes corresponding to a user-determined subset of the user-determined amount of data may be stored for future use.