Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to select the PLAN for a given table ex: FIRM_TABLE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Feb 10, 2009 3:10 pm    Post subject: How to select the PLAN for a given table ex: FIRM_TABLE
Reply with quote

Dear Experts,

My problem is to find the PLAN name for the given tablename with the help of SYSIBM.* tables

Below is the situation:
a) I don't have a DBA to contact for more details
b) No Co-workers on Mainframe platform (Distributes environment)
c) I have to run few jobs and then provide few report to my down-stream system

Please help me out in resoving this ASAP.

Looking for your reply on this.
Back to top
View user's profile Send private message

Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Tue Feb 10, 2009 3:59 pm    Post subject:
Reply with quote

The following query provides the list of plans used by the table.

Code:
SELECT DNAME FROM SYSIBM.SYSPLANDEP WHERE BNAME = 'tbname';
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Feb 10, 2009 4:46 pm    Post subject: Reply to: How to select the PLAN for a given table ex: FIRM_
Reply with quote

Hi Srihari,

This query returns 0 rows.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Feb 10, 2009 5:10 pm    Post subject: Re: How to select the PLAN for a given table ex: FIRM_TABLE
Reply with quote

mkk157 wrote:
Below is the situation:
a) I don't have a DBA to contact for more details
b) No Co-workers on Mainframe platform (Distributes environment)
Which planet do you work at?

P.S.: Pardon my rudeness if it is in any way...
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Feb 10, 2009 7:42 pm    Post subject: Hi Anuj
Reply with quote

Anuj,

I'm from INDIA
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Tue Feb 10, 2009 9:16 pm    Post subject:
Reply with quote

No Problem Anuj,
But, It happens sometimes. (Ex: My Case)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Feb 11, 2009 1:38 am    Post subject:
Reply with quote

Hello,

Are you able to read the table using SPUFI?
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Wed Feb 11, 2009 11:49 am    Post subject:
Reply with quote

Dick,

SPUFI is not there.
But QMF is there I'm able to read the table.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2285
Location: @my desk

PostPosted: Wed Feb 11, 2009 1:12 pm    Post subject:
Reply with quote

mkk157,

How about selecting this?
Code:
SELECT GRANTEE
  FROM SYSIBM.SYSTABAUTH
 WHERE TTNAME = 'your-table-name'
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Wed Feb 11, 2009 2:32 pm    Post subject:
Reply with quote

No Arcvns,

It didn't work.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Wed Feb 11, 2009 2:40 pm    Post subject: Reply to: How to select the PLAN for a given table ex: FIRM_
Reply with quote

let' s clear the terminology a bit...

rough approach on

the hierarchy is ... program ==> table
( a program accesses the table )

during the compilation process an entity is created to make DB2 aware of what is happening
program ==> dbrm ==> plan/package

so quering the db2 system tables with the relation plan/tables
will yeld nothing useful...

just all the plans that are accessing that table

what are You using to create the reports ???
a program, if so ask support on the documentation for that program

otherwise if You are using qmf no need for a specific plan
QMF has already built the sructure to access any db2 table
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us