Informix CPU usage
Posted in 2006
Topics: Stored Procedures & SPL, Security, Permissions & Auditing, Platform-Specific Issues, Versions, Editions & End-of-Life
Dose anyone have a script that will display the average CPU utilization of Informix? Environment: AIX 5.2.4, IDS 9.40.FC3W3 Thanks in advance, Wayne Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc.
If you installed "nmon" tool, youcan visaully see all CPU usages. =E2=94=80HELP=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80key=3Dstatistics which toggle=20 on/off=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=90 =E2=94=82 h =3D This help information - use h to remove this screen = =E2=94=82 =E2=94=82 r =3D Resources CPU/cache/AIX etc. p =3D Partitions (LPAR) = Stats =E2=94=82 =E2=94=82 t =3D Top Process Stats 1=3Dbasic 2=3DCPU-Use 3=3DCPU 4= =3DSize 5=3DDisk-I/O =E2=94=82 =E2=94=82 u =3D shows command arguments (hit u again to refresh) = =E2=94=82 =E2=94=82 c =3D CPU by processor #=3DPURR for p5 MicroLPAR =E2=94= =82 =E2=94=82 C =3D CPU can show up to 128 CPUs l =3D longer term CPU ave= rages =E2=94=82 =E2=94=82 m =3D Memory and Paging stats k =3D Kernel Internal stats = =E2=94=82 =E2=94=82 n =3D Network stats j =3D JFS Usage Stats =E2=94=82 =E2=94=82 d =3D Disk I/O Graphs D=3DStats o =3D Disks %Busy Map =E2= =94=82 =E2=94=82 a =3D Adapter I/O (not on AIX 5.1) e =3D ESS vpath Stats = =E2=94=82 =E2=94=82 A =3D Async I/O Servers g =3D Disk Groups (see cmdline -g) = =E2=94=82 =E2=94=82 v =3D VerboseChecks-OK/Warn/Danger N =3D NFS stats =E2=94= =82 =E2=94=82 b =3D black & white mode w =3D view AIX wait processes = =E2=94=82 =E2=94=82 U =3D WLM Classes (Top Section) W =3D WLM Section (S=3DSubC= lasses) =E2=94=82 =E2=94=82 V =3D Volume Group disk Stats P =3D Paging Space Stats) = =E2=94=82 =E2=94=82 --- controls --- =E2=94=82 =E2=94=82 + and - =3D double or half the screen refresh time =E2=94= =82 =E2=94=82 q =3D quit space =3D refresh screen now =E2=94=82 =E2=94=82 . =3D Minimum Mode =3Ddisplay only busy disks and processes= =E2=94=82 =E2=94=82 0 =3D reset peak counts to zero (peak =3D ">") =E2=94=82 =E2=94=82 =E2=94=82 =E2=94=82 nmon version v11c - written by Nigel Griffiths, nag@uk.ibm.= com =E2=94=82 =E2=94=82 =E2=94=82 =E2=94=82 Frank Zablatzky, .... wrote: >Dose anyone have a script that will display the average CPU utilizat= ion of=20 >Informix?=20 >Environment: AIX 5.2.4, IDS 9.40.FC3W3=20 > >Thanks in advance,=20 >Wayne=20 > >Please do not transmit orders or instructions regarding a UBS accoun= t by=20 >e-mail. The information provided in this e-mail or any attachments i= s not an=20 >official transaction confirmation or account statement. For your pro= tection,=20 >do not include account numbers, Social Security numbers, credit card= =20 >numbers, passwords or other non-public information in your e-mail. B= ecause=20 >the information contained in this message may be privileged, confide= ntial,=20 >proprietary or otherwise protected from disclosure, please notify us= =20 >immediately by replying to this message and deleting it from your co= mputer=20 >if you have received this communication in error. Thank you.=20 > >UBS Financial Services Inc.=20 >UBS International Inc.=20 > > >********************************************************************= ***********=20 > Forum Note: Use "Reply" to post a response in the discussion forum= .=20 > > > =20 > --=20 Yunyao "Frank" Qu Computer Sciences Corporation(CSC) NOAA/CLASS, (301)817-4696