My Oracle Support Banner

When Applying 22.12 Monthly Update on Top of 22.3, With PostInstallDBSetup Executed in Defer Mode, Generate_schema.ddl Does Not Comply With DB2 z/OS UTS Syntax (Doc ID 2960322.1)

Last updated on NOVEMBER 11, 2023

Applies to:

Siebel CRM - Version 22.12 and later
Information in this document applies to any platform.

Symptoms

When applying 22.12 Monthly Update on top of 22.3, with PostInstallDBSetup executed in defer mode, generate_schema.ddl does not comply with DB2 z/OS UTS syntax, no more than one table should be defined by UTS tablespace.

As per the Bug 34181957 resolution, this behavior was supposed to be fixed with 22.9 onwards.

STEPS

1. Apply 22.12 monthly update on top of 22.3 installation and have PostInstallDBSetup executed in 'Defer Mode'
2. Verify the generate_schema.ddl
3. The syntax used is not DB2 z/OS UTS compliant

Changes

22.12 Monthly Update installation 

Cause

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
Symptoms
Changes
Cause
Solution
References


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