PRET Members Generated By Pretedit.txt

The Pretedit.txt file creates the partitioned data set (PDS) on the z/OS host that is used for PRET processing. The members in this PDS perform a number of tasks, for example, listing the tables that contain CLOB columns, gathering information required for key processing, and deleting rows in specific tables. Data sets are generated for each upgrade path.

The following table shows the data set members created by the Pretedit.txt file, the objects amended by these members (the SQL statement that is run is contained in the member) and the upgrade path for which these members are generated.

PDS Member Name PRET Object Affected SIA Upgrade Paths

PRETLDIN

S_DOCK_TXN_LOG

All

PRETLDIN

S_ESCL_REQ

All

PRETCLBF

SQL/CLOB list, used by SBLCLOBU

All

PRETKEYS

SQL/Clustering Index Key structures

All