Advanced DBA Certification Guide and Reference for DB2 Universal Database V8 for Linux, UNIX, and Windows


Book Description

Straight from IBM, Advanced DBA Certification Guide and Reference for DB2 Universal Database v8for Linux, UNIX, and Windowsis the definitive guide to enterprise-class DB2 v8 administration - andthe onlyauthoritative self-study guide for IBM's new DB2 advanced DBA exam. Delivers proventechniques for enterprise-class security, user management, recovery, scalability, optimization,troubleshooting, remote administration, and more! CD-ROM: DB2 Universal Database v8 EnterpriseServer Edition trial version plus complete documentation.




Performance Tuning for IBM Security Directory Server


Book Description

In today's highly connected world, directory servers are the IT cornerstone of many businesses. These components of the corporate infrastructure are the foundation of authentication systems for internal and, more commonly, external user populations. Managing a directory server with several hundred internal users is not all that difficult. However, managing a directory server with several million external users in all 24 time zones throughout the world is a much more daunting task. IBM® Security Directory Server software can handle millions of entries, given the right architecture, configuration, and performance tuning. However, that tuning can differ greatly from tuning for a smaller server with only a few hundred thousand entries. Managing and tuning a directory server of this size requires a change in mindset. Tuning and performance must be a focus even before the hardware is ordered. A proactive approach must be taken after installation also, including the pretuning steps to better interface with other products to make installations and migrations successful, and then regular maintenance to keep the directory running smoothly. This IBM Redbooks® publication is the accumulation of lessons learned in many different real-world environments, including a 24-server fault tolerant configuration with more than 300 million entries. The authors pooled their knowledge and resources to provide the most comprehensive performance view possible, from hardware to software, sort heaps to buffer pools, and table cardinalities. In large directory server deployments, use this document as a guide for how to get the right fit for your environment.




Understanding DB2


Book Description

The Easy, Visual Way to Master IBM® DB2 for Linux®, UNIX®, and Windows®—Fully Updated for Version 9.5 IBM DB2 9 and DB2 9.5 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges. Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables. This book is for everyone who works with DB2: database administrators, system administrators, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736. Coverage includes Choosing the right version of DB2 for your needs Installing and configuring DB2 Understanding the DB2 environment, instances, and databases Establishing client and server connectivity Working with database objects Utilizing breakthrough pureXMLTM technology, which provides for nativeXML support Mastering administration, maintenance, performance optimization, troubleshooting, and recovery Understanding improvements in the DB2 process, memory, and storage models Implementing effective database security Leveraging the power of SQL and XQuery




Project Management with the IBM Rational Unified Process


Book Description

· Master win–win techniques for managing outsourced and offshore projects, from procurement and risk mitigation to maintenance · Use RUP to implement best-practice project management throughout the software development lifecycle · Overcome key management challenges, from changing requirements to managing user expectations The Hands-On, Start-to-Finish Guide to Managing Software Projects with the IBM® Rational Unified Process® This is the definitive guide to managing software development projects with the IBM Rational Unified Process (RUP®). Drawing on his extensive experience managing projects with the RUP, R. Dennis Gibbs covers the entire development lifecycle, from planning and requirements to post-mortems and system maintenance. Gibbs offers especially valuable insights into using the RUP to manage outsourced projects and any project relying on distributed development teams—outsourced, insourced, or both. This “from the trenches” guidebook is invaluable for anyone interested in best practices for managing software development: project managers, team leaders, procurement and contracting specialists, quality assurance and software process professionals, consultants, and developers. If you’re already using the RUP, Gibbs will help you more effectively use it. Whatever your role or the RUP experience, you’ll learn ways to · Simplify and streamline the management of any large-scale or outsourced project · Overcome the challenges of using the RUP in software project management · Optimize software procurement and supplier relationships, from Request for Proposals (RFPs) and contracts to delivery · Staff high-performance project teams and project management offices · Establish productive, consistent development environments · Run effective project kickoffs · Systematically identify and mitigate project risks · Manage the technical and business challenges of changing requirements · Organize iterations and testing in incremental development processes · Transition new systems into service: from managing expectations to migrating data · Plan system maintenance and implement effective change control · Learn all you can from project post-mortems—and put those lessons into practice










DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification


Book Description

Database administrators versed in DB2 wanting to learn more about advanced database administration activities and students wishing to gain knowledge to help them pass the DB2 9 UDB Advanced DBA certification exam will find this exhaustive reference invaluable. Written by two individuals who were part of the team that developed the certification exam, this comprehensive study guide prepares the student for challenging questions on database design; data partitioning and clustering; high availability diagnostics; performance and scalability; security and encryption; connectivity and networking; and much more. Providing sample questions in each chapter, a complete practice test modeled after the actual exam, and an extensive answer key providing full explanations for each correct answer, readers will find this to be a key resource in stimulating the learning process.




Forthcoming Books


Book Description




DB2 Workload Manager for Linux, UNIX, and Windows


Book Description

DB2 Workload Manager (WLM) introduces a significant evolution in the capabilities available to database administrators for controlling and monitoring executing work within DB2. This new WLM technology is directly incorporated into the DB2 engine infrastructure to allow handling higher volumes with minimal overhead. It is also enabled for tighter integration with external workload management products, such as those provided by AIX WLM. This IBM Redbooks publication discusses the features and functions of DB2 Workload Manager for Linux, UNIX, and Windows. It describes DB2 WLM architecture, components, and WLM-specific SQL statements. It demonstrates installation, WLM methodology for customizing the DB2 WLM environment, new workload monitoring table functions, event monitors, and stored procedures. It provides examples and scenarios using DB2 WLM to manage database activities in DSS and OLTP mixed database systems, so you learn about these advanced workload management capabilities and see how they can be used to explicitly allocate CPU priority, detect and prevent "runaway" queries, and closely monitor database activity in many different ways. Using Data Warehouse Edition Design Studio and DB2 Performance Expert with DB2 WLM is covered. Lastly, the primary differences between Workload Manager and Query Patroller are explained, along with how they interact in DB2 9.5.




SAP Solutions on IBM DB2 UDB V8.2.2 Handbook


Book Description

IBM and SAP share a vision for responding to customers' specific requirements for tighter integration, platform flexibility, lower total cost of ownership, and improved performance. DB2 UDB V8.2.2 is an SAP-optimized version that uses autonomic computing technologies specifically tuned to help SAP users streamline installation, improve performance, and increase availability. This IBM Redbooks publication provides information for SAP consultants and SAP system administrators. It includes the latest DB2 UDB architecture details, SAP-related features and functions, practical advice on SAP NetWeaver 2004 installations, and DB2 configuration in SAP environments. We describe DB2 UDB's logical and physical database objects, storage management, SAPs data classes, and space reclamation strategies, and provide the best practices for intelligent storage subsystems. We also discuss how to use DBA Cockpit to monitor your system, DB2 UDB log file management, database backup and recovery, and high availability and clustered solutions. We introduce the Problem Description / Problem Source Identification (PD/PSI) methodology, and the troubleshooting approaches for common problems. Finally, we include a discussion of the new features of SAP NetWeaver 2004s Business Intelligence (SAP BI) with DB2 UDB V8.2.2.