DBG03001E EXPECTING FIELD OR CONSTANT IN EXPRESSION

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

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?

         

 

 

 

 

 

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