Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 2180
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: 10210
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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us