MAINFRAME FORUM: where actualy plan is stored

Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD

where actualy plan is stored

IBMMAINFRAMES.com Support Forums -> DB2

Author

Message

sravankumar

New User

Joined: 11 Mar 2005
Posts: 1

Posted: Mon Mar 14, 2005 8:28 pm Post subject: where actualy plan is stored

i want to know where actualy a plan is stored

Send private message

References

Posted: Mon Mar 14, 2005 8:28 pm Post subject: Re: where actualy plan is stored

i413678
Currently Banned
Active User

Joined: 19 Feb 2005
Posts: 112
Location: chennai

Posted: Tue Mar 15, 2005 11:40 am Post subject:

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

Send private message

Souvik.Sinha

New User

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

Posted: Tue Apr 26, 2005 11:20 am Post subject:

Sravan, I believe that the correct name is SYSIBM.SYSPLAN. You can verify that by running a select query in SYSIBM.SYSTABLES.

Send private message

priyesh.agrawal

Global Moderator

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

Posted: Tue Apr 26, 2005 11:36 am Post subject: Re: where actualy plan is stored

Souvik is correct. SYSIBM.SYSPLAN Regards, Priyesh.

Send private message

ovreddy

Active User

Joined: 06 Dec 2004
Posts: 200
Location: Keane India Ltd., Hyderabad

Posted: Tue Apr 26, 2005 2:27 pm Post subject:

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.

Send private message

Display posts from previous:

IBMMAINFRAMES.com Support Forums -> DB2

All times are GMT + 6 Hours

Page 1 of 1