DSNT408I SQLCODE -592 using ACF2 for Db2 CREATE FUNCTION

Products

• ACF2 - z/OS
• ACF2
• ACF2 - MISC

Issue/Introduction

When executing CREATE FUNCTION DDL in Db2 the following error is seen: 

DSNT408I SQLCODE = -592, ERROR:  NOT AUTHORIZED TO CREATE OR ALTER FUNCTIONS,
         PROCEDURES, OR TRIGGERS IN WLM ENVIRONMENT xxxxxxxx
DSNT418I SQLSTATE   = 42510 SQLSTATE RETURN CODE
DSNT415I SQLERRP    = DSNXIVRO SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD    = 160 0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD    = X'000000A0'  X'00000000'  X'00000000'  X'FFFFFFFF'
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+

This is being returned when running under a SYSADM ID which should have all privileges allowed in Db2. Why is this security error occurring?

Resolution

After running an ACF2 SECTRACE, the RACROUTE REQUEST=VERIFY ENVIR=CREATE indicated SFR/RFR= 8/4:0 which means that the logonid does not exist in ACF2.

A logonid in ACF2 needs to be created for the user to resolve the error message.