User getting SQLCODE -592 / SQLSTATE 42510 when creating a stored procedure

book

Article ID: 197889

calendar_today

Updated On:

Products

CA Top Secret CA Top Secret - LDAP CA Web Administrator for Top Secret

Issue/Introduction

A signon which was used to create a native SQL procedure, gets a SQLCODE -592 and SQLSTATE 42510, with an error message as follows:

SQL0969N  There is no message text corresponding to SQL error "-592" in the message file on this workstation.  The
error was returned from module "DSNXIVNO" with original tokens "TESTDB2".  SQLSTATE=42510

TESTDB2 is the value of the ZPARM WLMENV parameter for the data sharing group.

There are two members - DBA1 and DBA2 - and the id has access to both - permits to DB2(DSNR.DBA1.) and DB2(DSNR.DBA2.)


Environment

Release : 16.0

Component : CA Top Secret for z/OS

Resolution

permit datasharing group
DSNR. Formatting

When used with TSS PERMIT/REVOKE, this resource class has the following format:

TSS PERMIT(acid) DB2(DSNR.ssss.BATCH)

TSS PERMIT(acid) DB2(DSNR.ssss.DIST)

TSS PERMIT(acid) DB2(DSNR.ssss.MASS)

TSS PERMIT(acid) DB2(DSNR.ssss.SASS)

TSS PERMIT(acid) DB2(DXT.dddd)

TSS PERMIT(acid) DB2(DSNR.ssssssss.WLMENV.wlm_environment)

DSNR
Class name provided for a DB2 resource for DB2 and subsystem connection.

ssss
The site's subsystem name for DB2.

For sites using stored procedures in a data sharing environment the content of ssss may refer to the DB2 groupname rather than the subsystem name.

BATCH
For BATCH and TSO connections.

DIST
For Distributed Data Facility (DDF).

MASS
For IMS connection.

SASS
For CICS connection.

DXT
For access to data elements through the Data Extract Utility.

dddd
One to four character data element (file, PCB, view).

Prefix length
One to forty-four characters per prefix

Capacity of list
One to five prefixes per TSS command