Importance

Loading Importance Indicators...

Abstract

A computer-executed method permits one or more of the following three functions to be performed on a DB2 data table: (1) dynamically altering (replacing) the EDITPROC parameter in the DB2 catalog definition of the DB2 data table, without the necessity of unloading the data from the table; (2) dynamically adding an EDITPROC to an existing DB2 data table whose DB2 catalog definitional information does not include an EDITPROC parameter; and (3) dynamically adding a column (field) to an existing DB2 data table that already includes an EDITPROC. The method does not make the assumption, made by IBM's DSNUTILB utility program, that the DBD records for a given database are untrustworthy and that all definitional information therefore must be verified. The method makes use of code to trick DB2 into bringing certain definitional information for the data table in question, including the DBD and OBD records, into memory from DASD (disk) storage. The method also makes use of a swapping routine which provides a dynamic procedure for exchanging DBD and OBD information between the DB2 table to be modified and a shadow DB2 table which already contains the modified DBD and OBD information.

Loading the Abstract Image...

First Claim