Siebel Database Upgrade Guide for DB2 for z/OS > Upgrade Files for Siebel Business Applications Version 8.1 >

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.

Table 21 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 21. PRET Processing Members Created By the Pretedit.txt File
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

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