CA RC/Query for DB2 for Z/OS : LOB Objects commented out when generated.

book

Article ID: 76429

calendar_today

Updated On:

Products

CA RC/Query for DB2 for z/OS

Issue/Introduction

The HDDL line command creates the data definition language(DDL) statements for the selected object along with its parent and dependent objects. The HDDL (hierarchical DDL) command generates DDL online and in batch,  in the proper execution order, for those objects in its hierarchy.

When DDL is generated using the HDDL command the objects that are Auxiliary LOB tablespaces , Tables and Indexes are generated as '--' comments? 

Environment

DB2 for Z/OS

Resolution

A new feature provided in R20 release with the HDDL and DDL commands now generate DDL for implicitly created objects such as databases, tablespaces, tables, and indexes as comments.  
This formatting enables the generated DDL to be executed without having to comment out the implicit object DDL manually.


For example when "SET CURRENT RULES = 'STD" (SQL standard rules)  is being used ,  DB2 is expected to generate the implicit objects for you when the DDL is executed. Having these objects generated as comments could be of use as a way of preserving the DDL as it was or to be used in another SSID where the same SQL Standard Rules are not in place.

Note: There are other situations where implicit objects are created by DB2.

Sample Output:
 SET CURRENT SQLID = 'authid';
--
--     CREATE LOB TABLESPACE TSMKHSW2
--            IN DBSSXMS
--            USING STOGROUP SYSDEFLT
--                PRIQTY -1
--                SECQTY -1
--                ERASE NO
--            BUFFERPOOL BP1
--            DSSIZE 4G
--            CLOSE YES
--            LOCKMAX SYSTEM
--            GBPCACHE CHANGED
--            DEFINE NO
--            LOGGED
--            LOCKSIZE ANY;


 SET CURRENT SQLID = 'authid';

--
--     CREATE AUXILIARY TABLE authid.XM_LELEGALQMKH7MCP
--         IN DBSSXMS.TSMKHSW2
--         STORES authid.XM_LEGAL_HISTORY
--         APPEND NO
--         COLUMN LEGAL_DATA PART 6;

Additional Information

Implicit Object DDL Now Generated as Comments

Generate Hierarchical Object DDL