System and method for using generic utilities to perform database utilities on mainframe operated DB2 databases
AssigneeEmbarq Holdings Company, LLC
InventorDavid Meinsen
Life of this patent
Estimating the term…
Abstract
A system and method for performing database utilities on a DB2 database may include using a single procedure (proc) for each database utility function. At least one parameter may be provided, where the at least one parameter identifies a DB2 database name. A generic control card may be accessed, where the generic control card may be identified by a value of the parameter(s). A utility control card may be generated using the at least one parameter. A database utility may be executed on a DB2 database by using the generated utility control card.
Claims11
A method for performing database utility functions on a DB2 database, said method comprising:
- using a single procedure (proc) for performing a database utility function;
- calling the single procedure for performing the database utility function using an EXEC STATEMENT;
- wherein the EXEC STATEMENT includes at least one parameter including a database name parameter and an optional tablespace name parameter, wherein if the optional tablespace name parameter is not specified in the EXEC STAEMENT, then all tablespaces in a database specified by the database name parameter are processed;
- accessing a generic control card stored in a software library containing a plurality of generic control cards, the generic control card being identified by a value of the at least one parameter;
- generating a utility control card using the at least one parameter and generic control card;
- and
- executing a database utility on a DB2 database by using the generated utility control card.
A system for performing database utility functions on a DB2 database, said system comprising:
- a mainframe computer, including:
- at least one storage unit;
- at least one database stored on said at least one storage unit;
- a software library stored on said at least one storage unit;
- a processing unit configured to:
- use a single procedure (proc) for performing a database utility function;
- call the single procedure for the database utility function using an EXEC STATEMENT;
- wherein the EXEC STATEMENT includes at least one parameter, the at least one parameter including a database name parameter and an optional tablespace name parameter, wherein if the optional tablespace name parameter is not specified in the EXEC STATEMENT then all tablespaces in a database specified by the database name parameter are processed;
- retrieve a generic control card identified by a value of the at least one parameter, the generic control card being retrieved from said software library containing a plurality of generic control cards;
- create a utility control card using the generic control card and the at least one parameter;
- and
- execute a database utility by using the utility control card to perform a database utility function on a DB2 database identified by the DB2 database name.
Dependencies are inferred from the claim text.