Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 How do you attach a DB2 plan to a CIC... John Poulakos DB2 0 Wed Apr 18, 2018 1:49 am
No new posts How do I define a DB2 plan for a web ... John Poulakos CICS 4 Sat Apr 14, 2018 1:58 am
No new posts CICS web service from DB2 Triggers or... kiranprasad DB2 2 Wed Dec 20, 2017 11:10 am
No new posts Finding the plan when code compiled u... Ahemad DB2 2 Fri Dec 01, 2017 6:38 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am

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