Migrating Saved SQL Queries

Document ID : KB000054773
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How do I migrate the saved QUERIES from a previous release to the current release of RCQ?

Solution:

There is a Post Install Conversion Task (ssid0302) that allows users to convert data from old EQF (Extended Query Facility) tables to new EQF tables.

The following EQF database tables need to be converted:

PTI.PTSQL_DATA_0102    to    PTI.PTSQL_DATA_115
PTI.PTSQL_TEXT_0101    to    PTI.PTSQL_TEXT_115

This is a DB2 catalog customization task - refer to the Implementation Guide for details:

---------------------- Select DB2 Tasks -------------------- Row               
Command ===>                                                  Scroll ===>      
Select tasks to be performed, then press ENTER                                 
Line commands: S Select, U Unselect, V View task information                              
                                                                          
 Line commands: S Select, U Unselect, V View task information              
 Commands.....: ALLS, ALLU, ALLV = Select all/Unselect all/View all        
                                                                           
  S Product  Task Description                                   Member     
                                                                           
    ...      .....                                                         
                                                                           
    GEN      GRANT PUBLIC ACCESS TO GLOBAL DEFAULTS                        
                                                                           
    GEN      Grant PUBLIC access to General Services plan                  
                                                                           
    GEN      EQF Table Conversion Task            
                                                                           
    DAGT     Unicenter DB2 Agent: DB2 Specific Install Tasks