DB2-Admin

 view release on metacpan or  search on metacpan

CHANGES  view on Meta::CPAN

=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.

CHANGES.html  view on Meta::CPAN

	<LI><A HREF="#Changes_in_the_3_0_release">Changes in the 3.0 release</A>
	<UL>

		<LI><A HREF="#Backup">Backup</A>
	</UL>

	<LI><A HREF="#Changes_in_the_2_9_release">Changes in the 2.9 release</A>
	<UL>

		<LI><A HREF="#Fix_core_dump_in_load_from_curso">Fix core dump in load from cursor</A>
	</UL>

	<LI><A HREF="#Changes_in_the_2_8_release">Changes in the 2.8 release</A>
	<UL>

		<LI><A HREF="#Fix_core_dump_in_load_from_curso">Fix core dump in load from cursor</A>
		<LI><A HREF="#BugFix_in_Load_Import">BugFix in Load / Import</A>
		<LI><A HREF="#Add_the_ReOpt_option_to_the_Re">Add the 'ReOpt' option to the Rebind method</A>
	</UL>

	<LI><A HREF="#Changes_in_the_2_7_release">Changes in the 2.7 release</A>
	<UL>

		<LI><A HREF="#Rename_module_to_DB2_Admin">Rename module to DB2::Admin</A>
		<LI><A HREF="#Add_list_of_files_support_for_">Add "list of files" support for Load of DEL files</A>
		<LI><A HREF="#Support_new_protocol_types_for_">Support new protocol, types for node directory</A>

CHANGES.html  view on Meta::CPAN

<P>

<P>
<HR>
<H1><A NAME="Changes_in_the_2_9_release">Changes in the 2.9 release

</A></H1>
<P>
<HR>
<H2><A NAME="Fix_core_dump_in_load_from_curso">Fix core dump in load from cursor

</A></H2>
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.


<P>

<P>
<HR>
<H1><A NAME="Changes_in_the_2_8_release">Changes in the 2.8 release

</A></H1>
<P>
<HR>
<H2><A NAME="Fix_core_dump_in_load_from_curso">Fix core dump in load from cursor

</A></H2>
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.


<P>

<P>
<HR>
<H2><A NAME="BugFix_in_Load_Import">BugFix in Load / Import

</A></H2>
A bug in the Load and Import methods prevented load/import operations

t/62load.t  view on Meta::CPAN

                           'NonRecoverable' => 1,
                           #'RowCount'       => 20,
                          },
      );
    #print Dumper(\%load_params);
    $results = DB2::Admin->Load(%load_params);
    ok(defined $results, "Load succeeded - DEL file w LOBs");
    #print STDERR Dumper($results);

    #
    # Test a load from a SQL statement (load from cursor)
    #
    $results = DB2::Admin->
      Load('Database'       => $db_name,
           'Schema'         => $schema_name,
           'Table'          => $table_name,
           'SourceType'     => 'Statement',
           'LoadOptions'    => { 'NonRecoverable' => 1, },
           'Operation'      => 'Replace',
           'InputStatement' => "select * from $schema_name.$myconfig{SOURCE_TABLE}",
          );