Formatter for SYSTABLES PACKED_DESC ?

[JoKlassen]

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

[Serge Rielau]

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

[Jan M. Nelken]

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

[JoKlassen]

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

[JoKlassen]

Thanks alot. That's what I was looking for.

Joachim

[Serge Rielau]

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