DBG03001E EXPECTING FIELD OR CONSTANT IN EXPRESSION

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Trying to  filter on specific criteria for an history report with the following GLOBALS statement:

//      DD *

  GLOBALS

     WHERE (EVENT-TIME >= '161121200000' AND <= '161121230000')

     AND THD-ELAPSED >= '00500000'

    ;

/*

The following error message was displayed because of THD-ELAPSED field.  

DBG03001E DBP1 13:58:41 EXPECTING FIELD OR CONSTANT IN EXPRESSION

DBG01014E DBP1 13:58:41 MISSPELLED RESERVED WORD OR LITERAL THD-ELAPSED

 DBG99001E DBP1 13:58:41 ERROR IN COMMAND STREAM, PROCESSING ENDED                                

Why?

         

 

 

 

 

 

Environment

Release:
Component: CIDB

Resolution

The product will not filter the batch GLOBALS statement because THD-ELAPSED field is not a common field.  You can however add WHERE (EVENT-TIME >= '161121200000' AND <= '161121230000') AND THD-ELAPSED >= '00500000' in the request. 

For the common fields see Sysview for DB2 (Insight for DB2) writing Requests Guide Appendix A: Control Block Data and Event Trace Records

Additional Information

For the common fields see Sysview for DB2 (Insight for DB2) writing Requests Guide Appendix A: Control Block Data and Event Trace Records