The following topics are covered:
This version of Predict supports Db2® Version 12. Several changes and enhancements have been made in various areas of Predict and its documentation.
For a detailed description of new features, refer to the following sections:
Predict now supports encryption using key labels in storagespaces and files of type D and MT. Refer to the description of the attribute Keylabel name given under Adding a Storagespace in the Predefined Object Types in Predict documentation.
For dataspaces of type D (DB2 mainframe dataspaces), the option DSSIZE can be set. DSSIZE in the Partition definition specifies the value of DSSIZE given in the PARTITION clause for that partition.
Refer to the description of the option DSSIZE given under Defining Partitions in the Predefined Object Types in Predict documentation.
The object type Dataspace has been extended by 2 new attributes:
Pagenum
Specifies the type of page numbering that is used when you
alter a partition-by-range table space.
Insert algorithm
Specifies the algorithm that is used when rows are inserted
into tables in this table space.
Refer to Defining Basic Attributes of Dataspace - DB2 Mainframe of the Predefined Object Types in Predict documentation for further details.
The field option CCSID has been added to enable the creation of ASCII/Unicode fields in EBCDIC tables.
This option can be used for fields in files of type D, E, IV, IT, MT and Z.
The field option period specifies whether the value of the end column is included or excluded in the period BUSINESS_TIME.
This option can be used only for fields named BUSINESS_TIME in files of type D and MT.
See also Base Extensions > Period in section Field of the Predefined Object Types in Predict documentation for further details.
For index fields in files of type D and MT the option DSSIZE can be set.
DSSIZE in the Index Default Definiton specifies the maximum size for each partition of a partitioned index.
DSSIZE in the Partition definition specifies the value of DSSIZE given in the PARTITION clause for that partition.
To support Db2® Accelerator tables, it is now possible to provide an Accelerator name as an attribute for files of type D and MT.