DATAQUERY SQL query PLAN creation

Products

• Datacom

Issue/Introduction

Does Dataquery create a PLAN in Datacom Datadictionary ( DATA-DICT ) for an SQL query that is executed in CICS?

If so, is that PLAN kept after execution of the query ?

Environment

z/OS

z/VSE 

Dataquery

Resolution

An SQL PLAN is created when the execution starts . That PLAN is a temporary plan as it gets deleted when logging off from Dataquery .

In CICS, the plan name is DQ +termid +P  where termid is the terminal identification in CICS .

Additional Information

See SQL Plan Options if you want to override default PLAN options.