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
 

 

DB2 Package Location & Contents

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

New User


Joined: 01 Mar 2008
Posts: 49
Location: kolkata

PostPosted: Tue Jul 12, 2011 11:34 pm    Post subject: DB2 Package Location & Contents
Reply with quote

Hi,
We know that DB2 package resides in DB2 directory and it is not accessible by SQL query.

Is there any way to browse the DB2 directory ? so that I can see the packages even if they are not in readable format.

If it is installation specific any sample location may help me to find my location because most of the location format file naming convention is same in DB2 throughout the sites.

Thanks
Prasun
Back to top
View user's profile Send private message

daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 646
Location: Pennsylvania

PostPosted: Wed Jul 13, 2011 12:07 am    Post subject:
Reply with quote

A list of packages can be found in table: SYSIBM.SYSPACKAGE

A list of the Package Statements can be found in table: SYSIBM.SYSPACKSTMT

I hope this helps...
Back to top
View user's profile Send private message
prasun dhara

New User


Joined: 01 Mar 2008
Posts: 49
Location: kolkata

PostPosted: Wed Jul 13, 2011 10:25 am    Post subject: Reply to: DB2 Package Location & Contents
Reply with quote

Sorry daveporcelan.

SYSIBM.SYSPACKAGE & SYSIBM.SYSPLAN are the DB2 catalog. These DB2 catalog contains information about DB2 packages and plans but actual package and plans are stored in DB2 directory.

Thanks
Prasun
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Jul 13, 2011 10:44 am    Post subject:
Reply with quote

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z10.doc.intro/src/tpc/db2z_directory.htm
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jul 13, 2011 1:03 pm    Post subject:
Reply with quote

prasun dhara,

Quote:
Is there any way to browse the DB2 directory ? so that I can see the packages even if they are not in readable format.

Can i ask you why ?

Thanks,
Sushanth
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 646
Location: Pennsylvania

PostPosted: Wed Jul 13, 2011 5:28 pm    Post subject:
Reply with quote

As the saying goes, 'you learn something everyday'. This was my 'something' for today.

In my many years, of working with DB2 and Packages, I never knew that.

For that matter, I never needed to.

Which leads to my question, what information is in this directory that you need to see?

How is this information helpful?
Back to top
View user's profile Send private message
prasun dhara

New User


Joined: 01 Mar 2008
Posts: 49
Location: kolkata

PostPosted: Wed Jul 13, 2011 10:41 pm    Post subject: Reply to: DB2 Package Location & Contents
Reply with quote

PeterHolland,
Following DB2 Directory tablespace are used to store package & plans
SCT02
Quote:
Contains the internal form of SQL statements that are contained in an application. If you bound a plan with SQL statements in a prior release, DB2 created a structure in SCT02.

SPT01
Quote:
Skeleton package
Contains the internal form of SQL statements that are contained in a package


Now My question is there anyway to bows the content of these directory tablespace ?

Quote:
Can i ask you why ?


knowing the DB2 internal architecture/functioning in a better way.It's for learning.

Thanks
Prasun
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jul 14, 2011 11:18 am    Post subject:
Reply with quote

prasun,

You can start looking into DSN1PRNT offline utility.

And do let us know what you find ?

Thanks,
Sushanth
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 JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Mainframe opening for 3 to 10 yrs exp... Placementatpune Mainframe Jobs 0 Tue Jul 05, 2016 12:02 pm
No new posts Consolidating and summing file contents Kevin Lindsley SYNCSORT 14 Thu Jun 09, 2016 5:24 am
No new posts Read contents of PS file scorp_rahul23 JCL & VSAM 3 Mon Mar 28, 2016 10:28 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm


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