My Oracle Support Banner

PostInstallDBSetup DDLIMP Is Not Generating DB2 z/OS UTS Compatible DDL Syntax (Doc ID 2887148.1)

Last updated on SEPTEMBER 11, 2022

Applies to:

Siebel CRM - Version 22.3 to 22.8 [Release V17]
Information in this document applies to any platform.

Symptoms

When running PostInstallDBsetup as part of the 22.3 Monthly Update Installation DDLIMP utility does not generate DB2 z/OS UTS compatible DDL syntax.

See: https://www.ibm.com/docs/en/db2-for-zos/11?topic=spaces-table-space-types-characteristics-in-db2-zos

STEPS
The issue can be reproduced at will with the following steps:
1. Install 22.3 Monthly Update
2. Choose Defer-Generate DDL files only option on Post Installation Database Update Options dialog
3. Verify the generate_schema.ddl generated in the PostInstallDBSetup_YYYY-MM-DD directory located under siebsrvr/log directory
4. The generate_schema.ddl does not contain UTS compatible DDL syntax

Changes

 22.3 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.