Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
User Remarks in Plan_Table

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message

New User

Joined: 11 Jan 2006
Posts: 61
Location: Lower Saxony (DE)

PostPosted: Fri Oct 26, 2018 2:30 pm    Post subject: User Remarks in Plan_Table
Reply with quote

Hi there everybody,

analyzing and explaining access paths is a very helpful feature and I use it a lot.
It’s easy to explain any SQL statements in a program by using the “EXPLAIN(YES)” clause when (re-) binding a package.
And It’s easy as well using the EXPLAIN ALL (SET QUERYNO = 12345) FOR statement for analyzing a single spufi query.
Particularly the second method I use a lot.

Some days ago – when creating a Plan_Table (with its tablespace, its indexes etc.), I recognized there is a remarks column in this table. According to the manuals this column is sometimes used when there are some ‘certain situations’ during package bind. But the manuals say furthermore the column can be used for ‘my own remarks’:
A field into which you can insert any character string...

Is there a special statement / clause / option / parameter to store user remarks in this column (when explaining a single query)?
Or is the only way to do so by manually updating the column after storing the explain results? This would be very awkward ‘cause first I would have to determine the keys / EXPLAIN_TIME timestamp for updating (only) the relevant rows.

IMO, the most elegant way would be a phrasing like
  SET   QUERYNO =  12345
      , REMARKS = ‘The query I am examine’

But I guess, a statement options like this might be an illusion… :-(

Thank you very much for your hints, ideas, ...
Back to top
View user's profile Send private message

View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts User Cancels the job PANDU1 DB2 1 Sat Mar 04, 2017 8:21 pm
No new posts SORT - E15 and E35 using same user ex... Abhi Nature DFSORT/ICETOOL 12 Mon Oct 03, 2016 4:33 pm

Back to Top
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us