IBM Support

SQLCODE922 executing EDIA under CICS Transaction Server.

Troubleshooting


Problem

WDI for z/OS CICS on-line transaction EDIA encounters DB2 SQLCODE = -922. Full Message as displayed to CICS user and as reported in CICS joblog: DSNT408I SQLCODE = -922, ERROR: AUTHORIZATION FAILURE: PLAN ACCESS ERROR. REASON 00F30034 DSNT418I SQLSTATE = 42505 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNAET03 SQL PROCEDURE DETECTING ERROR.

Cause

The CICS user lacks the needed DB2 plan authority.

Resolving The Problem

According to DB2 documentation, reason = 00F30034 is a plan access error, e.g. the user does not have authority to execute the plan. The CICS RCT entry for EDIA specifies the DB2 plan name. The default name is DIENU32C. Grant execute authority for the plan to the user via SPUFI command:

GRANT EXECUTE ON PLAN DIENU32C TO userid;

[{"Product":{"code":"SSFKTZ","label":"WebSphere Data Interchange"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"WDI 3.2 for z\/OS","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"3.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
01 August 2018

UID

swg21207204

Page Feedback