Abstract: A system and method for processing a request utilizing a database management system in a computer system is disclosed. The database management system manages at least one database. At least one database subsystem corresponding to the database management system is available. The computer system includes a plurality of worker threads. The method and system include assigning the request to a worker thread of the plurality of worker threads. The worker thread is for aiding in execution of the request. The method and system also include providing a connection to a particular database subsystem for the worker thread and associating the connection with the worker thread if the worker thread has not previously used the particular database subsystem. The method and system further include reusing the connection to the particular database subsystem that is associated with the worker thread if the worker thread has previously used the particular database subsystem.
Type:
Grant
Filed:
June 25, 1998
Date of Patent:
August 29, 2000
Assignee:
International Business Machines Corporation
Inventors:
Melvin Richard Zimowski, Jeffrey David Aman, Steven J. Greenspan, Patrick Michael LiVecchi