On Mon, 24 Nov 2025 19:40:26 +0200, Binyamin Dissen <[email protected]> wrote:
>Direct an EXPLAIN command. Since you can't use SET SQLID, then your limited to environments where you can provide an alternate ACEE. I'm not a fan of these solutions but you do what you gotta do. 1. Never tried it but maybe DB2 honors the ACEE for the current TCB. Attach new TCB (possibly JSTCB), SAF call to create ACEE for this TCB, execute explain and terminate TCB. 2. If DB2 TCP CONNECT has been setup, then you specify the userid/password for the connection. 3. If EXPLAIN is supported in CICS and EXCI (external CICS call) supports userid, you could write a CICS transaction. 4. WTOR to wait, submit a batch job and automation to reply to the WTOR when job completes. 5. UNIX SUDO. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
