Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: Microsoft Service for DRDA doesn't log the static SQL package name in an SQL statement

FIX: Microsoft Service for DRDA doesn't log the static SQL package name in an SQL statement

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You use the Microsoft Service for Distributed Relational Database Architecture (DRDA) to send SQL statements from IBM DB2 to SQL Server.
  • A parameterized SQL statement is included in a static SQL package.
  • The parameter data values that are passed in the SQL statement are invalid values for the data types that are used.
In this scenario, the name of the static SQL package that is run when an error occurs is not written to the Microsoft Service for DRDA log file. The missing static SQL package name makes it difficult to identify which package failed when there are multiple SQL packages being run by the Microsoft Service for DRDA.

↑ Back to the top

Resolution

Cumulative update information

The fix that resolves this problem is included in Cumulative Update 1 for Host Integration Server 2013.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More Information

After Cumulative Update 1 is applied, the Microsoft Service for DRDA writes additional details to the log file when errors occur during the processing of invalid SQL parameter data values. The additional details include the SQL package name and the consistency token.

↑ Back to the top

Keywords: kbqfe, kbhotfixserver, kbfix, kbexpertiseinter, kbbug, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2904596
Revision : 1
Created on : 1/7/2017
Published on : 4/1/2014
Exists online : False
Views : 338