PH63771: -206 WHEN TRYING TO GET REAL TIME STATS (RTS) ON AN INDEX WHEN USING DB2 FL 500

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User is at DB2 F.Lvl : V13R1M500
  When user navigates to the 1 - DB2 system catalog panel
  enter I for index and specify RTS line command for the index
  they are interested in:
  
  They get the following:
  
  SQLCODE : -206 DSNTIAR CODE : 0
  
  DSNT408I SQLCODE = -206, ERROR: REORGEXCSPLITS IS NOT VALID IN
  THE CONTEXT WHERE IT IS USED
  DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When RTS is issued on index panel       *
  *                      ADB21X, SQLCODE = -206 is returned if   *
  *                      the user is running at Db2 function     *
  *                      level V13R1M500.                        *
  ****************************************************************
  The Db2 subsystem is currently running at Db2 function level
  V13R1M500 (as displayed on the main menu in the 'DB2 F.Lvl'
  field).  The user navigates to the ADB21 - DB2 System Catalog
  panel and enters X for index. When the user specifies the RTS
  line command for the index they are interested in, the following
  SQLCODE is returned:
  
  -206 DSNTIAR CODE : 0
  DSNT408I SQLCODE = -206, ERROR: REORGEXCSPLITS IS NOT VALID IN
  THE CONTEXT WHERE IT IS USED
  DSNT418I SQLSTATE = 42703 SQLSTATE RETURN CODE
  DSNT415I SQLERRP = DSNXORSO SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
  

Problem conclusion

• The problem has been resolved.
  

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:

  UO02128

Modules/Macros

• ADB21XSD ADB2314I ADB2314X
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO02128

     UP25/02/20 P F502

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.