IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

where actualy plan is stored
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
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
 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
 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
 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: 1448
Location: Chicago, IL
PostPosted: Tue Apr 26, 2005 11:36 am
 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
 Reply with quote
Hi,

Please refer to the article on Plans and access paths 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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
This topic is locked: you cannot edit posts or make replies. Internal Autonomous Stored Procedure ... DB2 6
No new posts Stored procedure cpu utilization DB2 1
No new posts current batch plan DB2 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us