System and method for using generic utilities to perform database utilities on mainframe operated DB2 databases

1. 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.

2. The method according to claim 1 , further comprising not generating the utili control card in response to a determination that no control card is needed for the single procedure for performing the database utility function.

3. The method according to claim 1 , further comprising including symbolics to be used for expansion in creating the utility control card.

4. The method according to claim 1 , generating the utility control card includes generating the utility control card when a job is executed.

5. The method according to claim 1 , wherein generating the utility control card causes the utility control card to be error-free.

6. 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.

7. The system according to claim 6 , further comprising not generating the utility control card in response to a determination that no control card is needed for the single procedure for performing the database utility function.

8. The system according to claim 6 , wherein said processing unit is configured to look up the generic control card in said software library using the at least one parameter.

9. The system according to claim 6 , wherein said processing unit is further configured to replace symbolics with the at least one parameter during JCL expansion.

10. The system according to Claim 6 , wherein said processing unit is configured to automatically generate the utility control card when a job is executed.

11. The system according to claim 6 , wherein said processing unit is configured to generate an error-free utility control card.