|
View previous topic :: View next topic
|
| Author |
Message |
prasun dhara
New User
Joined: 01 Mar 2008
Posts: 49
Location: kolkata
|
|
|
|
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 |
|
 |
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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 |
|
|
prasun dhara
New User
Joined: 01 Mar 2008
Posts: 49
Location: kolkata
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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 |
|
|
prasun dhara
New User
Joined: 01 Mar 2008
Posts: 49
Location: kolkata
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
prasun,
You can start looking into DSN1PRNT offline utility.
And do let us know what you find ?
Thanks,
Sushanth |
|
| Back to top |
|
|
|
|
