PH56590: THE STORED PROCEDURE ACCEL_GET_TABLES_INFO DOES NOT RETURN THE NEW PARAMETERS LASTACCESSTIMESTAMP AND ACCESSCOUNT BY DEFAULT.

APAR status

• Closed as documentation error.

Error description

• With Accelerator maintenance level 7.5.11.x (7.5.12.x), the
  stored procedure ACCEL_GET_TABLES_INFO does not return the new
  parameters lastAccessTimestamp and accessCount by default.
  
  Additional keywords:
  TS013812846 TS015650997 ACCEL_GET_TABLES_INFO
  lastAccessTimestamp accessCount #idaa7511 #idaa7512
  GH/.../Customer-Cases/issues/553
  DT237991 PH61845
  

Local fix

• As a workaround, specify the compatibility level 79 in the
  message parameter to get the new parameters in the output.
  The XML to be used for the message parameter is the following:
  <?xml version="1.0" encoding="UTF-8" ?><dwa:messageControl
  xmlns:dwa="http://www.ibm.com/xmlns/prod/dwa/2011"
  version="1.2"><compatibilityLevel>79</compatibilityLevel><langua
  
  
  
  
  ge>en_US</language></dwa:messageControl>
  

Problem summary

• Problem Summary:
  The stored procedure ACCEL_GET_TABLES_INFO does not return the
  new parameters lastAccessTimestamp and accessCount by default.
  
  Users Affected:
  Users of Stored procedure ACCEL_GET_TABLES_INFO when running
  Accelerator maintenance level 7.5.11.x (7.5.12.x).
  
  Problem Scenario:
  See APAR Error description.
  
  Problem Symptoms:
  See APAR Error description.
  

Problem conclusion

• The issue has been fixed. The fix is part of PTF UI97750 (APAR
  PH61845) delivering the Stored Procedures fitting to Accelerator
  maintenance level 7.5.13.
  
  Apply PTF UI97750 or its successor and upgrade your installation
  libraries accordingly.
  

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:

Fix information

Applicable component levels