To know the PLAN name for a particular data base



IBM's flagship relational database management system

To know the PLAN name for a particular data base

Postby chinkump » Sat Aug 17, 2013 6:33 pm

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
chinkump
 
Posts: 26
Joined: Fri Jan 20, 2012 10:48 pm
Has thanked: 3 times
Been thanked: 0 time

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

 

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

Postby Akatsukami » Sat Aug 17, 2013 8:24 pm

You completely misunderstand the concept of "plan"; go read about it until you do understand it.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

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

Postby chinkump » Thu Aug 22, 2013 10:11 pm

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
chinkump
 
Posts: 26
Joined: Fri Jan 20, 2012 10:48 pm
Has thanked: 3 times
Been thanked: 0 time

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

Postby Akatsukami » Thu Aug 22, 2013 10:42 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

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

Postby chinkump » Fri Aug 23, 2013 12:20 am

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.
chinkump
 
Posts: 26
Joined: Fri Jan 20, 2012 10:48 pm
Has thanked: 3 times
Been thanked: 0 time

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

Postby dick scherrer » Fri Aug 23, 2013 12:29 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post