Upgrade Guide for DB2 UDB for z/OS > Production Upgrade Files Generated by the Upgrade Wizard >

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

Table 58 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.

Table 58. PRET Processing Members Created By the Pretedit.txt File
PDS Member Name
PRET Object Affected
SIA Paths

PRETLDIN

S_DOCK_TXN_LOG

All

PRETLDIN

S_ESCL_REQ

All

PRETLDIN

S_SRM_REQUEST

SIA621, SIS63

PRETCLBF

SQL/CLOB list, used by SBLCLOBU

All

PRETKEYS

SQL/Clustering Index Key structures

All

Upgrade Guide for DB2 UDB for z/OS