Page 1 of 1

To know the PLAN name for a particular data base

PostPosted: Sat Aug 17, 2013 6:33 pm
by chinkump
My requirement is to know the Plan name for a particular database table.Clarifying the details.
Consider an example COMPANY.EMPLOYEE
Company is database name and employee is table name. I want to find the plan name for the above.

Thanks,
Chinkump

Re: To know the PLAN name for a particular data base

PostPosted: Sat Aug 17, 2013 8:24 pm
by Akatsukami
You completely misunderstand the concept of "plan"; go read about it until you do understand it.

Re: To know the PLAN name for a particular data base

PostPosted: Thu Aug 22, 2013 10:11 pm
by chinkump
Mr Akatsukami..... I think you didnot understand what is the requirement. Please check SYSIBM.SYSPLAN table. Every database table will be tagged to a Plan name. Please refer the same and let me know if anything is not clear.

Thanks,
Chinkump

Re: To know the PLAN name for a particular data base

PostPosted: Thu Aug 22, 2013 10:42 pm
by Akatsukami
It is clear that you do not know whereof you speak. Possibly you are thinking of the SYSPLANDEP table. Even so, note that that table carries only the name of an object on which the plan depends, of which only table spaces are validly qualified by data base name.

Re: To know the PLAN name for a particular data base

PostPosted: Fri Aug 23, 2013 12:20 am
by chinkump
Mr Akatsukami the question is quiet clear.Please dont assume anything and open the SYSIBM.SYSPLAN table. Understanding of the issue is important rather than jumping into a solution or assuming something different. Database is here SYSIBM and table name is SYSPLAN. While testing and development there is always need of database creator and plan name.

Re: To know the PLAN name for a particular data base

PostPosted: Fri Aug 23, 2013 12:29 am
by dick scherrer
Hello,

Mr Akatsukami the question is quiet clear.
ONLY to you . . . Many do not find your post clear - i am one of these.

Understanding of the issue is important rather than jumping into a solution or assuming something different.
Yup, if/when you provide clarification, someone may be able to help.