Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

where actualy plan is stored

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

New User


Joined: 11 Mar 2005
Posts: 1

PostPosted: Mon Mar 14, 2005 8:28 pm    Post subject: where actualy plan is stored
Reply with quote

i want to know where actualy a plan is stored
Back to top
View user's profile Send private message

i413678
Currently Banned

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Tue Mar 15, 2005 11:40 am    Post subject:
Reply with quote

hi,

plan is stored in SYSIBM.SYSPLANS table and you can access these details by using the select statement.

cheer................

pavan
Back to top
View user's profile Send private message
Souvik.Sinha

New User


Joined: 22 Apr 2005
Posts: 24
Location: New York, USA

PostPosted: Tue Apr 26, 2005 11:20 am    Post subject:
Reply with quote

Sravan,
I believe that the correct name is SYSIBM.SYSPLAN. You can verify that by running a select query in SYSIBM.SYSTABLES.
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Tue Apr 26, 2005 11:36 am    Post subject: Re: where actualy plan is stored
Reply with quote

Souvik is correct. SYSIBM.SYSPLAN

Regards,

Priyesh.
Back to top
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Tue Apr 26, 2005 2:27 pm    Post subject:
Reply with quote

Hi,

Please refer to the article on Plans and access paths http://www.mainframeweek.com/journals/articles/0033/DB2+PLAN_TABLE+-+access+and+maintenance,+part+1

Thanks,
Reddy.
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 Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 6 Thu Oct 27, 2016 10:20 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us