Steps to modify an existing IQL and run it in online mode.

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Is there a procedure to replace the IQL member that the DC uses with the modified one?

Resolution

Here are the steps to modify an existing or default IQL and run it in online mode:

1) If you don't know your default and customized request libraries, here is how to find it:

You can go to User Profile( By typing "Profile" on the command line in SYSVIEW for DB2(IDB2) main menu & press F8) until you see the screen below. 

Profile                  User Profile                               Page 3 of 5
                                                                               
 Additional Request Datasets                                                   
                                                                               
   First User Dataset . . . . . ____________________________________________   
   Second User Dataset  . . . . ____________________________________________   
   First Pre-defined  . . . . : HLQ.REQUESTS                  
   Second Pre-defined . . . . : HLQ.CDBATREQ    
        

2) Copy the IQL member like HTLIST from HLQ.CDBATREQ  to HLQ.REQUESTS with same name and modify the member under HLQ.REQUESTS. 

3) Once IQL is modified, STOP & START the IQL or Recycle the data collector. The modified IQL will be picked form the First Pre-defined data set.