My Oracle Support Banner

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:

PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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