International Business Machines Corporation

Hugh J Smith

James Willis Pickel

Margaret Ann Dong

Brian Keith Howell

Shivram Ganduri

Continuously blocking query result data for a remote query is provided. Included is: creating a first connection, using a communications network, between a database server and a client. At least one secondary connection is created, using the communications network, between the database server and the client, based on the database server supporting a continuous block fetch protocol. Using the at least one secondary connection, the database server receives at least one cursor-based fetch query. The database server generates continuous blocks of result data, based on the received at least one cursor-based fetch query and sends to the client, using the at least one secondary connection, the continuous blocks of result data.

Continuously blocking query result data for a remote query

A method and apparatus for configuring a plurality of server systems. In one implementation, the method includes configuring the plurality of server systems as a first database having a group name and a group port, and configuring a subset of the plurality of server systems as a second database having a subset name and a subset port. The first database is accessible by a client application via the group name and the group port for storage of data in the first database, and the second database is accessible by a client application via the subset name and the subset group for storage of data in the second database.

Method and apparatus for configuring a plurality of server systems into groups that are each separately accessible by client applications

A method and system of subsetting a group of server systems configures a server system with a group name and a group port, and with at least one subset name and subset port. The server system, when activated, reads its configuration and registers with a system routing entity as being part of the group name and the group port, and as being part of the subset name and the subset port. In this manner, server systems can be targeted via its subset name and subset port, while also accessible via the common name and port for the group. If the group includes a workload balancer, the server system also registers with the workload balancer using the group name and the subset name, such that workload balancing is provided for the subset.

Growing community of inventors

Santa Cruz, CA, United States of America

Hugh J Smith