HTURLF DBG01014E ssid hh:mm:ss MISSPELLED RESERVED WORD starting Sysview for Db2 Data Collector
search cancel

HTURLF DBG01014E ssid hh:mm:ss MISSPELLED RESERVED WORD starting Sysview for Db2 Data Collector

book

Article ID: 228929

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Applying r20 maintenance to Database Management Solutions for Db2 for z/OS tools.

When starting the Sysview Performance Management Option for Db2 for z/OS (IDB2) Data Collector the following error is seen: 

DBG04004I ssid hh:mm:ss REQUEST HTURLF   FROM *HSTIN*                           
DBG01014E ssid hh:mm:ss MISSPELLED RESERVED WORD OR LITERAL RLF-LIMIT-TYPE      
                                   <|                                           
DBG02018E ssid hh:mm:ss INVALID FIELD SPECIFICATION                            
         9551          COUNT(*)                  (HD='Count' HELP=ACCTCNT)      
         9552          AVG(RLF-HIGHEST-USED-CPU)                                
                                             <|                                 
DBG01014E ssid hh:mm:ss MISSPELLED RESERVED WORD OR LITERAL RLF-HIGHEST-USED-CPU
                                             <|                                 
DBG02016E ssid hh:mm:ss EXPECTING A FIELD SPECIFICATION                        
                                             <|                                 
DBG02022E ssid hh:mm:ss 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 ssid hh:mm:ss MISSPELLED RESERVED WORD OR LITERAL RLF-HIGHEST-USED-CPU
                                             <|                                 
DBG02016E ssid hh:mm:ss EXPECTING A FIELD SPECIFICATION   

DBG99001E      hh:mm:ss ERROR IN COMMAND STREAM, PROCESSING ENDED.
DBG85255I ssid hh:mm:ss CCS Data Mover task terminate.
DBG11017I ssid hh:mm:ss ESTAE EXIT IN AMXSSXP INVOKED BY ABEND  
ABEND CODE IS 04378000 - EC PSW AT ABEND IS 070C1000 811BC580 - PRIMARY MODE,
ICL, INTERRUPT CODE 0002000D - TRANSLATE EXCEP 00000000

Cause

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. 

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