Batch Db2 catalog extraction program report
The report that the batch Db2® catalog extraction program produces begins with a header and the IBM® copyright statement. The copyright statement is followed by a line that indicates the version of Db2 startup parameters that are used when the extraction program is processing statements from the input stream.
The report contains four parts:
- Header and IBM copyright statement
- Db2 system ID and version, followed by a summary of the parameters
- A summary of object extract requests and related messages
- A count of the number of catalog records written
The following figure shows sample output.
>-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info 2006-06-09 18:57
-----------------------------------------------------------------------------------------------------
Database 2 Administration Tool
5697-L90 (C) Copyright IBM Corporation 1998, 2006.
All rights reserved. Licensed materials - property of IBM.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP schedule contract with IBM Corp.
-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info 2006-06-09 18:57
-----------------------------------------------------------------------------------------------------
Input prepared by Sqlid VNDR230 on DSN8 (DB2 version 810) for use on DB2 version 810 system
Object definitions extracted from DSN8 (DB2 version 810)
Parameters for this run :
Create Database(s) : No Create Tablespace(s) : Yes Create Table(s) : Yes
Create View(s) : Yes Create Index(es) : Yes Create Synonym(s) : Yes
Create Alias(es) : Yes Create Label(s) : Yes Create Comment(s) : Yes
Create Triggers : Yes Create Foreign key(s) : Yes also for refs not gen'd : Yes
Create User def. Types : No Create Functions : No Create Stored Procedures: No
Create Sequences : No
Copy Stogroup Grant(s) : Yes
Copy Database Grant(s) : Yes Copy Tablespace Grant(s): Yes Copy Table Grant(s) : Yes
Copy View Grant(s) : Yes Copy authorisations on referenced schema(s) : No
Copy U.def type Grant(s): No Copy Function Grant(s) : No Copy Procedure Grant(s) : No
Copy Sequence Grant(s) : No
Insert COMMIT statement after every definition
RE will generate all parameters even if they take default values
-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info TABLESPACE TTT8S81D FROM CAT 2006-06-09 18:57
-----------------------------------------------------------------------------------------------------
Generating DDL for Tablespace DSN8S81D In Database TTT8D81A
-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info TABLESPACE TTT8S81D FROM CAT 2006-06-09 18:57
-----------------------------------------------------------------------------------------------------
ADB2GEN - Summary of catalog records written
Number of catalog records written : 118
ADB2GEN - Ended normally
ADB2GEN gets the DECIMAL=COMMA/PERIOD (and other Db2 parameters) from a DSNHDECP module which ADB2GEN looks for in the STEPLIB data sets. The values that ADB2GEN finds in this module might not match what Db2 is currently using, or match the values that were used to store data in catalog rows; if the modules don't match, ADB2GEN might produce incorrect DDL.
You can determine the DSNHDECP parameters that ADB2GEN is using by referring to the DSNHDECP parameter section of the ADB2GEN output listing. An example is highlighted in the following figure.
>-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info 2006-11-29 13:50
-----------------------------------------------------------------------------------------------------
Database 2 Administration Tool
5697-L90 (C) Copyright IBM Corporation 1998, 2006.
All rights reserved. Licensed materials - property of IBM.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP schedule contract with IBM Corp.
-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info 2006-11-29 13:50
-----------------------------------------------------------------------------------------------------
Input prepared by Sqlid SINNOTT on DB8A (DB2 version 810) for use on DB2 version 810 system
Object definitions extracted from DB8A (DB2 version 810)
DB2 DSNHDECP values for this run : DB2 Version, Release and Mod Level : 810 Default CCSID for EBCDIC SBCS : 00037 Decimal point option : '.' Default CCSID for EBCDIC Mixed : 00002 Subsystem ID : DB8A Default CCSID for EBCDIC DBCS : 00002 Graphic for DBCS data : No Default CCSID for ASCII SBCS : 00437 Date format : ISO Default CCSID for ASCII Mixed : 00002 Time format : ISO Default CCSID for ASCII DBCS : 00002 Default encoding scheme : EBCDIC Default CCSID for UNICODE SBCS : 00367 DB2 Version 8 New Function Mode : Yes Default CCSID for UNICODE Mixed : 01208 Default CCSID for UNICODE DBCS : 01200
Parameters for this run :
Create Database(s) : Yes Create Tablespace(s) : Yes Create Table(s) : Yes
Create View(s) : Yes Create Index(es) : No Create Synonym(s) : No
Create Alias(es) : No Create Label(s) : No Create Comment(s) : No
Create Triggers : No Create Foreign key(s) : No also for refs not gen'd : No
Create User def. Types : No Create Functions : No Create Stored Procedures: No
Create Sequences : No
Copy Stogroup Grant(s) : Yes
Copy Database Grant(s) : Yes Copy Tablespace Grant(s): Yes Copy Table Grant(s) : No
Copy View Grant(s) : No Copy authorisations on referenced schema(s) : No
Copy U.def type Grant(s): No Copy Function Grant(s) : No Copy Procedure Grant(s) : No
Copy Sequence Grant(s) : No
Insert COMMIT statement after every definition
RE will generate all parameters even if they take default values
-----------------------------------------------------------------------------------------------------
ADB2GEN - Create DDL from catalog info 2006-11-29 13:50
-----------------------------------------------------------------------------------------------------