SQL -553 during An Explain in SQLEASE
search cancel

SQL -553 during An Explain in SQLEASE

book

Article ID: 204206

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

 Enhanced Explain in SQLEASE received SQL-553 using the same id for secondary ID and Userid.

 

Environment

Release : 20.0

Component : CA SQL-Ease for DB2 for z/OS

Resolution

The problem was caused by incorrectly setting up the Current SQLID in the Global Parameters. Providing the correct SQLID resolved the problem.