Disadvantages Of Ib2

829 Words4 Pages
There are many things that differentiate IBM i from other platforms, including its storage, security, and programming models. But one of the most unique aspects of the IBM i platform is its integrated DB2 database, which is used exclusively by practically all IBM i customers. You just dont find this on other platforms. But perhaps its time for IBM i to diversify its database support?
In many respects, DB2 for i is the platforms greatest strength. IBM i is renowned for its transaction processing prowess that drives ERP and other line of business applications, and DB2 for i (formerly DB2/400, but do not call it that around Mike Cain) is the sturdy engine that powers those transactions.
It is theoretically possible to run an IBM i server without DB2 for i. Perhaps you want to serve HTTP requests in concert with a separate Oracle or SQL Server database running on an X86 server. But doing so would seem to go against the strengths of the platforms, let alone the laws of computing nature. In a heterogeneous setups, which are common in Oracle JD Edwards and SAP Business Suite worlds, the IBM i server nearly always powers the database, while mainstream X86 servers and their Windows and Linux OSes power the application and HTTP servers.
This database-centric identity has served the IBM midrange platform well for decades. The DB2 for i database is very mature and powerful, supports both SQL and DDS programming constructs, and is more ANSI SQL compliant that other relational databases (just as how, ironically, IBM i is more POSIX compliant than all Unix operating systems, even though its not Unix). Whats more, DB2 for i just keeps getting better and better with each new release of IBM i. So why in the world would an IBM i shop ever need something else?
Its The Data, Stupid
The most answer to that question may be that the nature of data itself is changing, and therefore the ways that we store it need to change, too.
When IBM first developed the AS/400, storage (both main and disk) was expensive relative to today, and so companies wanted to minimize the amount they stored. IBMs storage architecture reflected this reality, and therefore the data written to disk was highly refined, or structured.
This focus on structured data
Get Access