Chapter 1. Product Overview | DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)

012 - Chapter 1. Product Overview <ul><li> <p clas><script> function OpenWin(url, w, h) { if(!w) w = 400; if(!h) h = 300; window.open(url, "_new", "width=" + w + ",height=" + h + ",menubar=no,toobar=no,scrollbars=yes", true); } function Print() { window.focus(); if(window.print) { window.print(); window.setTimeout('window.close();',5000); } } </script><span></span></p> <table width="100%" cellpadding="0" cellspacing="0" border="0"><tr valign="top"></tr></table> <table width="100%" height="20" border="0" cellpadding="0" cellspacing="1"><tr></tr></table> <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td align="center"><table width="95%"><tr><td align="left"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr><td valign="top" height="5"><img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="5" alt="" border="0"></td></tr> <tr> <td><b><font size="1" color ="#0000FF">Team-Fly<img border="0" src="/books/2/607/1/html/2/Fly-Logo.gif" width="81" height="25"></font></b></td> <td valign="top" align="right"> </td> </tr> </table> <hr size="1"> <table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td valign="top" width="76" rowspan="4"><img src="/books/2/607/1/html/2/images/0131007718/0131007718_xs.jpg" width="76" height="95" border="0"></td> <td valign="top">DB2 Universal Database for OS/390 v7.1 Application Certification Guide<br>By Susan Lawson<br> </td> </tr> <tr><td>Table of Contents</td></tr> <tr><td></td></tr> <tr><td valign="bottom">Part 1. Introduction to DB2 UDB for OS/390 and z/OS</td></tr> </table> <hr size ="1"> <br><table width="100%" border="0" cellspacing="0" cellpadding ="0"><tr><td valign="top"> <h2>Chapter 1. Product Overview</h2> <ul> <li><p>DB2 Universal Database</p></li> <li><p>DB2 Middleware and Connectivity</p></li> <li><p>DB2 Application Development</p></li> <li><p>DB2 Administration</p></li> <li><p>DB2 Data Management Tools</p></li> </ul> <p>This chapter introduces you to the DB2 Universal Database (DB2 UDB) family of products for S/390, zSeries, UNIX, and Intel platforms. DB2 has the ability to store all kinds of electronic information: traditional relational data as well as structured and unstructured binary information; documents and text in many languages; graphics; images; multimedia (audio and video); information specific to operations like engineering drawings, maps, insurance claims forms, numerical control streams; and any type of electronic information. This chapter illustrates some of the ways to access data in a DB2 database using some of the interfaces provided with the products. A description of each DB2 product is provided to illustrate some of the features and functions.</p> <p>The DB2 database is an important part of IBM's e-business software portfolio. The e-business Application Framework (see Figure 1-1) provides an open blueprint on how to build e-business applications. Popular IBM e-business tools include Visual Age for Java for developing Java programs or components and Tivoli software for distributed systems management. As for application server software, IBM offers several types of servers depending on the business requirement, from message queuing (MQ) software to Java-based transaction processing with WebSphere Application Server.</p> <center> <h5>Figure 1-1. The e-business Application Framework.</h5> <p><img border="0" width="500" height="216" src="/books/2/607/1/html/2/images/0131007718/graphics/01fig01.jpg" alt="graphics/01fig01.jpg"></p> </center> <p>The most popular IBM software servers are its database servers, specifically the DB2 family.</p> <p>The DB2 family executes on pervasive devices, Intel, UNIX, AS/400, and mainframe platforms (OS/390, z/OS, and Linux). Supported operating environments include OS/2, Windows 95/98/2000/NT, Linux, AIX, Hewlett-Packard's HP-UX, Sun Microsystems' Solaris, NUMA-Q, OS/400, VSE/VM, OS/390, and z/OS. The DB2 code base is optimized for each platform to ensure maximum performance. The SQL API is common to all platforms, which allows applications written on one platform to access data on any platform. Internally, DB2 on OS/400, VSE/VM, and OS/390 differ from DB2 on the UNIX and Intel platforms, but it is the common SQL API that enables applications to work together. The DB2 code base on Intel and UNIX platforms are identical.</p> <p>DB2 provides seamless database connectivity using the most popular network communications protocols, including NetBIOS, TCP/IP, IPX/SPX, named pipes, and Advanced Program-to-Program Communication (APPC).</p> </td></tr></table> <hr size="1"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr><td valign="top" height="5"><img src="/books/2/607/1/html/2/images/pixel.gif" width="1" height="5" alt="" border="0"></td></tr> <tr> <td><b><font size="1" color="#0000FF">Team-Fly<img border="0" src="/books/2/607/1/html/2/Fly-Logo.gif" width="81" height="25"></font></b></td> <td valign="top" align="right"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" align="right">Top</td></tr></table> </td></tr></table></td></tr></table> </li></ul>