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
PDS Member Name
PRET Object Affected
SIA Paths

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

Siebel Database Upgrade Guide for DB2 UDB for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.