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
 

 

Identify the tables used in the particular program

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

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Thu Oct 18, 2007 11:54 am    Post subject: Identify the tables used in the particular program
Reply with quote

Hi friends

I have a query in DB2

I was given the dbrmname, package name & plan name

without looking at the program
Is there any way to identify the tables used in the particular program
( i.e using sysibm tables)



Thanks n Regards
Prasad
Back to top
View user's profile Send private message

hemanth.nandas

Active User


Joined: 18 Aug 2007
Posts: 120
Location: Chennai

PostPosted: Thu Oct 18, 2007 12:00 pm    Post subject:
Reply with quote

Hi Prasad,

Quote:
was given the dbrmname, package name & plan name



Let Us know where were you giving these names without refering PGM.

Without PGM How will you use these names in your scenario icon_question.gif
Back to top
View user's profile Send private message
nuthan

Active User


Joined: 26 Sep 2005
Posts: 146
Location: Bangalore

PostPosted: Thu Oct 18, 2007 12:17 pm    Post subject:
Reply with quote

Prasad,
let us know any particlaur reason for not looking in to the program.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Thu Oct 18, 2007 1:22 pm    Post subject:
Reply with quote

The following queries will return the list of objects used by a plan and package respectively. Check the link given below for more information.

select * from sysibm.syspackdep where dname='package';
select * from sysibm.sysplandep where dname='plan';

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/zpldep.htm
Back to top
View user's profile Send private message
sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Thu Oct 18, 2007 4:05 pm    Post subject:
Reply with quote

Hi Srihari,

have u tried the query.

I have tried but its not working.

Cmd Column Name Selection Criteria
--- ------------------ -----------------------------------------------------
*** ********************************* TOP ***********************************
___ BNAME
___ BQUALIFIER ='DB2TUNT'
___ BTYPE ='T'
___ DLOCATION
___ DCOLLID
___ DNAME ='PGMNAME'
___ DCONTOKEN
___ IBMREQD
___ DOWNER
___ DTYPE
*** ******************************* BOTTOM


If plan is specified for DNAME,then i did not get any results.

i know that DNAME="pgmname' will give the tables used.i have tested this also n getting the results.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Thu Oct 18, 2007 5:48 pm    Post subject:
Reply with quote

Sri,
I tried both the queries before posting.

And for SYSIBM.SYSPLANDEP, As per the description for SYSIBM.SYSPLANDEP, the DNAME should be plan name.

Might be, in your case, Program name and plan name are same. Please check the link I have given.
Back to top
View user's profile Send private message
sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Thu Oct 18, 2007 6:12 pm    Post subject:
Reply with quote

Hi srihari,

here Pgm name and plan name are different.i have tried syspackdep(that i have shown in my prev mail).
Back to top
View user's profile Send private message
omnamashiva

New User


Joined: 24 Sep 2007
Posts: 10
Location: chennai

PostPosted: Thu Oct 18, 2007 9:14 pm    Post subject: Reply to: Identify the tables used in the particular program
Reply with quote

Hi friends,
Answer quite simple friend, you know the DBRMlib name , go to DBRM lib mostly it be PDS , (something like unit.DBRMLIB etc) , Open the particular DBRM member(ie mostly it will be your PGM name), you will be able to what all the tables used in that program , with CONTOKEN token(when pgm binded) etc..
Let me know if you need further information

Regards,
Arunchalla
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 Could we identify the called modules ... elixir1986 COBOL Programming 5 Fri Jul 14, 2017 1:53 am
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm


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