PM88612: SQLSTATE01517 RETURNED ON SELECT OF CHARACTER COLUMNS FROM SYSIBM.SYSLGRNX. ALSO, SUB (X'3F') RETURNED IN THE DATA.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Selecting any of the CHAR columns from SYSIBM.SYSLGRNX, such as
  LGRSRBA, LGRSPBA, LGRSLRSN, and LGRELRSN  resulted in:
  
  DSNT400I SQLCODE = 000,  SUCCESSFUL
  
  EXECUTION
  DSNT418I SQLSTATE   = 01517 SQLSTATE RETURN
  CODE
  DSNT415I SQLERRP    = DSN SQL PROCEDURE DETECTING
  ERROR
  DSNT416I SQLERRD    = 0 0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000000'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC
  INFORMATION
  DSNT417I SQLWARN0-5 = W,,,,, SQL
  WARNINGS
  DSNT417I SQLWARN6-A = ,,W,,   SQL
  WARNINGS
  
  and the substitution character (SUB) (X'3F') being returned
  instead of the original data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users that issue a select from           *
  *                 SYSIBM.SYSLGRNX.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: SELECT from SYSIBM.SYSLGRNX can         *
  *                      return an sqlstate 01517.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 is running with MIXED=YES and  MCCSID=939 specified in
  DSNHDECP. The following query is executed:
  SELECT LGRDBID, LGRPSID,
         LGRSLRSN, HEX(LGRSLRSN), LGRELRSN, HEX(LGRELRSN)
    FROM SYSIBM.SYSLGRNX
      ORDER BY LGRDBID, LGRPSID, LGRSLRSN;
  This returns an sqlstate of 01517.  Other MCCSIDs may get the
  same failure.
  

Problem conclusion

• The following columns in SYSIBM.SYSLGRNX are CHAR FOR BIT
  LGRDBID
  LGRPSID
  LGRSRBA
  LGRSPBA
  LGRSLRSN
  LGRELRSN
  LGRMEMB
  The FOREIGNKEY column in the rows in SYSIBM.SYSCOLUMNS for
  SYSLGRNX incorrectly has a value of 'S' and this
  could cause the sqlstate 01517 to be returned. The
  FOREIGNKEY column was change to 'B' for these rows to
  correct the problem. The rows will be correctly inserted
  if this apar is on before DSNTIJNF is run for the first
  time or they can be corrected after you are in NFM by
  running the job
  CATMAINT UPDATE UNLDDN PM88612
  ++HOLD for PM88612
  This apar corrects rows for the SYSIBM.SYSLGRNX table in
  SYSIBM.SYSCOLUMNS table.  To verify if the catalog has already
  been updated run the query:
  SELECT * FROM SYSIBM.SYSCOLUMNS
    WHERE TBNAME='SYSLGRNX' AND FOREIGNKEY='B'
  The query will return seven rows if the catalog has been updated
  and zero rows if it has not been updated. If the query returns
  zero rows the catalog can be updated by running the utility job
  CATMAINT UPDATE UNLDDN PM88612
  The job will replace any existing catalog rows for directory
  objects that existed before the job is run.  This will
  invalidate packages that are dependent on the directory tables.
  

Temporary fix

Comments

• ž**** PE14/09/22 FIX IN ERROR. SEE APAR PI26218  FOR DESCRIPTION
  

APAR Information

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

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

  UK95283

Modules/Macros

• DSNUECM0 DSNUECSE
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK95283

     UP13/07/09 P F307

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.