Hi Binyamin,
We use SET CURRENT SCHEMA successfully with our inhouse explain tool.
It does something like:
SET CURENT SCHEMA = 'RON'
EXPLAIN PLAN.....
And puts the explain data into the RON.PLAN_TABLE etc.
Check that you have created all the explain tables.
Regards,
Ron
-----Original Message-----
From: IBM Mainframe Discussion List <[email protected]> On Behalf Of
Binyamin Dissen
Sent: Wednesday, 26 November 2025 7:30 AM
To: [email protected]
Subject: Re: DB2 query - is there a way to give a specific permission for a
user to SET CURRENT SQLID to another user?
On Tue, 25 Nov 2025 17:09:03 -0600 Jon Perryman <[email protected]> wrote:
:>On Tue, 25 Nov 2025 21:32:49 +0200, Binyamin Dissen
<[email protected]> wrote:
:>>The EXPLAIN got -219
:>What error messages were produced from GET DIAGNOSTICS?
:>Is SPUFI still a thing? Maybe it would be useful while you are prototyping.
If I remember correctly, it displays the diags.
:>Did you create the explain tables?
Did the SET SCHEMA
DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE DOES NOT EXIST
DSNT418I SQLSTATE = 00000 SQLSTATE RETURN CODE DSNT416I SQLERRD = 0 0 0
-1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000'
X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL
DIAGNOSTIC INFORMATION
The table exists under the the ID that I do a SET CURRENT SQLID.
SET SCHEMA was ignored for the EXPLAIN table name.
--
Binyamin Dissen <[email protected]>
http://www.dissensoftware.com/
Director, Dissen Software, Bar & Grill - Israel
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
[email protected] with the message: INFO IBM-MAIN
Unencrypted electronic mail is not secure and may not be authentic. If you have
any doubts as to the contents, please telephone to confirm. This electronic
transmission including any attachments is intended only for those to whom it is
addressed. It may contain copyright material or information that is
confidential, privileged or exempt from disclosure by law. Any claim to
privilege is not waived or lost by reason of mistaken transmission of this
information. If you are not the intended recipient, you must not distribute or
copy this transmission and should please notify the sender. Your costs for
doing this will be reimbursed by the sender. We do not accept liability in
connection with computer virus, data corruption, delay, interruption,
unauthorised access or unauthorised amendment.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
