Map Table to Chunks

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.com... > 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.chunk1Date: 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.