S0001 SCINIT: WARNING NO STMTS PLAN SYSADM.SQLSCPLAN

Products

• Datacom
• DATACOM - AD

Issue/Introduction

Last month I migrated CA Datacom AD from version 14.0 to 15.0 .
I have had no problems during the migration and all MUFs  work fine!
Since that migration I have following messages after MUF startup  under the STC DDName PXXSQL01:

********************************* TOP OF DATA ******************
S0001 DBSRPPR: Initializing Source Cache
S0001 SCINIT: WARNING NO STMTS PLAN SYSADM .SQLSCPLAN
S0001 SCINIT: Copied 0 Queries from Disk. Next stmtId = 0
S0001 SCINIT: Source Cache Initialized
******************************** BOTTOM OF DATA ****************

Is this normal in Release 15.0?

Environment

z/OS  
CA Datacom SQL 15.x 
CA Datacom/AD 15.0   

Resolution

Yes, those messages are normal with Datacom version 15.0.
We write those messages during the Multi-User startup so that we have a quick way to check if the SQL Source Cache got successfully initialized.

The SQL Source Cache is is a collection of previously executed dynamic queries from CA Datacom® Server and the SQL batch utility DBSQLPR. Queries that are stored in the SQL Source Cache and match new queries reduce the preparation (bind) cost. Statistics that are accumulated for these queries allow inefficient queries to be identified.

 

Additional Information

You can read about the SQL Source Cache here https://docops.ca.com/ca-datacom/15-0/en/getting-started/getting-started-with-sql-in-ca-datacom/sql-source-cache