CA RC/MigratorCA Endevor SCM InterfaceDB2 AdministrationCA RC Compare for DB2 for z/OSCA RC Extract for DB2 for z/OSCA RC/QueryCA RC Secure for DB2 for z/OSCA RC Update for DB2 for z/OS
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 I generate DDL using the HDDL command the objects that are Auxilliary LOB tablespaces , Tables and Indexes are generated as '--' comments? Why does this happen?
DB2 for Z/OS
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;