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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts A sample of exit program for exit XMN... lind sh CICS 2 Mon Oct 03, 2016 5:07 pm


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