System and method for increasing system resource availability in database management systems
First Claim
1. For a database server, a computer program product for directing the database server to selectively release database system resources associated with a database system operatively coupled with the database server, the database server accessible by applications, the computer program product comprising:
- a computer usable medium having computer readable program code means embodied in said medium, the computer readable program code means comprising;
computer readable program code means for receiving requests from one or more applications, computer readable program code means for determining whether a specified application is submitting requests using an online protocol, and computer readable program code means for returning defined error condition indicators to the specified application when the application is determined to be using the online protocol and when identified system resources are determined to be scarce, whereby the specified application issues a commit when it is using the online protocol and one of the defined error condition indicators is returned to the application.
3 Assignments
0 Petitions
Accused Products
Abstract
A transactional database server is accessible by applications. Applications indicate whether access is made using an online protocol. Where the database server determines that a request received from an application is made using the online protocol, the server will return one of a set of defined error codes upon identified system resources being determined to be scarce. Applications monitor responses from the database server for the defined error codes. On receipt of one of the defined error codes an application will issue a commit to the database server to attempt to release system resources for use by applications.
35 Citations
10 Claims
-
1. For a database server, a computer program product for directing the database server to selectively release database system resources associated with a database system operatively coupled with the database server, the database server accessible by applications, the computer program product comprising:
-
a computer usable medium having computer readable program code means embodied in said medium, the computer readable program code means comprising;
computer readable program code means for receiving requests from one or more applications, computer readable program code means for determining whether a specified application is submitting requests using an online protocol, and computer readable program code means for returning defined error condition indicators to the specified application when the application is determined to be using the online protocol and when identified system resources are determined to be scarce, whereby the specified application issues a commit when it is using the online protocol and one of the defined error condition indicators is returned to the application. - View Dependent Claims (2, 3, 4)
-
-
5. A computer-implemented method for directing a database server to selectively release database system resources associated with a database system operatively coupled with the database server, the database server accessible by applications, the method comprising the steps of:
-
receiving an online protocol indicator from an application;
returning a defined error condition indicator to the application when the application has forwarded the online protocol indicator and when identified system resources are determined to be scarce, and receiving a commit statement from the application when a response from the database server is determined to comprise the defined error condition indicator. - View Dependent Claims (6, 7)
-
-
8. A computer program product for directing an application to access a database server, the database server adapted to selectively release database system resources associated with a database system operatively coupled with the database server, the database server accessible by applications, the computer program product comprising:
a computer usable medium having computer readable program code means embodied in said medium, the computer readable program code comprising;
computer readable program code means for submitting requests to the database server, computer readable program code means for indicating that requests are submitted using an online protocol, computer readable program code means for monitoring responses from the database server for defined error condition indicators, when requests have been submitted using the online protocol, and computer readable program code means for issuing a commit statement to the database server when a response from the server is determined to be a defined error condition indicator. - View Dependent Claims (9, 10)
Specification