Access operation request management

A system for managing an access operation request to a database management system (DBMS) on a shared pool of configurable computing resources having a set of members, the system comprising:

• a memory having a set of computer readable computer instructions, and a processor for executing the set of computer readable instructions, the set of computer readable instructions including:
• establishing, with respect to the DBMS on the shared pool of configurable computing resources, a map of a set of table names to the set of members, wherein a respective table name of the set of table names maps to an indicated member of the set of members;
• receiving a query which indicates the access operation request to the DBMS;
• parsing the query to identify a table name based on analyzing a syntax of the query;
• identifying the table name from within the query, based on a set of table identification criteria;
• selecting, based on comparing the table name with the map, a specific member of the set of members to process the access operation request to the DBMS;
• and
• routing, to process the access operation request to the DBMS, the access operation request to the specific member of the set of members;
• storing, in a server configuration file by a server of the shared pool of configurable computing resources, the map of the set of table names to the set of members;
• and
• updating, by the server, the server configuration file in response to activation of the DBMS.

A computer program product for access operation request management in a database management system (DBMS) on a shared pool of configurable computing resources having a set of members, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:

• establishing, with respect to the DBMS on the shared pool of configurable computing resources, a map of a set of table names to the set of members, wherein a respective table name of the set of table names maps to an indicated member of the set of members;
• receiving a query which indicates the access operation request to the DBMS;
• parsing the query to identify a table name based on analyzing a syntax of the query;
• identifying the table name from within the query, based on a set of table identification criteria;
• selecting, based on comparing the table name with the map, a specific member of the set of members to process the access operation request to the DBMS;
• and
• routing, to process the access operation request to the DBMS, the access operation request to the specific member of the set of members;
• storing, in a server configuration file by a server of the shared pool of configurable computing resources, the map of the set of table names to the set of members;
• and
• updating, by the server, the server configuration file in response to activation of the DBMS.