By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Formatter for SYSTABLES PACKED_DESC ?

P: n/a
Hi all,

I thought i heard of a tool which formats the contents of
SYSIBM.SYSTABLES column PACKED_DESC to a readable report. Does anybody
know this ?

TIA
Joachim

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Jo*******@email.com wrote:
Hi all,

I thought i heard of a tool which formats the contents of
SYSIBM.SYSTABLES column PACKED_DESC to a readable report. Does anybody
know this ?

TIA
Joachim

That's an internal tool meant for support. I'm not sure what good
formating the packed descriptors will do to you.
Note that there is nothing in the descriptor that's not in some form in
the reular catalogue columns.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
Jo*******@email.com wrote:
Hi all,

I thought i heard of a tool which formats the contents of
SYSIBM.SYSTABLES column PACKED_DESC to a readable report. Does anybody
know this ?

TIA
Joachim


Db2 UDB ships tool db2cat. Instruction how to use can be obtained by:

db2cat -h

Short description (from the help screen output:

This application analyzes the contents of the table packed descriptors.
Given a database name and other qualifying information, this tool will,
query the system catalogs for information and format the results.

Jan M. Nelken
Nov 12 '05 #3

P: n/a
I had this question from a customer: How do I find the staging table
for a MQT's in the system catalog ? My idea was that there might be a
reference to the staging table in the PACKED_DESC for the MQT's
SYSTABLES entry.

Joachim

Nov 12 '05 #4

P: n/a
Thanks alot. That's what I was looking for.

Joachim

Nov 12 '05 #5

P: n/a
Jo*******@email.com wrote:
I had this question from a customer: How do I find the staging table
for a MQT's in the system catalog ? My idea was that there might be a
reference to the staging table in the PACKED_DESC for the MQT's
SYSTABLES entry.

Joachim

The staging table is logged in syscat.tabdep.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.