Moving database to new Solaris server — which Informix application best to use?

Moving database to new Solaris server — which Informix application best to use?

Question:
I have a client who has been using Informix SQL version 2.10 on an Altos UNIX server for more than 10 years. He wants to move a 700 MB database to a new server that will use Solaris x86 release 2.5.1.

Which Informix application(s) is best suited for this situation? I haven’t been able to find information about running Informix on a server using Solaris x86 as the operating system.

Answer:
I assume your client is not presently using an Informix engine (based on the information in your question). You also do not include information as to which other applications the client is running and whether they would need to interface with a new database engine. I will assume they do and work from that perspective.

As far as a database engine is concerned, your client should strongly consider the Informix-OnLine Dynamic Server (ODS) engine. If the client is still using I-SQL 2.1, I’ll assume only character-based data is involved — maybe some BLOBs, but no non-standard datatypes that would require the Informix-Universal Server database engine and DataBlades. ODS is well equipped to handle databases of your client’s size and larger, with and without BLOBs. The key is to provide sufficient physical CPUs and RAM to allow whatever degree of engine parallel processing is required or desired.

ODS has a number of database management features that the other major database vendors do not, as yet, provide. These include row level locking, elimination of adjacent key value locking, and the ability to fragment (or partition) tables, as well as indexes and constraints, both logically and by simple striping.

With ODS, as opposed to earlier versions of the OnLine engine, a number of database operations were rewritten to take full advantage of today’s SMP technology, resulting in a more powerful processing engine. Database loads and unloads, index builds, even query processing is now handled by multi-threaded processes called “virtual processors.”, which dynamically increase the efficiency and general performance of the engine. The exact number of physical CPUs that will be required to service an instance containing a database of that size will depend on the actual amount of data used and the response time required.

Regarding virtual processors, it not always true that “if some is good, more is better.” A careful analysis of the application and data environment would be required to properly size the machine for the engine and your client’s application.

About application tools for querying the data, Informix continues to sell the Informix-SQL product, currently at a version close to 6.04. It has evolved and improved over the years since the product your client is using was released. Bundled into the engine is a tool called “dbaccess”, which allows a DBA or OnLine administrator to execute SQL statements directly inside the engine instance rather than requiring an additional product such as Informix-SQL on the server. Dbaccess does not allow you to create ACE reports or SQL forms, but is still a very handy utility.

The Informix-4GL tool is also still available. It creates character-based applications to run in a UNIX environment. If you want to create Windows-based GUI applications, you can use Informix-NewEra or any number of third party application tools. With the ODS engine, Informix is now providing the ODBC connectivity products that would be required for a Windows client to connect to the Informix engine.

All the products I have mentioned are, to the best of my knowledge, currently shipping on the O/S level you mentioned in various distribution media. A couple of years ago, Informix changed its pricing model from a tiered approach to user-based licensing. So if your client only needs, for example, 12 user licenses, he no longer will have to pay for a 16-user license. Contact your local Informix sales representative, or (shameless plug to follow) an authorized Informix In-Sync partner (like yours truly) to get pricing information or place an order.

devx-admin

devx-admin

Share the Post:
Poland Energy Future

Westinghouse Builds Polish Power Plant

Westinghouse Electric Company and Bechtel have come together to establish a formal partnership in order to design and construct Poland’s inaugural nuclear power plant at

EV Labor Market

EV Industry Hurting For Skilled Labor

The United Auto Workers strike has highlighted the anticipated change towards a future dominated by electric vehicles (EVs), a shift which numerous people think will

Soaring EV Quotas

Soaring EV Quotas Spark Battle Against Time

Automakers are still expected to meet stringent electric vehicle (EV) sales quotas, despite the delayed ban on new petrol and diesel cars. Starting January 2023,

Affordable Electric Revolution

Tesla Rivals Make Bold Moves

Tesla, a name synonymous with EVs, has consistently been at the forefront of the automotive industry’s electric revolution. The products that Elon Musk has developed

Poland Energy Future

Westinghouse Builds Polish Power Plant

Westinghouse Electric Company and Bechtel have come together to establish a formal partnership in order to design and construct Poland’s inaugural nuclear power plant at the Lubiatowo-Kopalino site in Pomerania.

EV Labor Market

EV Industry Hurting For Skilled Labor

The United Auto Workers strike has highlighted the anticipated change towards a future dominated by electric vehicles (EVs), a shift which numerous people think will result in job losses. However,

Soaring EV Quotas

Soaring EV Quotas Spark Battle Against Time

Automakers are still expected to meet stringent electric vehicle (EV) sales quotas, despite the delayed ban on new petrol and diesel cars. Starting January 2023, more than one-fifth of automobiles

Affordable Electric Revolution

Tesla Rivals Make Bold Moves

Tesla, a name synonymous with EVs, has consistently been at the forefront of the automotive industry’s electric revolution. The products that Elon Musk has developed are at the forefront because

Sunsets' Technique

Inside the Climate Battle: Make Sunsets’ Technique

On February 12, 2023, Luke Iseman and Andrew Song from the solar geoengineering firm Make Sunsets showcased their technique for injecting sulfur dioxide (SO₂) into the stratosphere as a means

AI Adherence Prediction

AI Algorithm Predicts Treatment Adherence

Swoop, a prominent consumer health data company, has unveiled a cutting-edge algorithm capable of predicting adherence to treatment in people with Multiple Sclerosis (MS) and other health conditions. Utilizing artificial

Personalized UX

Here’s Why You Need to Use JavaScript and Cookies

In today’s increasingly digital world, websites often rely on JavaScript and cookies to provide users with a more seamless and personalized browsing experience. These key components allow websites to display

Geoengineering Methods

Scientists Dimming the Sun: It’s a Good Thing

Scientists at the University of Bern have been exploring geoengineering methods that could potentially slow down the melting of the West Antarctic ice sheet by reducing sunlight exposure. Among these

why startups succeed

The Top Reasons Why Startups Succeed

Everyone hears the stories. Apple was started in a garage. Musk slept in a rented office space while he was creating PayPal with his brother. Facebook was coded by a

Bold Evolution

Intel’s Bold Comeback

Intel, a leading figure in the semiconductor industry, has underperformed in the stock market over the past five years, with shares dropping by 4% as opposed to the 176% return

Semiconductor market

Semiconductor Slump: Rebound on the Horizon

In recent years, the semiconductor sector has faced a slump due to decreasing PC and smartphone sales, especially in 2022 and 2023. Nonetheless, as 2024 approaches, the industry seems to

Elevated Content Deals

Elevate Your Content Creation with Amazing Deals

The latest Tech Deals cater to creators of different levels and budgets, featuring a variety of computer accessories and tools designed specifically for content creation. Enhance your technological setup with

Learn Web Security

An Easy Way to Learn Web Security

The Web Security Academy has recently introduced new educational courses designed to offer a comprehensible and straightforward journey through the intricate realm of web security. These carefully designed learning courses

Military Drones Revolution

Military Drones: New Mobile Command Centers

The Air Force Special Operations Command (AFSOC) is currently working on a pioneering project that aims to transform MQ-9 Reaper drones into mobile command centers to better manage smaller unmanned

Tech Partnership

US and Vietnam: The Next Tech Leaders?

The US and Vietnam have entered into a series of multi-billion-dollar business deals, marking a significant leap forward in their cooperation in vital sectors like artificial intelligence (AI), semiconductors, and

Huge Savings

Score Massive Savings on Portable Gaming

This week in tech bargains, a well-known firm has considerably reduced the price of its portable gaming device, cutting costs by as much as 20 percent, which matches the lowest

Cloudfare Protection

Unbreakable: Cloudflare One Data Protection Suite

Recently, Cloudflare introduced its One Data Protection Suite, an extensive collection of sophisticated security tools designed to protect data in various environments, including web, private, and SaaS applications. The suite

Drone Revolution

Cool Drone Tech Unveiled at London Event

At the DSEI defense event in London, Israeli defense firms exhibited cutting-edge drone technology featuring vertical-takeoff-and-landing (VTOL) abilities while launching two innovative systems that have already been acquired by clients.

2D Semiconductor Revolution

Disrupting Electronics with 2D Semiconductors

The rapid development in electronic devices has created an increasing demand for advanced semiconductors. While silicon has traditionally been the go-to material for such applications, it suffers from certain limitations.

Cisco Growth

Cisco Cuts Jobs To Optimize Growth

Tech giant Cisco Systems Inc. recently unveiled plans to reduce its workforce in two Californian cities, with the goal of optimizing the company’s cost structure. The company has decided to

FAA Authorization

FAA Approves Drone Deliveries

In a significant development for the US drone industry, drone delivery company Zipline has gained Federal Aviation Administration (FAA) authorization, permitting them to operate drones beyond the visual line of

Mortgage Rate Challenges

Prop-Tech Firms Face Mortgage Rate Challenges

The surge in mortgage rates and a subsequent decrease in home buying have presented challenges for prop-tech firms like Divvy Homes, a rent-to-own start-up company. With a previous valuation of

Lighthouse Updates

Microsoft 365 Lighthouse: Powerful Updates

Microsoft has introduced a new update to Microsoft 365 Lighthouse, which includes support for alerts and notifications. This update is designed to give Managed Service Providers (MSPs) increased control and

Website Lock

Mysterious Website Blockage Sparks Concern

Recently, visitors of a well-known resource website encountered a message blocking their access, resulting in disappointment and frustration among its users. While the reason for this limitation remains uncertain, specialists