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: 2276
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: 10255
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 unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm


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