Why do I receive a -553 doing a DB L report and the SQLID on the main panel has an SQLID which is a secondary authorization ID;
DSNT408I SQLCODE = -553, ERROR: SECID SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS FOR REQUESTED OPERATION
.
In order to use Secondary Authorization ID's, the DB2 exit DSN3@ATH must be customized to allow for secondary authorization ID usage
as documented by IBM
IBM DB2 V12 doc on DSN3@ATH: