Hello All,

I want a script that will allow me to:
a) Enter a chunk number and then display all tables in that chunk
or
b) Enter a table name and then display chunk names/numbers where that
table has an extent.

Oncheck -pe gives too much information as does oncheck -pT, and my
knowledge of awk/perl etc. is pretty rudimentary.

I've been playing with Sysmaster for hours, trying to connect
systabextents (which has a te_physaddr field) to syschkextents (which
has a ce_physaddr field)
but I just can't make it work. So if someone could explain how one of
the systab* tables connects to the syschunk* tables that would be
grand.

I'm using 7.31.UC6 on Solaris 7

Thanks for any help,
Chris Bullivant

"Chris Bullivant" <cbullivant@orange.net.au> wrote in message news:21e62a09.0405022240.6d405f10@posting.google.c om...
> Hello All,
>
> I want a script that will allow me to:
> a) Enter a chunk number and then display all tables in that chunk
> or
> b) Enter a table name and then display chunk names/numbers where that
> table has an extent.
>
> Oncheck -pe gives too much information as does oncheck -pT, and my
> knowledge of awk/perl etc. is pretty rudimentary.
>
> I've been playing with Sysmaster for hours, trying to connect
> systabextents (which has a te_physaddr field) to syschkextents (which
> has a ce_physaddr field)
> but I just can't make it work. So if someone could explain how one of
> the systab* tables connects to the syschunk* tables that would be
> grand.
>
> I'm using 7.31.UC6 on Solaris 7


I have a tool in iiug (http://www.iiug.org/software/index_DBA.html)
called listtabchunk. Looks like the version in iiug is sligthly old.
You can contact me at this email address for the latest version.
It is in 'C' and it displays lot of information about a chunk/dbspace.

$ listtabchunk
usage: listtabchunk [-s server] -c chunk_path|[-a]|[-d dbspace][-o offset][-S][-m][-t][-i][-p]
-s server_name. If not specified, then INFORMIXSERVER will be used
Remote server can be specified, provided trust relationship exists
between the client and the server.
-c chunk_path
-o chunk offset. If not specified, then all offsets for that chunk
will be printed
-a for all chunks
-d for all chunks of a dbspace
-m print summary report only
-S print database system tables also in the report
**warning**: this option will increase the report size considerably
-t restrict the report to only tables
-i restrict the report to only indexes
-p page size. List only those tables/index which consumes at least this many pages
version 2.2 date 07-Nov-2003 Ravi Krishna srkrishna@yahoo.com


$ listtabchunk -c /ifmxdata1/ifmx_flx4/thnold.chunk1
Date: 2004-05-03 06:04:16 listtabchunk for server ifmx_flx4
__________________________________________________ _______________________
Chunk : /ifmxdata1/ifmx_flx4/thnold.chunk1
Offset : 0
Assigned to dbspace : thnold
+------------------------------------------------------------------------------+
|DATABASE |TABLE / INDEX |Size(Pg) |
+------------------------------------------------------------------------------+
|thn_old_contracts |T:dba.air_block | 1000|
|thn_old_contracts |T:dba.con_history | 50000|
|thn_old_contracts |T:dba.interline | 25000|
|thn_old_contracts |T:dba.stopover | 25000|
|thn_old_contracts |T:dba.zone_city | 35000|
|thn_old_contracts |T:dba.zone_flight | 25000|
+------------------------------------------------------------------------------+
Summary: Number of tables: 6
Number of Index : 0
================================================== =============================

You can also restrict your output to only those tables/index which consumes
a minimum number of pages for a quick way of finding big tables/index in
a given chunk.