PH16500: BROWSE FEDERATED DB2 UDB TABLES DSNT408I SQLCODE = -644 / SQLCODEN644 SQLSTATE = 42615 SYNTAX ERROR ACCESS RULE VIOLATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Browsing federated Db2 LUW tables (BR or B command on panel
  ADB21T) may result in the following error:
  
  DSNT408I SQLCODE = -644, SQLSTATE = 42615, SYNTAX ERROR OR
  ACCESS RULE VIOLATION FROM DB2 UDB for AIX, Linux, HP-UX, Sun,
  and Windows TOKENS OPTIMIZE <ATTRIBUTE-STRING>
  
  The same message may result from executing a written SELECT
  statement from panel ADBPMESQ 'Edit/Run SQL Statement'.
  

Local fix

• Set 'Max No of Rows to Fetch' parameter on Db2
  Admin Defaults to 0 (unlimited).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users that run DB2 Administration Tool for   *
  *                 z/OS with a Db2 LUW system that has          *
  *                 federated tables.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -644 might occur                *
  *                      when browsing federated tables.         *
  ****************************************************************
  When browsing an alias of a remote federated table with line
  command 'BR' or 'B' on panel ADB21T 'Tables, Views, and Aliases'
  might produce the following SQL error:
  
  DSNT408I SQLCODE = -644, SQLSTATE = 42615, SYNTAX ERROR
  OR ACCESS RULE VIOLATION FROM DB2 UDB for AIX,
  Linux, HP-UX, Sun, and Windows TOKENS OPTIMIZE<ATTRIBUTE-STRING>
  
  This error might also occur when issuing a SELECT statement on a
  table from panel ADBPMESQ 'Edit/Run SQL Statement' (option
  2;1, 'Edit/run SQL statements', from main menu).
  

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:

  UI71451

Modules/Macros

• ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71451

     UP20/10/01 P F009

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.