View previous topic :: View next topic
|
Author |
Message |
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
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 |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
The following query provides the list of plans used by the table.
Code: |
SELECT DNAME FROM SYSIBM.SYSPLANDEP WHERE BNAME = 'tbname'; |
|
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Hi Srihari,
This query returns 0 rows. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Anuj,
I'm from INDIA |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
No Problem Anuj,
But, It happens sometimes. (Ex: My Case) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Are you able to read the table using SPUFI? |
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
Dick,
SPUFI is not there.
But QMF is there I'm able to read the table. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
mkk157,
How about selecting this?
Code: |
SELECT GRANTEE
FROM SYSIBM.SYSTABAUTH
WHERE TTNAME = 'your-table-name'
|
|
|
Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006 Posts: 310
|
|
|
|
No Arcvns,
It didn't work. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
|