home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC71053 Status: Closed

ERROR -4428 IN SQLJ APPLICATION WHEN RUNNING MRI QUERY AGAINST DB2/Z VIA
GATEWAY.

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
A MRI (Multi Row Insert) query issued from an SQLJ application 
against a DB2/z database via a DB2 Connect gateway can result in 
error -4428 or -4499 on the client. The gateway receives error 
SYNTAXRM from the host due to incorrectly formatted SQLDTA 
structure.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* ERROR -4428 IN SQLJ APPLICATION WHEN RUNNING MRI QUERY       * 
* AGAINST DB2/Z VIA GATEWAY.                                   * 
*                                                              * 
* A MRI (Multi Row Insert) query issued from an SQLJ           * 
* application                                                  * 
* against a DB2/z database via a DB2 Connect gateway can       * 
* result in                                                    * 
* error -4428 or -4499 on the client. The gateway receives     * 
* error                                                        * 
* SYNTAXRM from the host due to incorrectly formatted SQLDTA   * 
* structure.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.1 Fix Pack 10                       * 
****************************************************************
Local Fix:
Do not use MRI in SQLJ or bypass the gateway and connect 
directly to the host
available fix packs:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Problem first fixed in DB2 version 9.1 Fix Pack 10
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71288 IC71290 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.09.2010
11.10.2010
11.10.2010
Problem solved at the following versions (IBM BugInfos)
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList