PI92378: UNEXPECTED AND MISLEADING INZI193E WHEN VUM028/DISPLUSR DOES NOTHAVE SELECT PRIVILEGE ON SYSIBM.SYSSTRINGS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) The following error message unexpectedly issued.
  
  INZI193E DB2 ERROR: {DB2 FOR OS/390} {ODBC DRIVER} {DSN11015}
  DSNT408I SQLCODE = -551, ERROR: SYSOPR DOES NOT HAVE THE
           PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT
           SYSIBM.SYSSTRINGS
  
  This happens although the userid specified for "User used when
  issuing SELECT using dynamic SQL (VUM032/ACTLGUSR)" has the
  SELECT privilege on the SYSIBM.SYSSTRINGS catalog table.
  
  This occurs when both following conditions are fullfilled:
  * The "User used when issuing SELECT using dynamic SQL
    (VUM032/ACTLGUSR)" parameter is set to CURRENT_USER
  * The userid specified for the "User who runs the DISPLAY
    command (VUM028/DISPLUSR)" parameter does not have the
    SELECT privilege on the SYSIBM.SYSSTRINGS catalog table.
  
  When this situation occurs, DB2 HPU either fails because of
  CCSID conversion issues or completes successfully.
  
  DB2 HPU can do without the output of the involved SQL query
  provided the unicode conversion service is available for the
  CCSID conversions required for the unload in progress, the
  unload process can complete successfully.
  HPU fails if the necessary CCSID conversion is only available
  through the SYSIBM.SYSSTRINGS table.
  
  This happens when the userid specified for "User used when
  issuing SELECT using dynamic SQL (VUM032/ACTLGUSR)" has the
  SELECT privilege on the SYSIBM.SYSSTRINGS catalog table.
  
  PB51672 INZI193E INZI193 msgINZI193E msgINZI193
          DSNT408I DSNT408 msgDSNT408I msgDSNT408
          SQLCODE551
  

Local fix

• LF 1) If your unload ends successfully, no change is
        necessary as the DB2 HPU output is correct unless you
        want to avoid the misleading INZI193E error message.
  
  The following several ways can circumvent this issue.
  
  LF 2) Give the SELECT privilege on SYSIBM.SYSSTRINGS to the
        userid set for VUM028/DISPLUSR- set the "User used
        when issuing SELECT using dynamic SQL (VUM032/ACTLGUSR)"
        parameter with a specific userid (i.e. not CURRENT_USER)
        that has the required privileges.
  
  LF 3) If your unload fails because of CCSID conversion
        issues, enable the unicode conversion service for the
        requested CCSID conversion.
  
  The first two solutions (i.e. LF1 and LF2) restore the regular
  DB2 HPU behaviour thus preventing the irrelevant INZI193E error
  message to be issued.
  
  The last solution (LF3) only ensures the unload completes
  successfully and produces correct data but does not prevent the
  INZI193E error message from being issued.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User of High Performance Unload                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI91600:                                                     *
  * If the DSNCLI program is bound with an APPLCOMPAT value      *
  * different from the APPLCOMPAT from the DB2 setting:          *
  * - the INZI020I message displays an incorrect value in the    *
  * DB2 APPLCOMPAT field.                                        *
  * - if DB2 HPU settings or the APPLCOMPAT option specify a     *
  * target APPLCOMPAT identical to the DSNCLI's APPLCOMPAT, the  *
  * APPLCOMPAT change request is ignored by DB2 HPU              *
  *                                                              *
  * PI92271:                                                     *
  * A logical unload run in native mode involving a SELECT       *
  * statement with an ORDER clause might fail durng the sort     *
  * phase because of an underestimated allocation size for the   *
  * SORTIN data set or the DYNALLOC parameter for the sort       *
  * program.                                                     *
  * This can occur if the involved table space is partitionned   *
  * and several unload file are unload into a single dataset.    *
  *                                                              *
  * PI92378:                                                     *
  * The following error message                                  *
  * INZI193E DB2 ERROR:                                          *
  * {DB2 FOR OS/390} {ODBC DRIVER} {DSN11015}                    *
  * DSNT408I SQLCODE = -551, ERROR: SYSOPR DOES NOT HAVE THE     *
  * PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT              *
  * SYSIBM.SYSSTRINGS                                            *
  * is unexpectedly issued when the userid specified for "User   *
  * used when issuing SELECT using dynamic SQL                   *
  * (VUM032/ACTLGUSR)" has the SELECT privilege on the           *
  * SYSIBM.SYSSTRINGS catalog table. This occurs when            *
  * VUM032/ACTLGUSR is set to CURRENT_USER and the "User who     *
  * runs the DISPLAY command (VUM028/DISPLUSR)" does not have    *
  * the SELECT privilege on the SYSIBM.SYSSTRINGS catalog table. *
  * When this situation occurs, DB2 HPU either fails because of  *
  * CCSID conversion issues or complete successfully. DB2 HPU    *
  * can do without the output of the involved SQL query provided *
  * the unicode conversion service is available for the CCSID    *
  * conversions required for the unload in progress, the unload  *
  * process can complete successfully. It fails if the necessary *
  * CCSID conversion is only available through the               *
  * SYSIBM.SYSSTRINGS table.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

• PI91600:
  Consider binding DSNCLI with no APPLCOMPAT.
  
  PI92378:
  If your unload ends successfully, no change is actually
  necessary as the DB2 HPU output is correct unless you want to
  avoid the misleading INZI193E error message to be issued.
  Here is a couple of ways to circumvent this issue.
  Give the SELECT privilege on SYSIBM.SYSSTRINGS to the userid set
  for VUM028/DISPLUSR:
  this restores the regular DB2 HPU behavior and this is the only
  one that allows to prevent the irrelevant INZI193E error message
  to be issued.
  If your unload fails because of CCSID conversion issues, enable
  the unicode conversion service for the requested CCSID
  conversion:
  this does not prevent the INZI193E error message to be issued
  but allows the unload to complete successfully.
  

Comments

APAR Information

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

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

  010PC2Ÿ UI53425

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI53425

     UP18/01/27 P F801

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.