informix ucm server guide
TRANSCRIPT
-
8/8/2019 Informix UCM Server Guide
1/20
INFORMIX-UniversalServer
Quick Reference Guide
Version 9.1
March 1997
Part No. 000-4803
-
8/8/2019 Informix UCM Server Guide
2/20
ii INFORMIX-Universal Server Quick Reference Guide
Published by INFORMIX Press Informix Software, Inc.4100 Bohann on Drive
Menlo Pa rk, CA 94025
Copyright 1981-1997 by Informix Software, Inc. or their subsid iaries, provid ed t hat p ortions m ay becopyrighted by third p arties, as set forth in docu mentation . All rights reserved.
The following are world wid e tradem arks of Informix Software, Inc., or its subsid iaries, registered in the
United States of America as ind icated by , and in num erous other countries world wid e:
INFORMIX; INFORMIX-OnLine Dynam ic Server ; DataBlade
The following are world wid e trademar ks of the indicated ow ners or their subsidiaries, registered in the
United States of America as ind icated by , and in num erous other countries world wid e:
Adob e Systems Incorporated: PostScript
X/ Open Company Ltd.: UNIX; X/ Open
All other marks or symbols are registered trad emarks or trad emarks of their respective owners.
Documen tation Team: Twila Booth, Beth Delson, Jennifer Leland
To the extent that th is software allows the u ser to store, disp lay, and oth erwise manip ulate variou s forms of
data , including, withou t limitation, multimed ia content such as photogra ph s, movies, music and oth er binarylarge objects (blobs), use of any single blob may p otentially infringe u pon nu merous d ifferent third-party
intellectual and / or prop rietary rights. It is the user's respon sibility to avoid infringements of any such third-party rights.
RESTRICTED RIGHTS/ SPECIAL LICENSE RIGHTS
Software and docum entation acquired w ith US Governm ent fund s are provided w ith rights as follows: (1) if
for civilian agen cy use, with Restricted Rights as d efined in FAR 52.227-19; (2) if for Dep t. of Defense use, withrights as restricted by vend or's standard license, unless superseded by negotiated ven dor license as prescribed
in DFAR 227.7202. Any w hole or par tial reprodu ction of software or d ocumen tation mar ked w ith this legendmust reprodu ce the legend.
-
8/8/2019 Informix UCM Server Guide
3/20
INFORMIX-Universal Server Quick Reference Guide 1
This qu ick reference guide lists the comm and -line utility options and
corresponding ON -Monitor options an d System Mon itoring Interface (SMI)
tables for performing rou tine Universal Server ad ministration tasks. For a
complete list of available utility comm and s, see the INFORMIX-Universal
Server Administrators Guide.
A separate table app ears for each of the following tasks:
s Initializing Un iversal Server and Changing Mod es (see page 6)
s Configu ring Un iversal Server (see page 7)s Modifying Universal Server Disk Structures (see page 9)
s Verifying Database Consisten cy (see page 12)
s Monitoring Universal Server (see page 14)
For information on the syn tax of comm and -line u tilities, refer to How to
Read th e Syntax Conventions on page 2.
In this m anu al, all instances of Universal Server refer to INFORMIX-Universal
Server.
Further Information
The following chapters of the INFORMIX-Universal Server Administrators
Guide contain more inform ation on mon itoring tasks, the ON -Monitor u tility,
th e SMI tables, and Universal Server comm and -line u tilities:
s Chap ter 33, Monitoring Universal Server
s Chapter 36, ON -Monitor
s Chap ter 39, Universal Server Utilities
s Chapter 38, The sysmaster Database
http://./3851.pdfhttp://./3851.pdfhttp://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://./3851.pdfhttp://./3851.pdfhttp://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://./3851.pdfhttp://./3851.pdfhttp://./3851.pdfhttp://./3851.pdf -
8/8/2019 Informix UCM Server Guide
4/20
2 INFORMIX-Universal Server Quick Reference Guide
How to Read the Syntax Conventions
The INFORMIX-Universal Server Performance Guide contains information on
th e onperfutility, a grap hical monitoring tool. You can perform m any of themon itoring tasks with this tool.
How to Read the Syntax Conventions
This quick reference guide u ses the following n otation conventions todescribe the syntax of comm and -line utility op tions:
abc Enter non italicized text exactly as sh own. For examp le, enter th e
following comm and just as it is, w ith no argum ents:
onstat -p
abc Substitu te a value for any item that ap pears in lowercase italics. In th e
following example, substitute a value for dbspace:
onparams -a -d dbspace
[ ] Do not enter brackets as part of a statement. They surrou nd any p art
of a statement that is optiona l. In the following examp le, you have
the op tion of specifying -d dbspace:
onparams -p -s size [-d dbspace]
{ } When you m ust choose only one of several options, the options are
enclosed in braces and are separated by vertical bars.
| The vertical bar ind icates a choice amon g tw o or m ore options. For
example,
{blobspace| dbspace}
means that you enter a v alue for blobspace or a valu e for dbspace.
... An ellipsis indicates that you could enter an ind efinite num ber of
add itional items such as the one imm ediately preceding the ellipsis.
The following example shows that you could enter an indefinite
nu mber of parameters as dbspace after choosing either ON or OFF:
onspaces -f {ON|OFF} [dbspace ...]
http://./4805.pdfhttp://./4805.pdf -
8/8/2019 Informix UCM Server Guide
5/20
INFORMIX-Universal Server Quick Reference Guide 3
Quick Reference Command-Line Utilities
Quick Reference Command-Line Uti litiesComm and -line utilities are described on th e pages shown in the following
table.
Command Reference
oncheck -cc page 13
oncheck -cd page 13
oncheck -cD page 13
oncheck -ce page 12
oncheck -ci page 12
oncheck -cI page 12
oncheck -cr page 12
oninit -i page 6
oninit -s page 6
onmod e -c page 6
onmod e -F page 6
onmod e -k page 6
onmod e -m page 6
onmod e -p page 7
onmod e -p - num ber CPU page 7
onmod e -s page 6
onmod e -u page 6
onp arams -a -d page 7
onparams -d page 7
onparams -p page 8
(1 of 3)
http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?- -
8/8/2019 Informix UCM Server Guide
6/20
4 INFORMIX-Universal Server Quick Reference Guide
Quick Reference Command-Line Utilities
onspaces -a page 9
onsp aces -c -b page 10
onsp aces -c -d page 10
onspaces -d pa ge 11
onspaces -f page 9
onspaces -m pa ge 11
onspaces -r pa ge 11
onspaces -s page 9
onstat page 16
onstat -b page 14
onstat -B page 14
onstat -c page 15
onstat -d page 14
onstat -D page 14
onstat -F page 14
onstat -g act page 16
onstat -g ath page 16
onstat -g dll page 15
onstat -g d ri page 15
onstat -g glo page 17
onstat -k page 15
onstat -l page 15
onstat -m Displays the m ost recent
lines of the system m essage log
page 15
Command Reference
(2 of 3)
http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?- -
8/8/2019 Informix UCM Server Guide
7/20
INFORMIX-Universal Server Quick Reference Guide 5
Quick Reference Command-Line Utilities
onstat -O page 16
onstat -p page 16
onstat -R page 14
onstat -s page 15
onstat -t page 16
onstat -u page 17
onstat -x page 16
onstat - X page 14
Command Reference
(3 of 3)
http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?-http://-/?- -
8/8/2019 Informix UCM Server Guide
8/20
6
INFORMIX-UniversalServerQuickReferenceGuide
Init ial izing Universal Server and Changing Modes From Command Line Using ON-Monitor
Force a checkpoint onmode -c Force-Ckpt option
Free unused shared memory onmode -F Non e available
Initialize di sk space and Universal Server shared
memory
oninit -i Parameters menu/ Initialize option
Initialize Universal Server shared memory only oninit -s Mode menu/ Startup op tion
Take Universal Server from quiescent mode to
on-line mode
onmode -m Mode menu/ On-Line option
Take Universal Server off-line onmode -k Mode m enu/ Take-Offline option
Take Universal Server from on-line mode to
quiescent mode immediately
onmode -u Mode menu/ Immediate-Shutdow n o
Take Universal Server from on-line mode to
quiescent mode gracefully
onmode -s Mode menu/ Graceful-Shu tdow n opt
-
8/8/2019 Informix UCM Server Guide
9/20
INFORMIX-UniversalServerQuickReferenceGu
ide
7
Configuring Universal Server From Command Line Using ON-Monitor Other
Add a logical-log file onparams -a -d dbspace [-s size]-a Adds a logical-log file
-d dbspace
Specifies the dbspace in w hich
the logical-log file is located
-s size
Specifies the size of the new
logical-log file
Parameters menu /Add -Log op tion EditONCONFIG
directly an d rei
shared memory
Add virtual processors onmode -p (+ number{CPU | AIO |
SHM | TLI | SOC})
-p + number
Indicates how m any virtual
processors of the sp ecified class
to add
Mode menu/ Add-Proc
option
Edit ONCONFIG
directly an d rei
shared memory
D rop a logical-log file onparams -d -l logid
-d Drop s a logical-log file
-l logid
Specifies th e logical-log fi le to
drop
Parameters menu /
Drop-Log option
Edit ONCONFIG
directly an d rei
shared memory
D rop virtual processors onmode -p - numberCPU
-p - number
Indicates how m any virtual
processors of the CPU class to
drop
Mode menu/
Drop-Proc option
Edit ONCONFIG
directly an d rei
shared memory
-
8/8/2019 Informix UCM Server Guide
10/20
8
INFORMIX-UniversalServerQuickRe
ferenceGuide
Modify data-replicationconfiguration parameters None available Parameters menu/ da ta-Replication option EditONCONFIG
directly an d rei
shared memory
Modify diagnostic
configuration parameters
None available Parameters menu/
diaGnostic option
Edit ONCONFIG
directly an d rei
shared memory
Modify multithreading
configuration parameters
See Add virtual processorsan d
Drop virtu al processors
Parameters menu /
perFormance option
Edit ONCONFIG
directly an d rei
shared memory
Modify sh ared-memory
configuration parameters
None available Parameters menu/
Shared -Memory op tion
Edit ONCONFIG
directly an d rei
shared memory
Modify size or location of
the physical log
onparams -p -s size [-d dbspace]
-p Modifies the p hysical log
-s size
Specifies the p hysical log size
in kilobytes
-d dbspace
Nam es the dbspace where theph ysical log will be located
Parameters menu /
Physical-Log
Edit ONCONFIG
directly an d rei
shared memory
Configuring Universal Server From Command Line Using ON-Monitor Other
-
8/8/2019 Informix UCM Server Guide
11/20
INFORMIX-UniversalServerQuickReferenceGu
ide
9
Modifying Universal Server
Disk Structures From Command Line Using ON-Monito
Add chunk to a dbspace
or blobspace
onspaces -a {dbspace| blobspace} -p pathname -o offset-s size
[-m pathname offset]
-a Indicates that a chunk is to be added to the specified
dbspace or blobspace
-m pathname offset
Specifies the pathname and offset of the mirror chun k
Dbspaces menu
Add_chunk opt
Change chunk status onspaces -s {dbspace| blobspace} -p pathname -o offset{-D| -O}
-s Changes the chun k status
-D Takes the chu nk d own
-O Restores the chu nk and brings it on-line
Dbspaces menu
option
Change the DATASKIP
parameter for a dbspace
onspaces -f {ON | OFF} [dbspace ...]
-f Sets the DATASKIP configuration parameter dbspace ...
Specifies the DATASKIP setting for one or m ore dbspacesif
a dbspace is not specified , all dbspaces are set
Dbspaces menu
datasKip option
-
8/8/2019 Informix UCM Server Guide
12/20
10
INFORM
IX-UniversalServerQuickR
eferenceGuide
Create a blobspace onspaces -c -b blobspace -g pageunit-p pathname -o offset-s size
[-m pathname offset]
-c -b blobspace
Creates and names a new blobspace
-g pageunit
Specifies the pageu nit, which is the num ber of disk pages
per blobpage
-p pathname
Specifies the pathn ame of the primary chun k
-o offset-s size
Specifies the offset and size of the p rimary chu nk
-m pathname offset
Specifies the pathname and offset of the mirror chun k
Dbspaces menu
Create option
Create a dbspace onspaces -c -d dbspace [-t] -p pathname -o offset-s size
[-m pathname offset]
-c -d dbspace
Creates and nam es a new d bspace
-t Indicates that the d bspace is a temporary d bspace
-p pathname
Specifies the pathn ame of the primary chun k-o offset-s size
Specifies the offset and size of the p rimary chu nk
-m pathname offset
Specifies the pathname and offset of the mirror chun k
Dbspaces menu
Create option
Modifying Universal Server
Disk Structures From Command Line Using ON-Monito
-
8/8/2019 Informix UCM Server Guide
13/20
INFORMIX-Universal
ServerQuickReferenceGuid
e
11
Drop a chunk from a
dbspace or blobspace
onspaces -d {dbspace| blobspace} -p pathname -o offset
-d Indicates that a chu nk is to be dropp ed from the specified
dbspace or blobspace
-p pathname -o offset
Identifies the chun k to be d ropped
Non e available
Drop a dbspace orblobspace from the
Universal Server
configuration
onspaces -d {dbspace| blobspace}-d Indicates that the specified dbspace or blobspace is to be
dropped
Dbspaces menuoption
End mirroring for a
dbspace or blobspace
onspaces -r {dbspace| blobspace}
-r Indicates that m irroring should be ended for a dbsp ace or
blobspace
Dbspaces menu/
option
Start mirroring a dbspace
or blobspace
onspaces -m {dbspace | blobspace} {(-p pathname -o offset
-m pathname offset) | -f filename}
-m Specifies mirroring for a dbspace or blobspace
-p pathname -o offset
Specifies the pa thname and offset of a prim ary chun k
-m pathname offsetSpecifies the path nam e/ offset to the mirror chunkyou
mu st specify a mirror path nam e and offset for each p rimary
chunk in the d bspace
-ffilename
Indicates that chunk location information is stored in a file
Dbspaces menu/
option
Modifying Universal Server
Disk Structures From Command Line Using ON-Monito
-
8/8/2019 Informix UCM Server Guide
14/20
12
INFORM
IX-UniversalServerQuickR
eferenceGuide
Verifying Database Consistency From Command Line Using ON-Mon
Validate extents in all UniversalServer databases oncheck -ceVerifies that th e extents on d isk correspond to the control
information d escribing them
Non e availab
Validate indexes in Universal Server
database
oncheck -ci database [:table]
-ci Checks ordering of key values and the consistency of
horizontal and vertical nod e keys for all ind exes on
the sp ecified t able(s)database [:table]
Specifies a database to be checkedyou can specify
a table as well if you wa nt to limit the check
oncheck -cI database [:table]
-cI Checks ordering of key values and the consistency of
horizontal and vertical nod e keys for all ind exes on
the sp ecified table(s); also checks that the key value
tied to a rowid in an index is the same as the key
value in a row
database [:table]
Specifies a database to be checkedyou can specify
a table as well if you wa nt to limit the check
Non e availab
Validate Universal Server reserved
pages
oncheck -cr
Checks each Un iversal Server reserved p age against the
ONCONFIG file, ensu res that chu nks can be opened , and
checks all logical and phys ical logs for consisten cy
Non e availab
-
8/8/2019 Informix UCM Server Guide
15/20
INFORMIX-Universal
ServerQuickReferenceGuid
e
13
Validate pages of all tables in
Universal Server database
oncheck -cd database [:table]
-cd Checks the p ages of a table or tables,exclud ing
blobpages and sbpages, from the tblspace for the
specified database, table, or fragment an d checks for
consistency in bit-map entries
database [:table]
Specifies a database to be checkedyou can specify
a table as well if you want to limit the check
oncheck -cD database [:table]
-cD Checks the p ages of a table or tables for consisten cy,
includ ing dbspace and blobp ages. Entries in the bit-
map pages are checked against th e pages to verify
mapping
database [:table]
Specifies a database to be checkedyou can specifya table as well if you wa nt to limit the check
Non e availab
Validate system catalog tables for
Universal Server database
oncheck -cc [database]
-cc Performs check of each system catalog table avail-
able in the d atabase
database
Specifies the d atabaseif you d o not sp ecify a data-
base, the system catalog tables of all databases are
checked
Non e availab
Verifying Database Consistency From Command Line Using ON-Mon
-
8/8/2019 Informix UCM Server Guide
16/20
14
INFORM
IX-UniversalServerQuickR
eferenceGuide
Monitoring Universal Server From Command Line Using ON-Monitor Using SMI Tables
Monitor archive files None available Status menu/ Archive
option
Non e available
Monitor buffers onstat -b
Displays information abou t bu ffers
currently in use
ons tat -B
Displays informa tion about all
buffers configu red
ons tat -X
Displays information about the
thread s that are waiting for buffers
None available None available
Monitor buffer pool onstat -F
Displays a count of each typ e of
write that w rites data to d isk
ons tat -R
Displays detailed information
about the LRU buffer queu es
None available Query sysprofile t
Monitor chunks onstat -d
Displays information about the
chunks in each d bspace
ons tat -D
Same as -d except that p age reads
and writes per chunk are also
displayed
Status menu / Spaces
option
Query sysdbspace
syschunks, an d sy
tables
-
8/8/2019 Informix UCM Server Guide
17/20
INFORMIX-Universal
ServerQuickReferenceGuid
e
15
Monitor configuration
information
ons tat -c
Displays contents ofONCONFIG
file
Status menu /
Configuration option
Query sysconfig ta
Monitor databases None available Status menu/ Databases
option
Query sysdatabas
Monitor dynamic
libraries
onstat -g dll
Displays list of loaded dynam ically
linked libraries
None available None available
Monitor data-replication
information
ons tat -g dri
Displays data-replication
information
Status menu/ data-
Replication option
Query sysdri table
Monitor latches onstat -s
Displays general latch information
None available None available
Monitor locks onstat -k
Displays information abou t active
locks
None available Query syslocks ta
Monitor logs onstat -l
Displays information about the
ph ysical log and the logical log
Status menu/ Logs
menu
Query syslogs tab
Monitor message logs onstat -m
Displays the m ost recent lines of
the system m essage log
None available None available
Monitoring Universal Server From Command Line Using ON-Monitor Using SMI Tables
-
8/8/2019 Informix UCM Server Guide
18/20
16
INFORM
IX-UniversalServerQuickR
eferenceGuide
Monitor Universal Server
blocking
onstat
All onstat options display the
reason Un iversal Server is blocking
imm ediately after the banner line
None available None available
Monitor optical memory
cache and staging-area
blobspace
ons tat -O
Displays information about the
optical system-cache and user-
cache totals
None available None available
Mon itor sys tem profile ons tat -p
Displays system-profile statistics
Status menu/ Profile
option
Query sysprofile t
Monitor tblspaces (active) onstat -t
Displays information abou t each
active tblspace
None available Query sysptproft
Monitor threads onstat -g ath
Displays informa tion about all
threads
ons tat -g act
Displays information abou t active
threads
Status menu /
Userthreads option
Query syssessions
syssesproftables
Monitor transactions onstat -x
Displays transaction information
None available None available
Monitoring Universal Server From Command Line Using ON-Monitor Using SMI Tables
-
8/8/2019 Informix UCM Server Guide
19/20
INFORMIX-Universal
ServerQuickReferenceGuid
e
17
Monitor userthreads onstat -u
Displays information abou t each
userthread
Status
menu/ Userthreads
option
Query syssessions
syssesproftables
Monitor virtual
processors
onstat -g glo
Displays information abou t each
virtual processor currently runn ing
None available Query sysvpproft
Monitoring Universal Server From Command Line Using ON-Monitor Using SMI Tables
-
8/8/2019 Informix UCM Server Guide
20/20