INFORMIX® Dynamic Server 7.X Utilities

Quick Reference Guide



After years of trying to find a manual to check the command line syntax of a utility, or scribbling notes to myself on scraps of paper with the command line options of the INFORMIX-OnLine utilities, I decided to make myself a quick reference guide. Several friends asked for copies, which resulted in the 5.X version. This guide is based on 7.23, and is meant to jog your memory. Some of the commands are very powerful so please use them with care. I hope this new version helps!
 
 
 
Lester Knutsen
Advanced DataTools Corporation
Email: lester@advancedatatools.com
www.advancedatatools.com

ONCHECK
Usage:  oncheck [-clist] [-plist] [-qny] [ { database[:[owner.]table[,fragdbs|#index]]
        | TBLspace number | Chunk number } { rowid | page number } ]
        -c  Check
                r  Reserved pages
                e  Extents
                c  Database catalogs [database]
                i  Table indexes database[:[owner.]table[#index]]
                I  Table indexes and rowids in index database[:[owner.]table[#index]]
                d  TBLspace data rows including bitmaps database[:[owner.]table[,fragdbs]]
                D  TBLspace data rows including bitmaps, remainder pages and BLOBs database[:[owner.]table[,fragdbs]]
        -p Print
                r  Reserved pages (-cr)
                e  Extents report (-ce)
                c  Catalog report (-cc) [database]
                k  Keys in index (-ci) database[:[owner.]table[#index]]
                K  Keys and rowids in index (-cI) database[:[owner.]table[#index]]
                l  Leaf node keys only (-ci) database[:[owner.]table[#index]]
                L  Leaf node keys and rowids (-cI) database[:[owner.]table[#index]]
                d  TBLspace data rows (-cd) database[:[owner.]table[,fragdbs]][rowid]
                D  TBLspace data rows including bitmaps, remainder pages and BLOBs (-cD) database[:[owner.]table[,fragdbs]] [page number]
                t  TBLspace report database[:[owner.]table[,fragdbs]]
                T  TBLspace disk utilization report database[:[owner.]table[,fragdbs]]
                p  Dump page for the given database[:[table[,fragdbs]] and rowid | TBLspace and page #]
                P  Dump page for the given chunk num and page num[chunk # and page #]
                B  BLOBspace utilization for given table(s) database[:[owner.]table[,fragdbs]]
        -q     Quiet mode - print only error messages
        -n     Answer NO to all questions
        -y     Answer YES to all questions


ONINIT
Usage:  oninit [-i] [-p] [-s] [-y]
        -i Disk space initialization
        -p Do not delete temp tables during shared memory initialization
        -s Stay in quiescent mode


ONLOAD
Usage:  onload [-l] [-t <tape device>] [-b <block size>] [-s <tape size>] [-d <DBspace>]
        <database>[:[<owner>.]<table>] [{-i <old indexname> <new indexname>}]
        [{-fd oldDBspname newDBspname}] [{-fi indexname oldDBspname newDBspname}]
        -l Use logical log tape configuration
        -t Tape devices
        -b Tape block size
        -s Tape size
        -d DBspace name
        -i Rename index during load


ONLOG
Usage:  onlog [-l] [-q] [-b] [-d <tape device>] [-n <log file number>] [-u <user name>] 
        [-t <TBLspace number>] [-x <transaction number>]
        -l Display maximum information about each log record
        -q Do not display program header
        -b Display information about logged BLOB pages (-d option only)
        -d Read from tape device
        -n Display the specified log(s)
        -u Display the specified user(s)
        -t Display the specified TBLspace(s)
        -x Display the specified transaction(s)


ONMODE
Usage:  onmode -abcDdFklMmnpQRrSsuyZz
        -a  <kbytes> Increase shared memory segment size
        -b  <version> Revert OnLine disk structures
        -c Do checkpoint
        -D <max PDQ priority allowed>
        -d {standard|{primary|secondary <servername>}} set DR server type
        -F Free unused memory segments
        -k Shutdown completely
        -l Force to next logical log
        -M <decision support memory in kbytes>
        -m Go to multi-user on-line
        -n Set shared memory buffer cache to non-resident
        -O Override dbspace down blocking a checkpoint
        -p  <+-#> <class>   Start up or remove virtual processors of class cpu, aio, lio, pio, shm, soc, or tli
        -Q <max # decision support queries>
        -R Rebuild the /INFORMIXDIR/etc/.infos.DBSERVERNAME file
        -r Set shared memory buffer cache to resident
        -S <max # decision support scans>
        -s Shutdown to single user
        -u Shutdown and kill all attached sessions
        -y Do not require confirmation
        -Z  <address> heuristically complete specified transaction
        -z  <sid>   Kill specified session id


ONPARAMS
Usage:  onparams { -a -d DBspace [-s size] | -d -l logid [-y] |-p -s size [-d DBspace] [-y] }
        -a Add a logical log
        -d Drop a logical log
        -p Change physical log size and location
        -y Answer YES to all questions


ONSPACES
Usage:  onspaces  { -a spacename -p pathname -o offset -s size [-m path offset] |
        -c {-d DBspace [-t] | -b BLOBspc -g pagesize} -p pathname -o offset -s size [-m pathoffset]
        -d spacename [-p pathname -o offset] [-y] | 
        -f[y] off [DBspace-list] | on [DBspace-list] | 
        -m spacename {-p pathname -o offset -m path offset [-y] | 
        -f filename} | 
        -r spacename [-y] | 
        -s spacename -p pathname -o offset {-O | -D} [-y] }

        -a Add a chunk to a DBspace or BLOBspace
        -c Create a DBspace or BLOBspace
        -d Drop a DBspace, BLOBspace or chunk
        -f Change dataskip default for specified DBspaces
        -m Add mirroring to an existing DBspace or BLOBspace
        -r Turn mirroring off for a DBspace or BLOBspace
        -s Change the status of a chunk


ONSTAT
Usage:  onstat [-abcdfghklmpstuxzBCDFRX][-i] [-r seconds] [-o file] [infile]
        -a Print all information
        -b Print buffers
        -c Print configuration file
        -d Print DBspaces and chunks
        -f Print dataskip status
        -g MT subcommand (default: all)
                all Print all MT information
                ath Print all threads  
                wai Print waiting threads
                act Print active threads
                rea Print ready threads
                sle Print all sleeping threads
                spi Print spin locks with long spins
                sch Print VP scheduler statistics
                lmx Print all locked mutexes
                wmx Print all mutexes with waiters
                con Print conditions with waiters
                stk  <tid>   Dump the stack of a specified thread
                glo Print MT global information
                mem  <pool name|session id>   Print pool statistics
                seg Print memory segment statistics
                rbm Print block map for resident segment
                nbm Print block map for non-resident segments
                afr  <pool name|session id>   Print allocated pool fragments
                ffr  <pool name|session id>   Print free pool fragments
                ufr  <pool name|session id>   Print pool usage breakdown
                iov Print disk IO statistics by vp
                iof Print disk IO statistics by chunk/file
                ioq Print disk IO statistics by queue
                iog Print AIO global information
                iob Print big buffer usage by IO VP class 
                ppf  [<partition number> | 0]   Print partition profiles
                tpf  [<tid> | 0]   Print thread profiles
                ntu Print net user thread profile information
                ntt Print net user thread access times              
                ntm Print net message information
                ntd Print net dispatch information 
                nss  <session id>   Print net shared memory status
                nsc  <client id>    Print net shared memory status
                nsd Print net shared memory data
                sts Print max and current stack sizes
                dic Print dictionary cache information
                qst Print queue statistics
                wst Print thread wait statistics
                ses  <session id>   Print session information
                sql  <session id>   Print sql information
                dri Print data replication information
                pos Print /INFORMIXDIR/etc/.infos.DBSERVERNAME file
                mgm Print mgm resource manager information
                ddr Print DDR log post processing information
        -i Interactive mode
        -k Print locks
        -l Print logging
        -m Print message log
        -p Print profile
        -s Print latches
        -t Print TBLspaces
        -u Print user threads
        -x Print transactions
        -z Zero profile counts
        -B Print all buffers
        -C Print btree cleaner requests
        -D Print DBspaces and detailed chunk stats
        -F Print page flushers
        -R Print LRU queues
        -X Print entire list of sharers and waiters for buffers
        -r Repeat options every n seconds (default: 5)
        -o Put shared memory into specified file (default: onstat.out)
        infile  Use infile to obtain shared memory information


ONTAPE 
Usage:  ontape{ -a  | -c  | -l  | -p  | -r  [-D DBspace_list] | -s  [-L archive_level] 
        [-A database_list] [-B database_list] [-N database_list] [-U database_list]  }
        -a Automatic backup of logical logs
        -c  Continuous backup of logical logs
        -l  Logical restore
        -p  Physical restore for HDR
        -r  Full restore DBspaces/BLOBspaces as listed
        -s  Archive full system
        -A  Set the following database(s) to ansi logging
        -B  Set the following database(s) to buffered logging
        -N  Set the following database(s) to no logging
        -U  Set the following database(s) to unbuffered logging


ONUNLOAD
Usage:  onunload [-l] [-t <tape device>] [-b <block size>] [-s <tape size>] <database>  [:[<owner>.]<table>]
        -l Use logical log tape configuration
        -t Tape devices
        -b Tape block size
        -s Tape size

 
Lester Knutsen
Advanced DataTools Corporation
Email: lester@advancedatatools.com
www.advancedatatools.com