J06.05 Release Version Update Compendium

4 Database and Transaction Processing Products
SQL/MP Support for Increasing Catalog Extents
The CREATE CATALOG command is enhanced to include two new options: EXTENT and
MAXEXTENTS. These options do the following:
• EXTENT specifies the primary and secondary extent sizes for the catalog tables and indexes.
• MAXEXTENTS specifies the maximum allowed number of extents for the catalog tables and
indexes.
If the user does not specify these options, the default values are:
• EXTENT: Catalog table extent sizes default to 16 pages for primary extent size,and 128 pages
for secondary extent size.Catalog index extent sizes default to 16 pages for primary extent
size,and 64 pages for secondary extent size.
• MAXEXTENTS: If the EXTENT option is not specified, the default value is 940 pages. If the
EXTENT option is specified, MAXEXTENTS is calculated from the EXTENT value.
SQL/MX 2.3.2 Enhancements
SQL/MX 2.3.2 has several new features for the J06.05 RVU:
• The MODIFY utility allows users to specify a partition name. The partition name can be
used to identify the source partition for the DROP, MOVE, and REUSE operations. For the
ADD and MOVE operations, a partition name can be specified along with the new location.
Users can now use a naming scheme for partitions and then write scripts based on those
names.
• The UPDATE STATISTICS command allows the sample table to be partitioned. This table
is used to store temporary results when the sample clause is specified. By default, the sample
table is not partitioned. Users can now specify that the sample table is to be partitioned in
the same way as the base table. In addition, users can create their own sample tables for use
by the UPDATE STATISTICS command.
• The UPDATE STATISTICS command supports DP2 row sampling. This reduces the number
of records read and discarded by the command while sampling the base table.
• Support is added for stored procedures that return Result Sets in Java. This feature enables
a stored procedure to return an ordered set of open cursors to the calling program: the
program issues a CALL statement, and the CALL statement then makes sets of rows from
SQL/MX queries available to the program.
The following products support the Result Set feature:
— SQL/MX
— JDBC/MX Type 2 Driver
— JDBC/MX Type 4 Driver
— ODBC/MX Client Driver
— MXCS server components
Enform Plus
You can now run the Query Processor (QP) component of Enform Plus at a high-pin after setting
the HIGHPIN attribute of the QP program object to ON.
SQL/MP Support for Increasing Catalog Extents 17