Displaying Pending DDL in BMC AMI Catalog Manager for Db2

Knowledge Article

Article Number

000375837

Old Article Number

Article Type

FAQ/Procedural

Title

Displaying Pending DDL in BMC AMI Catalog Manager for Db2

Summary

Use the PDD list command to display pending DDL.

Product

BMC AMI Catalog Manager for Db2

Component

BMC AMI Catalog Manager for Db2

Applies to

BMC AMI Catalog Manager for Db2 v12.1 BMC AMI Catalog Manager for Db2 V11.2

Question

Is there a Catalog Manager list that displays Pending DDL?

Answer

The PDD list type displays Pending DDL.
The PDD line command is valid for DB, IS, IX, MQT, TB and TS list types. PDD gets information from Db2 catalog table SYSIBM.SYSPENDINGDDL

Example: Display Pending DDL for DB BMCQA1DB

Pending DDL list

Attachment(s):