search cancel

Table Accelerator list

book

Article ID: 214449

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

In the menu "RC/Q Table Accelerator list" the columns Dist-Key and ORG-Key are not included.


If you enter sql on the command line then the following SQL occurs:

 Current SQL Statement:                                                       
                                                                              
SELECT  A.NAME , A.CREATOR , A.ACCELERATORNAME , A.REMOTENAME ,               
        A.REMOTECREATOR , A.ENABLE , A.CREATEDBY , A.CREATEDTS , A.ALTEREDTS ,
        A.REFRESH_TIME , A.ARCHIVE                                            
   FROM SYSACCEL.SYSACCELERATEDTABLES A                                       
  WHERE A.NAME LIKE 'CAS%'                                                    
  ORDER BY A.NAME , A.CREATOR WITH CS                                         
******************************* BOTTOM OF DATA *******************************

Why are these two columns also not listed?

Environment

Release : 20.0

Component : CA RC/Query for DB2 for z/OS

Resolution

Set   Acckeys ===> Y  and this will resolve the issue.