IBM Systems Magazine, Mainframe - March/April 2017 - 52
pages increased to 280 trillion.
Increasing DSSIZE is supported at
the partition level and no longer requires a REORG, however
decreasing DSSIZE does. A new
DSSIZE support exists for indexes.
Attribute modifications by partition and schema changes are
externalized using REORG PART.
Online schema improvements
are always a DBA's favorite for
each DB2 release. DBAs can now
insert a new partition between
existing partitions. ALTER INDEX
COMPRESS YES, which allows
the user to alter an index to use
compression, will no longer
cause an outage by putting the
index in rebuild pending. This
statement is now online deferred.
Another enhancement allows
multiple conflicting deferred
ALTER statements at the column level, which are materialized through online REORG to
be mixed without issue. Also,
the TRANSFER OWNERSHIP
statement now allows you to
transfer ownership to a new
AUTHID or role without having
to first unload, drop or recreate
Migration to DB2 12 has
changed considerably. The
stage has been eliminated,
and new-function mode is now
activated by new command
-ACTIVATE FUNCTION LEVEL.
APPLCOMPAT and fallback rules
continue to apply. In DB2 11,
DB2 12 offers
more speed for
conversion of the bootstrap data
set from a 6-byte to a 10-byte
relative byte address was voluntary but is mandatory for DB2 12.
Basic row format is deprecated
with the ZPARM and REORG
options removed. Temporal realtime statistics (RTS) are integrated
into the DB2 catalog, although the
enablement is optional. This will
allow clients to trend information,
such as data set size, in the RTS.
DB2 direction also aligns with
the mainframe software direction
of continuous delivery. DB2 12
provides continuous delivery,
whereby clients can apply new
enhancements without waiting
for the traditional DB2 three-year
software cycle for a new version.
DB2 utilities benefit from
improved efficiency by reducing
Featuring content from
On-demand enterprise IT education
hand-picked by experts.
52 // MARCH/APRIL 2017 ibmsystemsmag.com
pg 50-53.indd 4
2/7/17 2:12 PM