IBM Investigates Options for Keeping MySQL on IBM i

I am always on the lookout for interesting news on the IBM iSeries (AS/400) systems and today I found an interesting article on the SystemINetwork Blog that I have copied below for your convenience.

Just when you think it's safe to jump in the PHP sandbox and play with all the cool toys, a bully comes along and tries to snatch one out of your hands. According to the MySQL website, Oracle Corporation has dropped support for versions of the MySQL open-source database that run on IBM i and AIX. Citing "very low demand," Oracle says it won't build anymore MySQL binaries for the AIX and IBM i platforms.

It's too bad that Oracle has decided to not play fair, but the company is in the database business, and in business, I suppose it doesn't make sense to continue something that doesn't benefit you.

Still, IBM users don't need to get in a huff at the prospect of losing one of the keys to running open-source apps on i, nor should i users launch into a tantrum (yet).

True, Oracle ultimately owns the MySQL code (even though it's open source). But the IBM i versions at least are available through the Zend PHP bundle that is distributed with current versions of IBM i, and you can download MySQL for i from the YiPs website as well. Besides, that latest version of MySQL for IBM i works with i 5.4, 6.1, and 7.1. "And that's quite a bit of runway that people have," says Alison Butterill, IBM's application development offerings manager for Power Systems.

And lest we forget that once a upon a time, before the IBM i version of MySQL existed, folks did download MySQL and compile it for their i systems so that they could make use of open-source programs like Joomla and SurgarCRM. I remember those days . . . and the buzz that a potential IBM i version of the database created.

Because of the way open source works, anyone still can download the source code for the MySQL database and compile it for their server environment. "They [Oracle] were creating the object code, and that's what they've stopped," Butterill says.

Oracle hasn't answered my query for more information about the decision to put an end to MySQL versions for IBM i, but it seems odd to me that there is "very low demand," especially considering that Zend seems to have a large customer following on IBM i.

Oracle will likely honor any existing support contracts it has with customers for the application. And as is the case with any open-source software, there is a community through which users can find support in the shape of forums and blogs.

For IBM's part, Big Blue is investigating the options, Butterill says. "We're focused predominantly on keeping the open-source commitment on IBM and figuring out some way of maintaining the MySQL option."

Too, IBM put a lot of time and energy into writing the IBM DB2 for i Storage Engine that translates MySQL statements for DB2 and owns that code. I doubt IBM is going to just stand by and watch as the bully tries to knock that out of the sandbox.

—Rita-Lyn Sanders, Senior Industry Editor

Some PostgreSQL news

We have a new schedule of DBA and Developer training classes. If you missed the opportunity to join us for trainings in 2010 - it's not too late. With our new classes in 2011, you can easily begin working towards your Professional Postgres Plus Certification.

Check out our offerings below and learn how to advance your career with PostgreSQL.

Come visit our newly upgraded website, designed so that you can easily find the content that you need.

We recently announced the availability of three components, adding important security and replication technology for community PostgreSQL Server users - SQL/Protect, PL/Secure and xDB Replication Server.

These add-on modules make PostgreSQL more secure and supply data integration capabilities between multiple PostgreSQL servers as well as between PostgreSQL and Oracle.

Download these new modules today.

Perche' PHP e' il linguaggio Web piu' popolare?

Oggigiorno, PHP e' il linguaggio Web piu' popolare. Attualmente la maggior parte dei website sono sviluppati in PHP o comunque usano il linguaggio PHP. Viene utilizzato per i portali di lavoro; siti di social networking per le nicchie, website basati su CMS, sviluppo applicazioni web, o website di ecommerce. Tutto quello che occorre e' trovare qualcuno specializzato in questo linguaggio per sviluppare il lavoro occorrente.

Uno dei principali vantaggi dell' uso di PHP e' che un sito dinamico puo' partire molto veocemente ed anche che e' possibile assicurarne la protezione con l' aiuto di "secured layers". Molti clienti in US e UK affidano lo sviluppo esterno dei loro siti a varie societa' di sviluppo Web che usano PHP. Se si utilizza questo linguaggio non ci sono costi per il software sul server perche' il linguaggio e' gratuito.

Con questo linguaggio e' possibile sviluppare website con una interfaccia User friendly. La maggior parte delle societa' che offrono servizi web cercano di sviluppare progetti per i propri clienti usando queso linguaggio. PHP e' anche diventato piu' veloce con l' utilizzo del motore ZEND (Zeev ed Andy). PHP e' anche molto flessibile quando ci si vuole connettere a database RDBMS (Relation Database management system). Inoltre PHP e' usato da molte applicazioni open source come:- drupal, joomla, wordpress, OS commerce , ZEN cart ecc.

Numerose soluzioni di sviluppo siti possono essere basate su PHP e questa e' una delle ragioni per cui e' utilizzato da molti fornitori di servizi di web hosting. Quando volete offrire l' hosting di un dominio web o di un sito web, non occorrera' applicare speciali configurazioni in quanto lo script e' pronto per l' utilizzo. Quindi ogni web master puo' usare questo linguaggio di scripting senza molte preoccupazioni di configurazione sull' hosting.

Tramite PHP uno sviluppatore web puo' facilmente installare tool online all' interno di un sito. Pertanto potrete utilizza tool come Google map o altri nel vostro sito. Attraverso questa funzionalita' di sviluppo potrete rendere il vostro sito web piu' browser friendly e piu' utile.

Una societa' di siluppo siti con una discreta esperienza puo' sviluppare buoni script in poco tempo, in quanto e' facile e veloce utilizzare i suoi comandi . Penso che l'utilizzo di PHP per lo sviluppo di siti web, permetta ad una societa' di sviluppare velocemente, ridurre i costi e quindi aumentare i guadagni.

Questo articolo e' stato inizialmente pubblicato in Inglese su “http://www.articlesbase.com/web-design-articles/why-php-is-the-most-popular-web-programming-language-3968504.html”

(ArticlesBase SC #3968504)

Why PHP is The Most popular web programming language?

Nowadays, PHP is the most popular web programming language. Today the all most business websites are in utilize and built with the help of PHP languages. Therefore it is treated as a job portal; social networking sites for niches, CMS driven websites, web application development, intent portals or ecommerce websites, PHP can take care of them all. All that you need is someone specialized in this scripting language to do the job for you.

One main advantage of using PHP, a dynamic site can be open very quickly and also through we can protect a website with the help of secured layers. Lots of US and UK clients outsource their web development task to the various PHP based web development companies. To design a website using this language, servers are free of cost. Only a specialized and reliableweb development company can give such kind of unique information to their auspicious clients.

User friendly websites can be easily developed through this popular web programming language. Most of the web service providers always try to hire web development projects from the clients only using this programming language. Php became more faster due to ZEND(Zeev and andy) engine. Php is very much flexible to connect with any kind of RDBMS(Relation Database management system). Some other good drawback of PHP is that, It has Lots of open source like:- drupal, joomla, wordpress, OS commerce , ZEN cart etc.

Numerous website development solutions can be done using PHP that why it is used by several web hosting service providers. While hosting a web domain or a website, you will not have to configure the script either, as it is already ready to use. Therefore, any web master can use this scripting language without worrying a great deal about the hosting.

Through PHP a web developer can easily setup online tools within a website. Therefore you can setup some tools like google map or something else within your website. Using this numerous functionality of this web development services you can make your website more browser friendly and more useful.

A well experienced web development company can make a good script of a website using this language within a short period of time, for the reason that it is quicker to type the essential commands of a scripting language. I think using PHP a web development company can earn lots of money and can save the lots of time while developing a client website.

Retrieved from “http://www.articlesbase.com/web-design-articles/why-php-is-the-most-popular-web-programming-language-3968504.html”

(ArticlesBase SC #3968504)

Web Enablement and PHP on IBM i White Papers

Read the white papers to learn how you can deliver modern web applications with these two BCD solutions: Presto gives all your IBM i green screens a Web GUI in one minute with no code changes. The white paper discusses why you should modernize your 5250 applications and how Presto can accomplish this. WebSmart PHP helps you rapidly develop IBM i and multi-platform PHP apps in minutes using templates and wizards. The white paper discusses why you should consider writing web apps in PHP and how WebSmart helps you do that. Bonus Draw: Every IT person at any organization that purchases a BCD software product by January 31, 2011 that is registered in this draw will be entered in a second drawing to win a free iPad. Request a White Paper or 30-day Trial to enter iPad draw

News received from: iseries@bcdsoftware.com

Oracle Drops MySQL Support for IBM i

by Alex Woodie

Citing "very low demand," MySQL announced last month that it will no longer provide the MySQL database running on the IBM i operating system. The company, which is owned by IBM archrival Oracle, says it will continue to provide source code and limited product support to customers who want to work with the database on IBM i. Representatives with IBM Rochester say they are looking into ways to continue supporting the open source database, possibly with Zend Technology.

On December 7, MySQL announced the end of life (EOL) of MySQL binaries it developed for several operating systems, including i5/OS V5R4, IBM i version 6.1, AIX version 5.3, Red Hat Enterprise Linux version 3, SuSE Enterprise Linux version 9, OpenSuSE Linux version 9, and the generic X86 Linux distribution developed with Intel's ICC compiler. New support was added for the FreeBSD and Fedora operating systems.

Last month's announcement covers all versions of the MySQL database, including the binaries for the free community edition and the for-fee enterprise and commercial editions. It also includes the IBMDB2I product that allowed DB2/400 to function as a storage engine for MySQL, which MySQL owned. IBM i users are always free to compile the MySQL code themselves.

While finished binaries of older releases of the database for i5/OS V5R4 and IBM i 6.1 remain available for download, MySQL will no longer release fixes or enhancements in for the IBM i operating system in finished binary form. Those product lines have reached the end of the road at MySQL. The announcement also marks the end of sales and most forms of technical support for the enterprise and commercial editions of MySQL on IBM i. Customers can continue to get "limited" support from the vendor for running the database on these platforms, and can also get access to source code, if needed, according to the announcement, which can be viewed at www.mysql.com/support/eol-notice.html.

IBM tried to get Oracle to reconsider its decision to drop support for IBM i, but was unsuccessful, according to Allison Butterill, the application development offerings manager for Power. "We really wanted Oracle to continue to provide those binaries for our IBM i customers, and we know there were many customers that downloaded it from their website," she tells IT Jungle. "And they decided in the fall that they would withdraw those binaries. They cited business reasons; that the business justification wasn't there."

Support Questions

While MySQL won't be supporting the database on IBM i anymore, it isn't the end of the world for MySQL-on-IBM-i enthusiasts, and there are several options for IBM i customers to not only obtain the database, but to support it on the IBM i server as well.

The first support option is to go to the developer community and check forums on the Web with support questions, which is the standard way that open source software is supported, says Butterill, adding that only 5 to 10 percent of the thousands of IBM i shops that downloaded MySQL for IBM i bought support contracts from MySQL. "A lot of customers did not have a formal support agreement with MySQL, so the support is the same as they were using before," she says.

In the future, technical support may be available from IBM, Zend, or a third party. Butterill notes that Zend is already distributing installable code for MySQL for IBM i--including binaries for IBM i 7.1 for both MySQL and the IBMDB2I storage engine--and that IBM and Zend are investigating options for expanding the agreement to include formal technical support as well.

There has been no formal announcement about supporting MySQL through Zend, but there are ongoing discussions about it, says Ian Jarman, manager of Power Systems software. "We're certainly looking at that and considering it," Jarman says.

A Changing Relationship

The end of IBM i support by MySQL marks an abrupt downturn in the 3.5-year-old relationship between IBM Rochester and MySQL. Things looked promising in 2007, when IBM and the independent Swedish company entered into a formal partnership and announced plans to get MySQL running on the platform with the launch of i5/OS V6R1 in early 2008.

In late 2008, after MySQL had been bought by Sun for $1 billion, the two vendors continued to work together, and released the first private beta of the DB2/400 storage engine, which was released as a public beta called IBMDB2I in March 2009. IBMDB2I was added as a fully supported feature in MySQL version 5.1.35, which became available in May 2009. According to MySQL's website, IBMDB2I was removed with MySQL 5.1.54, which was released in November 2010.

Things really started changing when Oracle obtained MySQL with its acquisition of Sun. "I think it would be fair to say that the conditions of the relationship changed quite dramatically over the years," Jarman says. "If you think about it, when we originally developed this contract and support arrangement with MySQL, it was an independent company. Then it was taken over by Sun. Then it was taken over by Oracle. So, yeah, things have changed quite dramatically over the period. So it's not really a surprise given that MySQL was taken over by two different companies that they're business objectives have changed some years later."

By the way, with the elimination of support for IBM i 6.1 and AIX 5.3, MySQL now is officially not supported on any IBM Power servers, including newer Power7-based Power Systems servers, older Power6-based System i or System p servers, or even older still Power5-based iSeries or pSeries machines. MySQL has not been adapted and is not supported on newer releases of the operating systems, including IBM i 7.1 and AIX 7.1. No Power-based Linux distributions are officially supported.

At the top of every Web page on the MySQL website is a link that says "Recommended servers for MySQL." The link leads to Oracle's webpage for Sun servers. "It doesn't really surprise me that Oracle is beginning to say they will support fewer and fewer platforms as they try to shore up their Solaris business," Jarman says.

Yhe article was originally published at Four Hundred Stuff

Linux on the PS3 Playstation

The Sony PS3 is sold as console for gaming, but the Sony playstation 3 is also a powerful PC which allows to install an alternative Operating System such as Linux.. People usually use the console to play games, but the PS3 console can do much more. If you install Linux on PS3 you will be able to use your PS3 console also as another computer.

However we must mention one problem. In March Sony disabled the "Other Os" feature with the newì firmware v3.21. The update is not mandatory, but customers who decide not to install it, would be cut off from a number of other features such as signing in to PlayStation Network.This prompted a class action filed on April against Sony,

To conclude the Linux installation is still possible, but you should be aware that some other PS3 features will become unavailable There are many benefits that can be achieved by installing Linux on a PS3 and they are de scribed in the article at http://www.ps3mart.com

As you know I am always on the lookout for interesting news on the AS/400 and I found the following at http://blogs.systeminetwork.com

January 4, 2011

IBM i Enthusiast Asks for Cloud-based i

Aaron Bartell isn't the kind of guy to sit on the sidelines and think, "If only." No, Aaron likes to make things happen. Take, for example, his current idea for personal instances of IBM i.

Aaron would love to see IBM i more readily available to developers who might like to practice on it or get to know it better.

To that end he has asked IBM to create an affordable program that provides access to IBM i. Take it away, Aaron:

Cloud-based i

I'm curious to know how many developers have an idea to pursue on IBM i but can't because of a lack of access to a machine. I've found that it's incredibly difficult to obtain access to your own instance of IBM i. You either need to be incredibly fortunate to work for somebody that lets you use their IBM i system to expand your personal horizons, or you need a big wallet to purchase an entry-level machine at around $15,000.

I'm on the IBM ISV Advisory Council and have submitted a formal request for an end-user lease program that would let developers lease an IBM i LPAR "in the cloud" for market rates—about $65 per month.

IBM does offer the Virtual Loaner Program (ibm.com/systems/vlp), which lets you configure a new instance of IBM i via a web browser in about five minutes and two hours later IBM emails you login credentials to the automatically created IBM i LPAR. I've been using this VLP service for about four years and am amazed at how seamless it is. The only issues are that there are legal limitations on how you can use the machine, it's only accessible via a VPN connection (i.e., you can't host a public website on it), and your use expires after two weeks.

IBM has the technology, it just needs us to demand that the company take it further for the benefit of not only current IBM i customers, but also for the next generation of developers who are coming out of colleges in droves and only know Java and .NET.

Again, please let me know (aaronbartell@mowyourlawn.com) if you would like to have access to IBM i in the cloud. I need to go back to IBM with numbers and examples of how people would use such a service if it existed.

One thought I had is if IBM doesn't fly with the idea, would it be affordable, profitable, and possible for a third party to run with it and make it happen?

—Rita-Lyn Sanders, Senior Industry Editor

Posted by rsanders at January 4, 2011 12:49 PM

The Top Ten Success Factors in Application Modernisation on the IBM AS400

Author: Amy Grenham

Businesses considering the ongoing maintenance of their software systems are increasingly opting for the modernization route rather than replacement. Here are the top ten lessons learnt from a decade in application modernization.

Â

1. Evolution not revolution – Take small steps to change an existing system incrementally for a robust, cost effective end result.

However attractive a clean break may appear, it’s a high risk /high failure option. Instead, break down the existing situation into smaller steps and make your changes as part of a rational and sequenced process.

2. People are the key, not the technology.

People don’t hold documentation for each of their business processes. Many of the quirky IT workarounds and fixes needed to keep things ticking day to day, exist in the heads of the IT team. Programming is not just coding, its problem solving. That’s why people who know about the business are just as important as people who know new technology.

3. Get up to speed on integration technologies, in particular Java.

In order to move legacy applications on and benefit from the latest technology, it’s time to embrace modern programming languages.

Between Java and C#, it’s Java that comes up trumps as it is supported by multiple operating systems. Java offers much greater integration capabilities than legacy languages such as RPG or COBOL. What’s more, Java skills are readily available in the marketplace, so it makes financial sense to buy in additional resources when required.

4. Make sure that IT, Finance and the business are talking to each other.

Communication between departments is the key to the success of a project. If people a

re not talking to each other and understanding what is going on, then you have to find a way of bridging that gap for the project to succeed.

5. It pays to stay current on your software maintenance.Â

And this may mean staying in touch with your vendor. Even if you are not planning to change anything right now, when the time comes you will know what enhancements, fixes and features are available to you and you will be in the enviable position of being aware of your options.

6. Use testing tools and try out new ideas.

With the right testing tools and test automation you can start making changes without fear of any horrible repercussions. If you can’t measure a known baseline against which you can test any software change, you are taking a high risk with your existing set up. Manual testing is not going to cut it – it’s inaccurate, labour intensive and therefore expensive.

7. A system that has been around for 20 years cannot be replaced in two years.

A system that has been around for 20 years, represents 20 years of work, not just the original 2 years that it took develop. Fixes, features and refinements will have been introduced over the years until the system operating today maybe considerably different to the original.

8. There is no room in modern software for Waterfall project management techniques.

Waterfall project management techniques are characterised by long periods of non-delivery. Instead, opt for Agile practices. The result will be full involvement of the technical and business teams in a process of continual development and delivery. Not only does this make for better risk control, you can more effectively manage the project scope.

9. The ground-up IT replacement project only succeeds at the point that business processes are made to fit in with the new software.

We are yet to see a brand new system that is truly tailored to the business. The management of a project of this scope is fraught with difficulties, the main issue being the number of parties with differing requirements all competing for limited resources. The big re-write typically ends in an IT compromise, bending existing business processes to work around the new system.

10. Modern and legacy applications can happily co-exist.

Legacy and new applications, living together in perfect harmony, happily ever after.

www.desynit.com

Article Source: http://www.articlesbase.com/operating-systems-articles/the-top-ten-success-factors-in-application-modernisation-on-the-ibm-as400-3865021.html

AUTHOR:

Amy Grenham is a marketing communications professional.