Datacom/DB SQL DBSRFPR syntax error

Products

• Datacom

Issue/Introduction

Datacom/DB SQL utility DBSRFPR job to rebind an SQL plan is failing with syntax error:

SYNTAX ERROR FOUND: CHECK PARAMETERS 

ECHO PRINT OF PARAMETER BEING PROCESSED:<PLAN> 

Environment

Datacom all versions 

Cause

Wrong value coded in DBSRFPR PARM.

In this case, the parameter being passed to DBSRFPR...

// PARM='PLAN authid.sqlname REBIND'

Resolution

Add character '=' after PLAN as shown below:       

// PARM='PLAN=authid.sqlname REBIND'

Additional Information

For documentation, see DBSRFPR Utility—SQL Upgrade Rebind.