E-DB2: Can PeopleTools Metadata be Modified to Force Alters to Match the DB2 System Catalog? (Doc ID 2903064.1)

Last updated on OCTOBER 15, 2022

Applies to:

Goal

Alter by Rename questions for DB2 z/OS using UTS
1. The bufferpool values in the script for the new tablespaces is BUFFERPOOL BP1 but the original values in tablespace and database definition for the tables is BUFFERPOOL BP2. We want the bufferpool definition to be BUFFERPOOL BP2
2. The script has ‘long varchar’ as a data type on some columns where the original data type was varchar
3. We have at least one table defined as nullable in the original table, but the script is defining the columns as not nullable.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.