Save 
Join IIUG
 for   
 

Informix News
11 February 09 - InformationWeek - IBM Drifts Slowly Toward Mainstream Cloud Computing... Read
11 February 09 - CNNMoney.com - IBM to Deliver Software via Cloud Computing With Amazon Web Services... Read
07 January 09 - Huliq News - IBM Power Servers Helps Bank of Chengdu Build Up Core Banking System.. Read
04 December 08 - Steeleye - Multicarta achieves 99.997% uptime for its Informix-based Credit Card Authorization Centre... Read
16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read
14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read
29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read
29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read
28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read
28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read
09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read
08 April 08 - IT-Director.com - Informix seeks developers... Read
18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read
17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read
17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read
16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read
16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read
28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read
27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read
14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read
14 June 07 - eChannelLine - IBM expands scope for IDS... Read
14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read
13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read
12 June 07 - IBM - IDS 11 release announcement (pdf)... Read
12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read
12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read
12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read
12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read
12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read
12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read
12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read
12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read
12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read
12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read
12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - golem.de - Informix 11 vorgestellt... Read
12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read
12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - Heise - IBM gibt Informix 11 frei... Read
25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read
18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read
18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read
7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Admin Tools Forum

Re: Re:Single Processor / Multi Processor

Posted By: Navaid Arif
Date: Tuesday, 28 August 2007, at 9:05 a.m.

In Response To: Re:Single Processor / Multi Processor (Art Kagel)

Thanks a lot, Kagel.

Regards,
Navaid Arif .

----- Original Message -----
From: "Art Kagel" <art.kagel@gmail.com>
To: <admin-tools@iiug.org>
Sent: Monday, August 27, 2007 7:42 PM
Subject: Re:Single Processor / Multi Processor [2997]

> Yes. You should set:
>
> MULTIPROCESSOR 1 # So that the engine will use mutex locking to prevent
>
> # multiple simultaneous updates to the
> same data
> SINGLE_CPU_VP 0 # if not zero then you are only allow one CPU VP
> NUMCPUVPS or VPCLASS setting for CPU class VPs:
>
> Set to at least 3 but as many as 8 - the 4 cores in your processors
> are
> fast enough to each support at least 2 CPU VPs
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Navaid Arif <admin-tools@iiug.org>
> At: 8/24 10:25:38
>
> Hi All,
>
> I have a machine with following configuration.
>
> ############################################
> # System Summary
> ############################################
>
> 2 - Physical CPUs
> 4 - (L)CPUs currently
> 4 - (L)CPUs configured
> 1900 - MHz CPU clock rate
> PowerPC_POWER5 - Processor
> 64 bit - Hardware
> 32 bit - Kernel
> Memory - 4 GB
> Dynamic - Logical Partition
> 5.3.0.40 ML04 - AIX Kernel Version
>
> But parameters in ONCONFIG for my IDS are set as:
> MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
> NUMCPUVPS 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
> I have a doubt that these parameters should be MULTIPROCESSOR=1,
> NUMCPUVPS=(n-1)=(4-1)=3 and SINGLE_CPU_VP=3
>
>>onstat -p
>
> IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 4 days
> 09:41:15
> -- 853776 Kbytes
>
> Profile
>
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 51389758 56122057 647129757 92.06 6933791 10141685 40287310 82.79
>
> isamtot open start read write rewrite delete commit rollbk
> 388214480 18142974 21222280 231088462 1779521 18262908 1467372 2890018 26
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> 1040100 148601 1939995 165003 0 0 4
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 2027 96807.91 88708.86 1270 2541
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 7966174 490 2255685626 0 0 304 360971 800697
>
> ixda-RA idx-RA da-RA RA-pgsused lchwaits
> 1600631 169135 34880881 36249558 106310
> Please advice.
>
> Regards,
> Navaid Arif
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Admin Tools Forum is maintained by Administrator with WebBBS 5.12.