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 IC71288 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 950 - 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.5 Fix Pack 7                        * 
****************************************************************
Local Fix:
Do not use MRI in SQLJ or bypass the gateway and connect 
directly to the host
Solution
Problem first fixed in DB2 version 9.5 Fix Pack 7
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.09.2010
11.10.2010
11.10.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)