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 ] [-b ] [-s ] [-d ] [:[.]] [{-i }] [{-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 ] [-n ] [-u ] [-t ] [-x ] -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 Increase shared memory segment size -b Revert OnLine disk structures -c Do checkpoint -D -d {standard|{primary|secondary }} set DR server type -F Free unused memory segments -k Shutdown completely -l Force to next logical log -M -m Go to multi-user on-line -n Set shared memory buffer cache to non-resident -O Override dbspace down blocking a checkpoint -p <+-#> Start up or remove virtual processors of class cpu, aio, lio, pio, shm, soc, or tli -Q -R Rebuild the /INFORMIXDIR/etc/.infos.DBSERVERNAME file -r Set shared memory buffer cache to resident -S -s Shutdown to single user -u Shutdown and kill all attached sessions -y Do not require confirmation -Z
heuristically complete specified transaction -z 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 Dump the stack of a specified thread glo Print MT global information mem Print pool statistics seg Print memory segment statistics rbm Print block map for resident segment nbm Print block map for non-resident segments afr Print allocated pool fragments ffr Print free pool fragments ufr 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 [ | 0] Print partition profiles tpf [ | 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 Print net shared memory status nsc 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 Print session information sql 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 ] [-b ] [-s ] [:[.]
] -l Use logical log tape configuration -t Tape devices -b Tape block size -s Tape size