Re: RE: Informix 10.0 FC4 & Solaris 10

Hi all, Answer came to me directly. Samuel, I have no experience with optical drives, so I cannot tell you how migration would run best, but you seem to have a plan already. I am not sure what you mean by setting up "project". We normally setup IDS not by setting outside (OS) restrictions but setting onconfig parameters. On a 8 GB System why don't you give IDS the memory you have (buffering is never a wrong idea, maybe leave 1 GB for OS, rest for shared memory and buffers) ? The decision to use one global zone should be ok for a dedicated instance and you have all the options to optimise the setup (and things like noage or cpu binding will work without any problem). Marcus -----Original Message----- From: SAMUEL JAKABOWSKI [mailto:samuel_jakabowski@wildblue.net] Sent: Sunday, February 24, 2008 11:30 PM To: Marcus Haarmann Subject: Re: RE: Informix 10.0 FC4 & Solaris 10 [] The following e-mail was sent to you via IDS Forum from SAMUEL JAKABOWSKI (samuel_jakabowski@wildblue.net) at IP address 12.213.80.56. ************************************************************************ ******* Re: RE: Informix 10.0 FC4 & Solaris 10 Marcus, Thanks for the input. We have 4 CPU's @ 1800 and 8 GB RAM. This box is dedicated to a single instance. The apps are on another server. This box will be a dedicated image server. To work around the max number of chunks with 7.31, the images are stored on hp optical drives. There are roughly 15 TB of data out there. The 7.31 must be on-line 24X7, so we are using Art's dbcopy routine and several stored procedures, the critical images/data are transfered to IDS 10 on this Solaris 10 box every night. The sysadmin has set up project of 4 GB for informix. He says we do not need zones but our performance suffers the longer dbcopy/procedures execute. We need to bind to at least three of the CPU's and make sure noage doesn't bite us. Thanks, Sam ************************************************************************ *******

Hi Sam, Is your site using ESRI software? What images/file formats are you using? We run a GIS system using ESRI products. We are in the process of getting the new ESRI product Image Server up and running. This Image server will in future host our imagery(Raster) while the shape data remains in the database. We do not use zoning but instead setup different instances on the database server for whatever reason. 75% of RAM goes to shared memory but if you are only running an IDS server, about 90% or more of the RAM can be dedicated to IDS. We use IBM DS4*00 models to store our imagery data. NOAGE on our servers is set to 1. If set to 0, we do notice delays in transactions. Chaos -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus Haarmann Sent: 25 February 2008 10:12 AM To: ids@iiug.org Subject: Re: RE: Informix 10.0 FC4 & Solaris 10 [11418] Hi all, Answer came to me directly. Samuel, I have no experience with optical drives, so I cannot tell you how migration would run best, but you seem to have a plan already. I am not sure what you mean by setting up "project". We normally setup IDS not by setting outside (OS) restrictions but setting onconfig parameters. On a 8 GB System why don't you give IDS the memory you have (buffering is never a wrong idea, maybe leave 1 GB for OS, rest for shared memory and buffers) ? The decision to use one global zone should be ok for a dedicated instance and you have all the options to optimise the setup (and things like noage or cpu binding will work without any problem). Marcus -----Original Message----- From: SAMUEL JAKABOWSKI [mailto:samuel_jakabowski@wildblue.net] Sent: Sunday, February 24, 2008 11:30 PM To: Marcus Haarmann Subject: Re: RE: Informix 10.0 FC4 & Solaris 10 [] The following e-mail was sent to you via IDS Forum from SAMUEL JAKABOWSKI (samuel_jakabowski@wildblue.net) at IP address 12.213.80.56. ************************************************************************ ******* Re: RE: Informix 10.0 FC4 & Solaris 10 Marcus, Thanks for the input. We have 4 CPU's @ 1800 and 8 GB RAM. This box is dedicated to a single instance. The apps are on another server. This box will be a dedicated image server. To work around the max number of chunks with 7.31, the images are stored on hp optical drives. There are roughly 15 TB of data out there. The 7.31 must be on-line 24X7, so we are using Art's dbcopy routine and several stored procedures, the critical images/data are transfered to IDS 10 on this Solaris 10 box every night. The sysadmin has set up project of 4 GB for informix. He says we do not need zones but our performance suffers the longer dbcopy/procedures execute. We need to bind to at least three of the CPU's and make sure noage doesn't bite us. Thanks, Sam ************************************************************************ ******* ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

Hi, Thanks for the responses. We are not currently dealing with the images but with the relationship between Informix 10.0 FC4 and Solaris 10.0. The IDS 7.31 system which maintains the images will be replaced by this new system. We are stress testing this new box to get the best performance setup. In our onconfig file, we have removed the recommended parameters and replaced them with the VPCLASS setting. VPCLASS cpu, num=4,aff=1-3,noage All tables have been defined as “RAW”. When using Art’s dbcopy on a data file that has 140+ million rows, the performance starts out fast but after about 10 minutes it starts to slow way down. Informix 10.0 is the only application running on the box. Sam,

Hi everyone, I've seen this phenomenon many times before in various situtations. I know one cause, but that may or may not be happening in this particular case. What I know: As any large piece of work begins on a relatively idle system, the buffer pool pages are mostly clean. As the load progresses, the pages are dirtied. Once the page cleaners begin work, they lock the dirty pages are each page is written to disk. As long as no page cleaner writes the page where the inserts are being done, all is well. But sooner or later some page cleaner will want to clean the page containing the insert point. When that happens, the slowdown occurs (bufwaits will jump), and the engine never does get back to the previous level of performance. By varying the page cleaning thresholds, number of page cleaners and size of the buffer pool, I am often able to make the slowdown occur earlier or later. Why things never recover the starting performance is unknown. I've never seen it. Perhaps others have some insight. Cheers, Dick Snoke IBM Software Group - ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "SAMUEL JAKABOWSKI" <samuel_jakabowski@wildblue.net> To: ids@iiug.org Date: 02/25/2008 10:29 AM Subject: Re: RE: RE: Informix 10.0 FC4 & Solaris 10 [11422] Hi, Thanks for the responses. We are not currently dealing with the images but with the relationship between Informix 10.0 FC4 and Solaris 10.0. The IDS 7.31 system which maintains the images will be replaced by this new system. We are stress testing this new box to get the best performance setup. In our onconfig file, we have removed the recommended parameters and replaced them with the VPCLASS setting. VPCLASS cpu, num=4,aff=1-3,noage All tables have been defined as “RAW”. When using Art’s dbcopy on a data file that has 140+ million rows, the performance starts out fast but after about 10 minutes it starts to slow way down. Informix 10.0 is the only application running on the box. Sam, ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!