CA SYSVIEW ERPT247E INVALID IDENTIFIER SPECIFIED report CICS response time

book

Article ID: 195914

calendar_today

Updated On:

Products

CA SYSVIEW Performance Management

Issue/Introduction

Attempting to write a CA 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. 

Environment

Release : 16.0

Component : Explore Report Writer for CA-SYSVIEW/E

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 documentation on the RANGE Command