SYSVIEW ERPT247E INVALID IDENTIFIER SPECIFIED report CICS response time

Products

• SYSVIEW Performance Management

Issue/Introduction

Attempting to write a SYSVIEW report based on the CNM4RSAM member CICS031.
Coded SELECT JOBNAME(INJTDCS) to filter by CICS region and that works.

What is the syntax to filter a transaction response time greater than 1? 

Coded SELECT C_RESPTIME_TM > 1 and the job ends with return code 8 and message:

ERPT247E INVALID IDENTIFIER SPECIFIED. 

Resolution

Use RANGE instead of SELECT to restrict by value. See an example in CNM4RSAM member CICS030.
The response time is in microseconds so code:

RANGE CICS PERFORMANCE TRANSACTION C_RESPTIME_TM 1000000+

Additional Information

See the documentation on the RANGE Command