search cancel

SYSVIEW® PERFORMANCE MANAGEMENT OPTION FOR DB2: HTURLF DBG01014E DB51 08:04:01 MISSPELLED RESERVED WORD

book

Article ID: 228929

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Applying CA R20 maintenance to our CA DB2 Tools. When starting the data collection the following error is seen: 

DBG04004I DB51 08:04:01 REQUEST HTURLF   FROM *HSTIN*                           
DBG01014E DB51 08:04:01 MISSPELLED RESERVED WORD OR LITERAL RLF-LIMIT-TYPE      
                                   <|                                           
DBG02018E DB51 08:04:01 INVALID FIELD SPECIFICATION                             
         9551          COUNT(*)                  (HD='Count' HELP=ACCTCNT)      
         9552          AVG(RLF-HIGHEST-USED-CPU)                                
                                             <|                                 
DBG01014E DB51 08:04:01 MISSPELLED RESERVED WORD OR LITERAL RLF-HIGHEST-USED-CPU
                                             <|                                 
DBG02016E DB51 08:04:01 EXPECTING A FIELD SPECIFICATION                         
                                             <|                                 
DBG02022E DB51 08:04:01 MISSING MATCHING PAREN ON PARAMETER                     
         9553             (HD='Avg CPU Used' PF=N3.4 HELP=RLFHICPU)             
         9554          MAX(RLF-HIGHEST-USED-CPU) (HD='Max CPU Used' HELP=RLFHICP
                                             <|                                 
DBG01014E DB51 08:04:01 MISSPELLED RESERVED WORD OR LITERAL RLF-HIGHEST-USED-CPU
                                             <|                                 
DBG02016E DB51 08:04:01 EXPECTING A FIELD SPECIFICATION                      

 

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

Any maintenance does not update the hlq.REQUESTS library at all and it contains user customized IQL that the user would need to maintain.

The IQL requests in question( HTLOCKS and HTURLF) were customized and were not compatible with the current product operation after the maintenance was applied. These were removed in order to bring up the Data Collector. 

It is the responsibility of the customer to maintain user produced IQL in the hlq.REQUESTS library. This is by design. The IQL's in the hlq.CDBATREQ library are maintained by maintenance.

Additional Information

IQL Control Parameters

DBG01014E