SET Db2UTSDDL

Syntax

SET Db2UTSDDL;

Description

Specifies the Data Mover to write CREATE TABLESPACE (UTS) DDL to the script identified by OutputDb2UTSDDL.

SET NO RECORD and SET NO INDEX continues to work as expected.

Note:

The DDL scripts will only be generated for PeopleSoft Db2 databases for which Universal Tablespace support has been enabled.

Example

The following is the sample Data Mover scripts for OutputDb2DBDDL, OutputDb2UTSDDL, Db2DBDDL, and Db2UTSDDL.

Note:

SET ENABLE DB2UTS and SET EXTRACT DDL statements are prerequisites to generate Db2 database and UTS DDLs using SET Db2DBDDL and SET Db2UTSDDL statements respectively.

SET LOG c:\temp\ptengs1.log;
 SET INPUT C:\PT860P02B_2211160502-retail\DATA\ptengs.db;
 SET OutputDb2DBDDL C:\temp\DB_DDL_only.txt;
 SET OutputDb2UTSDDL C:\temp\UTS_DDL_only.txt;
 SET OUTPUT C:\temp\table_and_indexDDL.txt;
 SET EXECUTE_SQL SET CURRENT SQLID = 'Q8602D7P';
 ....etc....
 REM uncomment the following line to enable UTS ;
 SET ENABLE_DB2UTS;
 SET Db2DBDDL;
 SET Db2UTSDDL;
 ....etc....
 SET EXTRACT DDL;
 IMPORT *;