view release on metacpan or  search on metacpan

CHANGES  view on Meta::CPAN

=head1 Changes in the 3.1 release

=head2 Remove support for DB2 releases prior to V8.2

Support for DB2 releases V7.2 and V8.1 has been dropped.

=head2 Improve support for Windows

Mike O'Reilly gracefully and patiently pointed out a number of
Unix-specific assumptions that have to be corrected to compile the
module with ActiveState Perl 5.8.8 for 32-bit and 64-bit Windows.

Most of these affect device and filenames

=head2 Add database manager configuration parameters for V9.7

Add the new DB2 V9.7 configuration parameters, most of which are
SSL-related.

=head2 Generate constants locally

The C<db2_constants.pl> file translates DB2 constants from symbolic
names to numeric values.  Previous releases generated the file when
the package was created for distribution; the file will now be
generated locally as part of the build process.  This is necessary
because IBM changes the value of some constants in an incompatible
manner; so a file generated for V9.5 will not work with V8.2.

=head2 ListUtilities fix

The C<ListUtilities> method now supports the C<Version> parameter.

=head1 Changes in the 3.0 release

=head2 Backup

Add support for the Backup command, including support for DPF backups
(with included logs) in DB2 V9.5.

=head1 Changes in the 2.9 release

=head2 Fix core dump in load from cursor

A second bug in the db2Load command, caused a load from cursor (source
type "Statement") to perform an invalid free, sometimes leading to a
core dump. Now fixed.  Have run valgrind on import/export/load to
verify no additional mistakes are present.

=head1 Changes in the 2.8 release

=head2 Fix core dump in load from cursor

A bug in the db2Load command, introduced in the 2.7 release, caused a
load from cursor (source type "Statement") to dump core. Now fixed.

=head2 BugFix in Load / Import

A bug in the Load and Import methods prevented load/import operations
against mixed-case schema and table names (which have to be
double-quoted when passed to DB2).  Now fixed.

=head2 Add the 'ReOpt' option to the Rebind method

The re-optimization level can now be set at Rebind time.

=head1 Changes in the 2.7 release

=head2 Rename module to DB2::Admin

The modules/classes have been renamed from DB2API to DB2::Admin as
recommended by Tim Bunce.

=head2 Add "list of files" support for Load of DEL files

The Load method now supports loading a list of DEL files in a single
command.

=head2 Support new protocol, types for node directory

Support the TCP/IP v4, TCP/IP v6 and TCP/IP v4 using SOCKS protocol
types for the node directory methods.

=head1 Changes in the 2.6 release

=head2 Add XML support to Export, Import and Load methods

The Export, Import and Load methods now supports the XML options
introduced in DB2 V9.1 (Export, Import) and DB2 V9.5 (Load).  Note
that the schema-related XML validate / default / ignore / map options
are not supported at this time.

=head2 Add connect attributes

Allow the user to specify the program name and connect time-out as
connect attributes.  Default options can be set with
C<SetConnectAttributes> and per-connect options can be specified with
the C<ConnectAttr> parameter to the C<Connect> method.

CHANGES  view on Meta::CPAN

A new 'Runstats' method can be used to collect table and index
statistics.  Only a subset of options is supported; specifically, the
column distribution options and column group features are not
supported.  This may change in future releases. This method requires
DB2 V8.

=head2 Minor Load FileOptions changes

Minor changes to the 'FileOptions' parameter to the 'Load' method: fix
some typos, add 'DumpFileAccessAll', add documentation.

=head2 Bugfix for "load terminate"

The perl and XS code for 'LOAD' got the caller_action wrong; this was
set to SQLU_TERMINATE for a "LOAD TERMINATE", but should always be set
to SQLU_INITIAL.  This removes code and is a Good Thing...

=head2 Add ListUtilities method

A new 'ListUtilities' method supports listing currently active
utilities.  It is implemented using an instance snapshot and requires
DB2 V8.

=head1 Changes in the 1.4 release

=head2 Support exception tables for Load

The Load method now supports the optional 'ExceptionTabe' and
'ExceptionSchema' parameters to set the exception table for load
exceptions.

=head2 Support the 'Utility type' constants

The 'utility type' constants returned by instance snapshots are now
supported.  Previously, a numeric code was displayed.

=head1 Changes in the 1.3 release

=head2 Add more Export options

Add the 'StripZeros', 'DatesISO' and 'DecPlusBlank' options to the
Export file modifiers

=head2 Handle quoting for FileOptions

FileOptions for Import, Export and Load that contain embedded blanks
(e.g. a TimestampFormat like 'MMM D YYY H:M:S') are now quoted before
being fed to the DB2 APIs.

=head2 Add LoadQuery method

A new LoadQuery method allows you to query the progress of a Load
command against a table.

=head1 Changes in the 1.2 release

=head2 Add ListHistory command

A new ListHistory method implements the equivalent of the CLP "List
History" command that allows you to query loads, backups,
rollforwards, etc.

=head2 Make test suite configurable

A CONFIG file is used to drive the test suite, externalizing the names
of the test database, test tables, schema names, etc.

=head1 Changes in the 1.1 release

=head2 Add Load method

New Load method provides an API to the table load functions; only a
subset of features is supported (most notably, partitioned loads,
table hierarchies, TSM media, LOBs and Data Links are not supported).

=head2 Add TargetColumns, InputColumns to Import method

New parameters to the Import method allow specification of the target
columns and selection of the relevant columns from the input file (by
position or DEL files and by name for IXF files).

=head2 Add ImportOptions to Import method

Add import options to the 'Import' method; this allows users to set
commit count, warning count, row count, skip count, etc.  Most options
are available only with DB2 V8.2.

=head1 Changes in the 1.0 release

=head2 Add CatalogDatabase / UncatalogDatabase methods

New methods to catalog a database in the database directory or
uncatalog one.

=head2 Add CatalogNode / UncatalogNode methods

New methods to catalog a node in the node directory or uncatalog one.

=head2 Add CatalogDCSDatabase / UncatalogDCSDatabase methods

New methods to catalog a DCS database in the DCS directory or
uncatalog one.

=head2 Add import/export options for DEL files

The following import options have been added for DEL files:
C<DateFormat>, C<TimeFormat>, C<TimestampFormat>, C<ImpliedDecimal>,
C<StripTBlanks>.

The following export options have been added for DEL files:
C<NoCharDel>, C<TimestampFormat>.

=head2 Use db2Export/db2Import function for export/import

On DB2 V8.2, the new db2Export function is used instead of sqluexpr
and the new db2Import function is used instead of sqluimpr.

=head2 Use db2DbDirXXX functions for GetDatabaseDirectory()

The DatabaseDirectory() method now uses the db2DbDirXXX functions when