PI91918: SQLCODE -189 FROM DSNXROHB ERRONEOUSLY ISSUED FOR SINGLETON SELECT (SELECT INTO) IN A DISTRIBUTED ENVIRONMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE -189 with SQLSTATE= 22522 from DSNXROHB
  errouneosly issued for a singleton select
  (SELECT INTO) statement in a distributed environment
  when the below conditions are true:
  
  1. LOB locator is used
    and
  2. A FOR BIT DATA column is in the select list. Problem can also
  occur when a CCSID difference exists between a host variable and
  corresponding column necessitating conversion.
    and
  3. Column for (1) precedes that of (2).
  
  
  A seperate problem addressed by this apar is ABEND
  004E 00D35011 DSNLZD00:0015 on DESCRIBE TABLE
  
  
  
  Additional keywords and symptoms:
  ************************************
  DB2DDF DSNXROHB SQLCODE189
  00D35011 RC00D35011 DSNLZD00
  ABNDID0015
  

Local fix

• no local workaround or fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Distributed Data Facility (DDF) users.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR addresses two unrelated                            *
  * symptoms:                                                    *
  * 1. SQLCODE -189 can be incorrectly                           *
  * issued for a remote SELECT INTO                              *
  * statement that assigns values to                             *
  * LOB locator targets.                                         *
  * 2. DESCRIBE TABLE statement can                              *
  * result in abend 04E-00D35011                                 *
  * DSNLZD00:0015 at a Db2 server.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available.                         *
  ****************************************************************
  The following two unrelated conditions are reported:
  1. A SELECT INTO statement running remotely can fail at the
  requester with SQLCODE -189 issued by DSNXROHB at location
  -125 when one of the output values is assigned to a LOB
  locator target, and another output value needs character
  conversion.  When Db2 processes the LOB locator, it overlays
  CCSID information causing a SQLCODE -189 conversion failure.
  2. A remote DESCRIBE TABLE statement can result in 04E-00D35011
  DSNLZD00:0015 on a Db2 for z/OS server.  The Db2 server did
  not expect a DESCRIBE TABLE statement as the first statement
  in transaction and abends.
  This problem only occurs on a Db2 12 for z/OS server.
  

Problem conclusion

• Db2 has been changed as follows:
  1. Db2 has been changed to prevent overlay of CCSID information
     during LOB locator processing.
  2. DESCRIBE TABLE statement is now allowed as the first
     statement in a Db2 12 transaction.
  

Temporary fix

Comments

APAR Information

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

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

  UI53489 UI53494

Modules/Macros

• DSNLZRDS DSNLZD00
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI53489

     UP18/02/12 P F802

• RB10 PSY UI53494

     UP18/02/12 P F802

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.