V12.2:
DB2 10 Support for:
TIMESTAMP WITH TIMEZONE Datatype.
And Timestamps with specified millisecond precision.
Changes to DB2CPI Table Editor to support Editing for large columns.
Case issue has now been resolved.
Support for XML Datatypes:
CPIDDL and all Catalog Management screens now support the XML datatype.
The DB2 generated column DB2_GENERATED_DOCID_FOR_XML is shown in the screens (Browse included) but hidden when the DDL command is issued.
Support for Instead of Triggers:
CPIDDL now generates any Instead of Triggers that are defined on Dependent views.
The TR line command has also been extended to be used against the VW (View) object types.
Support for ROW CHANGE TIMESTAMPS (Optimistic Locking):
Both CPIDDL and the catalog management screens and DDL commands have been changed to support this enhancement. Example:
,ROW_CHANGE_TS TIMESTAMP NOT NULL
GENERATED ALWAYS
FOR EACH ROW
ON UPDATE
AS ROW CHANGE TIMESTAMP
Support for SMS attributes in Storage Group Definition.
Catalog Management screens and DDL commands have been changed to support the DATACLAS, MGMTCLAS, STORCLAS parameters if they are specified as part of the togroup Definition.
Support for LOGGED and NOT LOGGED Tablespaces.
V12.1:
DB2CPI Interface Changes
Interactive Real Time Statistics support is now available in DB2CPI.
You can now view and reset real time statistics by using the RT line command.
There is also a RESTORE option to allow fallback to previous stats after a Reset.
Support for Virtual Indexes.
Virtual indexes can now be created as well as traditional indexes using the CI (Create Index) command.
Virtual Indexes are shown along with traditional indexes in the Index Display screens. They are highlighted using special characters so you can distinguish between the 2.
Virtual Indexes can also be dropped using the DR command.
See section ‘Creating a Virtual Index’ in Catalog Management.
Index on Expressions are now supported in DB2CPI.
Changes to Catalog Manager screens now display and reverse engineer Indexes defined with Espressions.
See ’Index on Expressions’ in section ‘Displaying Indexes(Catalog Management)’.
New User and Resource Level Authority Display Screen in SQL Manager.
See section ‘User and Resource Level Authority Display’ in SQL Management.
Support for new DB2 9 Datatypes:
BIGINT
DECFLOAT
BINARY
VARBINARY
Support for Universal Tablespaces, Range Partitioning and Partition by Growth.
New fields shown on exploded Tablespace screens:
P-Spec (Part Specification)
DSSIZE
SEGSIZE
UTS (Universal Tablespace)
MAXPARTS
New Utility Programs
CPIMORPH:
Automatically converts a dynamic searched update to a program controlled
Update, giving control over commit frequencies, failure scenarios and records processed.
CPISCHED:
Ever wanted to schedule a job to run without the use of a complex scheduling
package? Simply pas the job name and a number of minutes before required
execution and CPISCHED will do the rest.
Utility Program Changes
CPISTATS:
Changes to the DB2 9 RTS are supported in the CPISTATA utility with full
forward and backward compatibility between DB2 8 and DB2 9.
This includes the move of the RTS to the DB2 Catalog, changes in numeric
datatypes and the introduction of new columns.
Changes to support DB2 9 Histogram and Data Repeat Factor Statistics.
Changes to support new catalog tables for Index on Expressions:
SYSIBM.SYSKEYTARGETS
SYSIBM.SYSKEYTGTDIST
SYSIBM.SYSKEYTARGETSTATS
SYSIBM.SYSKEYTGTDISTSTATS
CPIDDL: Support for new DB2 9 Datatypes:
BIGINT
DECFLOAT
BINARY
VARBINARY
Support for Index on Expressions.
Support for Universal Tablespaces, Range Partitioning and Partition by
Growth.
CPITEP2:
The ability to tailor the level of written output for DML and DDL (Non-Select Statements).
The new OUTPUT parameter allows you to show (A)ll Ouput or just (F)ailing
output.
This can be helpful in reducing the number of spooled records when running
many thousands of statements.
The summary counters are also now more helpful with a complete breakdown of Failed Statements, Successful Statements, Commit
Statements and Set Assignments statements.
This enables you to see more clearly the success of scripts that are restarted from the top when a number of statements have already been successfully processed. |