DB2 9 for Linux, UNIX, and Windows : DBA guide, reference, by George Baklarz

By George Baklarz

DB2® nine builds at the world's number 1 company database to simplify the supply of data as a provider, speed up improvement, and dramatically increase operational potency, defense, and resiliency.

Now, this new version deals entire, start-to-finish insurance of DB2 nine management and improvement for Linux®, UNIX®, and Windows® structures, in addition to authoritative guidance for the newest IBM DB2 certification exam.

Written for either DBAs and builders, this definitive reference and self-study advisor covers all points of deploying and handling DB2 nine, together with DB2 database layout and improvement; day by day management and backup; deployment of networked, Internet-centered, and SOA-based purposes; migration; and masses extra. you are going to additionally locate an remarkable choice of specialist counsel for optimizing functionality, availability, and price.

Coverage includes:

  • Important protection and resiliency improvements, together with complex entry regulate; fine-grained, label-based safety; and the recent safety administrator role
  • Breakthrough pureXML positive factors that assist you be triumphant with service-oriented architecture
  • Operational advancements that improve DBA efficiency--including self-tuning reminiscence allocation, automatic garage administration, and garage optimization
  • Table-partitioning good points that increase scalability and manageability
  • Powerful advancements for extra agile and speedy improvement, together with the recent Eclipse-based Developer Workbench and easy SQL or XQuery entry to all data

Whatever your function in operating with DB2 or getting ready for certification, DB2 nine for Linux, UNIX, and home windows, 6th Edition is the only booklet you cannot manage to pay for to be without.

Download whole DB2 V9 Trial Version

Visit ibm.com/db2/9/download.html to obtain an entire trial model of DB2, which lets you try dozens of the main robust gains of DB2 for your self: every little thing from pureXML aid to computerized management and optimization.

  • Straight from IBM, the final word advisor to working DB2 nine and getting ready for the newest IBM DB2 certification exam!
  • Covers strong DB2 nine improvements starting from automatic administration to stronger compression
  • Covers the entire spectrum of DBA tasks, together with server administration, facts placement, XML options, task research, excessive availability, and security
  • Presents professional assistance and most sensible practices from the DB2 customer service organization

Show description

Read or Download DB2 9 for Linux, UNIX, and Windows : DBA guide, reference, and exam prep PDF

Best unix books

Building a Virtual Private Network

What you are promoting has to be attached on the way to compete within the worldwide industry. staff want to know that their company's community is available at any time, from anywhere. A digital deepest community (VPN) accomplishes this through the use of distant connectivity applied sciences that mix latest inner networks with the net to soundly converse info.

Mac OS X Leopard Phrasebook

Mac OS® X Leopard Phrasebook   Brian Tiemann   crucial Code and instructions   Mac OS X Leopard Phrasebook offers the entire command words you want to take complete benefit of the Leopard’s hidden and undocumented energy beneath the graphical consumer interface: time-saving strategies for successfully operating with documents, folders, the Finder, highlight, textual content records, servers, disks, CDs/DVDs, permissions, printing, functions, Expos?

DNS & BIND Cookbook

The DNS & BIND Cookbook provides recommendations to the numerous difficulties confronted through community directors liable for a reputation server. Following O'Reilly's well known problem-and-solution cookbook structure, this name is an crucial better half to DNS & BIND, 4th version, the definitive consultant to the severe activity of brand server management.

Additional resources for DB2 9 for Linux, UNIX, and Windows : DBA guide, reference, and exam prep

Sample text

An example of a partitioned database across multiple physical servers (though each server typically is small SMP server) is shown in Figure 1–7. Figure 1–7 DB2 partitioned across multiple servers using DPF In Figure 1–7 you can see that there are actually six copies of DB2. However, they all appear as a single copy to applications and administrators. Imagine the performance difference between a single copy of DB2 scanning 600,000 rows versus each copy of DB2 owning its own data and resources scanning just 100,000 rows.

DB2 Enterprise is meant for large and mid-sized departmental servers. DB2 Enterprise includes all the functions of the DB2 Express and DB2 Workgroup editions, and more. Additionally, there is a set of feature packs that are exclusive to this edition, such as the new DB2 9 Storage Optimization feature that provides deep row compression, and more. Note Some feature packs, such as the Database Partitioning and the Storage Optimization features, are not available using the authorized user metric. DB2 Enterprise can be licensed using the same VU metric as DB2 Express and DB2 Workgroup; however, in the case of DB2 Enterprise, there is no RAM or VU server rating limits for the server on which this product is installed.

Figure 1–9 Two kinds of parallelism with DB2 and DPF You should consider the DPF feature pack as an add-on to DB2 Enterprise in the following circumstances: • The speed of database utility operations is key to your business operations. Operations like reorganizations, backups, and so on are parallelized with DPF so they can be performed much quicker. For example, if the six servers in Figure 1-7 all run the backup utility, they each only need to back-up onesixth of the total data, and this operation should complete in one-sixth of the time when compared to a non-partitioned database.

Download PDF sample

Rated 4.78 of 5 – based on 43 votes