Siebel Database Upgrade Guide for DB2 UDB for z/OS > Siebel Upgrade Files >
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 34 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 34. PRET Processing Members Created By the Pretedit.txt File
|
|
|
PRETLDIN |
S_DOCK_TXN_LOG |
All and SG704 |
PRETLDIN |
S_ESCL_REQ |
All and SG704 |
PRETLDIN |
S_SRM_REQUEST |
SIA621, SIS63, SG704 |
PRETCLBF |
SQL/CLOB list, used by SBLCLOBU |
All |
PRETKEYS |
SQL/Clustering Index Key structures |
All |
|