IT21245: DB2BULKCOPY CAUSES THE ERROR CLI0112E AND LOAD INCORRECT VALUES WHEN USING SQLDATAREADER

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• For the case SQLDataReader -> DB2BulkCopy, the following is the
  used
  code, resulting in CLI0112E at copy.WriteToServer(reader):
  
  Imports System
  Imports System.IO
  Imports System.Data
  Imports IBM.Data.DB2
  Imports Microsoft.VisualBasic
  Imports System.Data.SqlClient
  
  Public Class Module1
      Public Shared Sub Main(args() As String)
          Try
              Using sqlconn As SqlConnection = New
  SqlConnection("Server=MM-PC\SQLEXPRESS;Database=testjg;UserId=je
  nsi;Password=mypwd;")
                  sqlconn.Open()
                  Using cmd As SqlCommand =
  sqlconn.CreateCommand()
                      cmd.CommandText = "Select F1, F2, F3 From
  dbo.t1"
                      Using reader As SqlDataReader =
  cmd.ExecuteReader()
                          Using cn As New
  DB2Connection("Database=SAMPLE;UID=db2admin;Pwd=mypwd;Server=127
  .0.0.1:50000")
                              cn.Open()
                              Using copy As New DB2BulkCopy(cn)
                                  copy.BulkCopyTimeout = 0
                                  copy.DestinationTableName
  ="db2admin.t2"
                                  copy.ColumnMappings.Add(New
  DB2BulkCopyColumnMapping("F1", "F1"))
                                  copy.ColumnMappings.Add(New
  DB2BulkCopyColumnMapping("F2", "F2"))
                                  copy.ColumnMappings.Add(New
  DB2BulkCopyColumnMapping("F3", "F3"))
                                  copy.WriteToServer(reader)
                                  copy.Close()
                                  Console.WriteLine("success")
                              End Using
                          End Using
                      End Using
                  End Using
              End Using
          Catch ex As Exception
              Dim fehler As String = ex.ToString()
              Console.WriteLine(fehler)
          End Try
      End Sub
  End Class
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to V11.1.3.3.                                        *
  ****************************************************************
  

Problem conclusion

• Fixed in V11.1.3.3.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT21243

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels