Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Name Modified Size InfoDownloads / Week
Parent folder
listtabchunk.ec 2019-06-13 22.0 kB
listtabchunk.README 2019-06-13 1.4 kB
Totals: 2 Items   23.3 kB 0
This tool lists all tables and indexes residing in a chunk.
Basically it shows the output of oncheck -pe in a more
readable format.

To compile: esql -o listtabchunk listtabchunk.ec

usage:
listtabchunk [-s server] -c chunk_path|[-a]|[-d dbspace][-o offset][-S][-m][-t][-i]
       -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
 ---------------------------------------------------------------------
 Output of the tool is restricted to
   * database name first 18 characters. Name longer than 18 characters
   will be truncated with $ sign at the end of database name
   * owner name plus table/index name restricted to 45 characters. Name longer
   than 45 characters will be truncated with $ sign at the end of the table
   or index name
Source: listtabchunk.README, updated 2019-06-13