Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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
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
References
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: 15
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

Global Moderator


Joined: 28 Mar 2005
Posts: 1509
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: 200
Location: Keane India Ltd., Hyderabad
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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1