IBM Mainframe Forum

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

You completely misunderstand the concept of "plan"; go read about it until you do understand it.

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

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.

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.

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.