search cancel

RCQ : HDDL command returns DDL for multiple data bases when one database was specified

book

Article ID: 214634

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

 In RC/Query, issuing 'HDDL' on a Database is generating DDL for many other databases in addition to the one the command was on, why?

Environment

Release : 20.0

Component : CA RC/Query for DB2 for z/OS

Resolution

HDDL will build hierarchical DDL, the DB2 catalog is queried and all the necessary parent/child object dependencies are maintained.  If executed this will create the full set on the target environment with all the dependencies.

If there is a View with tables that cross databases, then the other Databases, Tablespaces, Tables, Indexes  etc,  will also be included.  The DDL that is generated by HDDL command is meant to create all the objects successfully and include related objects.

If it is known what object is causing all the related objects to be included, place an 'N' by the object type.  That will limit what is returned from the HDDL, however the object type that was not included will need to be generated another way so the parent objects are not missing dependents.