Chapter 1


A1:

IBM added the term "Universal" to reflect DB2's capability to store all kinds of electronic data including traditional relational data, as well as audio, video, text, and so on, and the support of a range of operating systems and hardware architectures.

A2:

Rational, DB2, WebSphere, Tivoli, and Lotus.

A3:

Yes. All the DB2 editions other than DB2 Everyplace have a set of core modules that are the same; therefore, an application that works with DB2 UDB Personal Edition will work against DB2 UDB Enterprise Server Edition.

A4:

No. DB2 Connect is required only in one direction: when connecting from a DB2 LUW to DB2 for z/OS or other host server like DB2 for iSeries, DB2 for VM, and VSE or DB2 for OS/390.

A5:

DB2 UDB Workgroup Server Unlimited Edition (WSUE) is most appropriate from a cost standpoint since it is licensed per CPU, not per user, while DB2 UDB WSE is licensed per user.

A6:

No. Federation support is built into the DB2 product for RDBMSs that are part of the IBM family, like IBM Informix.

A7:

A company migrating their production database from Oracle to DB2 may set up DB2 replication to replicate the data from the Oracle production server to the DB2 server. This approach lets developers at the company test their applications against the DB2 server with "real" data before switching completely to DB2.

A8:

No. Even though more than ninety percent of the code is common among these platforms, each platform has its own file used for installation for the appropriate platform.

A9:

The database partitioning feature (DPF) allows you to partition your data within a single server or across multiple servers running the same operating system. This provides for scalability.

A10:

Contact your IBM marketing representative, or call 1-800-IBM-SERV and indicate that you would like to buy a permanent license for your DB2 product.

A11:

D. The minimum software required on the Windows client is the DB2 runtime client. This is required to run any application, other than an application using the JDBC type 4 driver.

A12:

D. The application development (AD) client is required to write a JDBC application. To run the application, however, you may not need a client as in the case of the JDBC type 4 driver.

A13:

B. DB2 UDB Personal Edition is a fully functional server that is designed for personal use only. As such, it does not support connections from remote clients.

A14:

C. DB2 UDB Personal Edition is not considered a DB2 server since it cannot accept inbound (remote) connections from clients.

A15:

B. The application development client includes everything the Administration client has (including the graphical administration tools) in addition to libraries and tools used for application development.

A16:

C. DB2 Everyplace is a fully functional database that can be stored in mobile devices like PDAs. DB2 Everywhere is not a DB2 Edition, and DB2 Satellite Edition was merged with DB2 Personal Edition in Version 8.

A17:

D. DB2 Universal Developer's Edition (UDE) includes DB2 Connect Enterprise Edition, which allows the connection to host servers. It also includes all the DB2 LUW clients. Because this is a software development company, UDE is more convenient than DB2 UDB Enterprise Server Edition and it is cheaper.

A18:

A. A zSeries server with a LPAR running the Linux operating system can run DB2 UDB for Linux, UNIX, and Windows.

A19:

A. DB2 UDE (Universal Developer's Edition) includes DB2 Connect Enterprise Server Edition, which allows several clients to connect to DB2 for z/OS.

A20:

B. DB2 Warehouse Manager is one of the products under the Business Intelligence umbrella and can be used to help you understand your data to make better business decisions.



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net