This IBM Redbooks publication describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use, automated recovery solution that enables database recovery operations with minimal disruption. Its graphical user interface (GUI) provides powerful reporting and automated recovery capabilities for productive database maintenance and high availability. This book is written for an audience of DB2 for z/OS database administrators (DBA). This book gives you an overview of DB2 Recovery Expert for z/OS, its main features, architecture, recovery semantics, and processing flow. It also describes some of the key considerations in choosing a particular topology to address a business requirement. We provide user scenarios with step-by-step approaches to recover single DB2 for z/OS objects, multiple DB2 for z/OS objects, dropped DB2 for z/OS tables, and DB2 for z/OS subsystems using the IBM Recovery Expert for z/OS tool. We discuss backup and recovery in a DB2 for z/OS environment, the types of failures that might occur, the types of recovery that are supported, the types of objects that can be recovered, the elements and tools of recovery, and the recovery flow. We also provide a brief tutorial of the DB2 Recovery Expert for z/OS GUI client and an overview of the schema level repository (SLR) with recommendations for its maintenance. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication helps you install, tailor, and configure Copy Services in open systems environments on the IBM System Storage DS6000 storage server series. It should be read in conjunction with the IBM System Storage DS6000 Series: Architecture and Implementation, SG24-6781. This book gives you the details necessary to configure each of the Copy Services functions in an open systems environment. There is a companion book that supports the configuration of the Copy Services functions in a z/OS environment, IBM System Storage DS6000 Series: Copy Services with System z servers, SG24-6782. This book helps you design and create the storage map and install Copy Services in an open systems environment. This book helps you design and create a new Copy Services installation or to migrate from an existing installation, as well as addresses design functions and changes in terminology from other IBM Copy Services products. We include hints and tips to maximize the effective installation. It also includes a section on System i and an overview of the TotalStorage Productivity Center for Replication.

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well. Other recipes in the book teach you to: Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot more MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.

This book is your guide to efficiently designing and structuring databases using MySQL. Through practical insights, you will learn how to organize data effectively and design with an emphasis on future growth and performance. By following this book's tips, you'll be able to streamline the backend of your applications and improve their robustness and scalability. What this Book will help me do Understand how to collect and organize data for a MySQL database. Master structuring database schemas for optimal performance. Learn about data security and applying privileges and views. Gain techniques to document and visualize data effectively. Develop and validate relational database structure with SQL queries. Author(s) Marc Delisle is an experienced database practitioner and an advocate for practical database design. With years of expertise in MySQL, Marc has helped numerous organizations optimize their data handling strategies. His writing simplifies complex concepts and focuses on empowering readers to apply lessons directly to real projects. Who is it for? This book is intended for software developers or IT professionals who handle applications with MySQL databases. It suits those with beginner to intermediate SQL and MySQL knowledge aiming to enhance their database design skills. Readers seeking practical, hands-on techniques for efficient database structuring will find this book invaluable. By learning the provided methods, readers can ensure their databases perform reliably in production environments.

The IBM Tivoli Change and Configuration Management Database Configuration Discovery and Tracking v1.1 (CDT) is an agentless deep discovery tool that can discover the configuration information of application systems as well as their components and relationships automatically. It also discovers installed hardware and software components in a complex computer server environment and tracks changes to all these components over time. IBM Tivoli CCMDB CDT v1.1 is the core component of the IT Service Management strategy from IBM and fills the role of the Change Management Database for your implementation of ITIL aligned IT processes. This IBM Redbooks publication provides help and recommendations on how to get started deploying Configuration Discovery and Tracking v1.1 and provides step-by-step instructions for setting up and customizing the discovery in your own environment. In addition, it describes the various interfaces that you can use to integrate CDT with your existing IT Service Management processes. The information in this book is intended for IT specialists who design and implement IT Service Management solutions based on IBM Tivoli CCMDB Configuration Discovery and Tracking v1.1.

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to: Wrangle data in the most efficient way possible Aggregate and organize your data for meaningful and accurate reporting Make the most of subqueries, joins, and unions Stay on top of the performance of your queries and the server that runs them Avoid common SQL security pitfalls, including the dreaded SQL injection attack Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.

Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season? MySQL, the most popular open-source database, offers the power ofa relational database in a package that's easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data. After covering the basics, the book travels far into MySQL'ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-keeping such as backups and security. Topic include: Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using thePHP and Perl programming languages The authors, Saied Tahaghoghi and Hugh E. Williams, have careers inacademia and business, and share a keen interest in research intosearch technologies. Whether you've never touched a database or have already completedsome MySQL projects, you'll find insights in Learning MySQLthat will last a career.

"Practical PHP and MySQL reflects Jono's commitment to the spirit of making open source subjects accessible to everyone. The book carefully walks you through the code for eight useful, dynamic Web applications. Projects are presented in a playful way, like the forum project that touts horror movies that make you 'hide behind the couch.'" -From the Foreword by Christopher Negus, Series Editor, Negus Live Linux Series Build Dynamic Web Sites Fast, with PHP and MySQL... Learn from Eight Ready-to-Run Applications! Suddenly, it’s easy to build commercial-quality Web applications using free and open source software. With this book, you’ll learn from eight ready-to-run, real-world applications—all backed by clear diagrams and screenshots, well-documented code, and simple, practical explanations. Leading open source author Jono Bacon teaches the core skills you’ll need to build virtually any application. You’ll discover how to connect with databases, upload content, perform cascading deletes, edit records, validate registrations, specify user security, create reusable components, use PEAR extensions, and even build Ajax applications. Working from complete examples on the CD-ROM, you’ll create Generic dynamic Web sites Blogs Discussion forums Shopping carts Auction sites Calendars FAQ systems Reusable components Content management systems News sites JONO BACON is Ubuntu community manager for Canonical, Ubuntu’s sponsor. He is an established speaker, author, and contributor to the open source community. Bacon co-authored Linux Desktop Hacks and The Official Ubuntu Book; has served as a columnist for Linux Format, Linux User & Developer, and PC Plus; and is an O’Reilly Networkweblog author. He is a lead developer onthe Jokosher (www.jokosher.org) project,and co-founder of LUGRadio—a podcastwith more than 15,000 listeners, andan annual event that attracts visitorsfrom around the world. CD-ROM Includes XAMPP for Linux: easy-to-install, preconfigured Apache distributions containing MySQL, PHP, Perl, and more Source code for all eight fully-working applications discussed in the book A remastered Ubuntu live CD, set to run all eight applications live System Requirements CPU: Pentium III, 650 MHz. RAM: 256MB (recommended 512MB). Hard disk: No space required to run live CD; 250MB of space needed to put XAMPP server and projects on installed system.

Typical Microsoft Exchange environments are growing larger and increasingly are managing data and applications critical to a business. This makes backup and restore a greater challenge. Microsoft Volume Shadow Copy Service (VSS) is a way to use the instant copy capabilities of disk storage hardware for faster backup, thereby reducing the time taken for backup as well as reducing the impact which the backup operation has on the Exchange server.

Modern Surveying is unimaginable without the use of electronic equipment and information technology. Surveying with conventional systems has been completely replaced with advanced automated systems. Total Station, Global Positioning System (GPS), Remote Sensing and Geographical Information System (GIS) have all become an inextricable part of surveying. Advanced Surveying: Total Station, GIS and Remote Sensing provides a thorough working knowledge of these technologies.

Java Persistence with Hibernate explores Hibernate by developing an application that ties together hundreds of individual examples. You'll immediately dig into the rich programming model of Hibernate 3.2 and Java Persistence, working through queries, fetching strategies, caching, transactions, conversations, and more. You'll also appreciate the well-illustrated discussion of best practices in database design, object/relational mapping, and optimization techniques. In this revised edition of Manning's bestselling Hibernate in Action, authors Christian Bauer and Gavin King—the founder of the Hibernate project—cover Hibernate 3.2 in detail along with the EJB 3.0 and Java Persistence 1.0 standards. The book ends with detailed coverage of JBoss Seam, a revolutionary web application framework for Java EE that builds on EJB 3.0, JavaServer Faces, and Hibernate concepts. About the Technology Persistence—the ability of data to outlive an instance of a program—is central to modern applications. Hibernate, the most popular Java persistence tool, provides automatic and transparent object/relational mapping so it's a snap to work with SQL databases in Java applications. Hibernate conforms to the new EJB 3.0 and Java Persistence 1.0 standards. About the Book What's Inside O/R mapping concepts Get started with Hibernate and Java Persistence Efficient database application design Comprehensive Hibernate and Java Persistence reference Unmatched breadth and depth About the Reader About the Authors Christian Bauer is a member of the Hibernate developer team and a trainer, consultant, and product manager for Hibernate, EJB 3.0, and JBoss Seam at JBoss. Gavin King, a lead developer at JBoss, is the founder of the Hibernate project, and a member of the EJB 3.0 (JSR 220) expert group. He also leads the Web Beans JSR 299, a standardization effort involving Hibernate concepts, JSF, and EJB 3.0. Quotes ...this book is the ultimate solution. If you are going to use Hibernate in your application, you have no other choice, go rush to the store and get this book. - Meera Subbarao, JavaLobby "Java Persistence with Hibernate" is the most comprehensive, authoritative and definitive guide, tutorial, and reference to OR-mapped Java persistence. - Will Wagers, C#online.net A definitive source on Hibernate. Great for any developer. - Patrick Peak, CTO, BrowserMedia, Author of Hibernate Quickly I wholeheartedly recommend this book! - Stuart Caborn, Thoughtworks Great topic, great content, and there is a great need for this book! - Ryan Daigle, RTP Region, ALTERthought ...very thorough, very complete. I highly recommend it. - Patrick Dennis, Java Developer Management Dynamics Inc. A must-read for developers using Hibernate. - Dan Dobrin, BEA Systems It's the best book out there about Hibernate (and there are quite a few on the market right now), maybe even the best book about ORM in Java, in general. - Adrian Spinei, Real Life, beta version

IBM Tivoli Workload Scheduler is an IBM strategic scheduling product that runs on different platforms including the mainframe. The new version of the product, IBM Tivoli Workload Scheduler V8.3, comes with some important enhancements, such as relational database management system (RDBMS) support, new advanced planning system, which allows the definition of plans that span more that 24 hours, removal of framework requirements, new application programming interface (API), Job Scheduling Console enhancements, and so on. This IBM Redbooks publication documents the architecture, deployment, best practices, and migration scenarios for IBM Tivoli Workload Scheduler V8.3 on distributed environment. In addition, we cover IBM Tivoli Workload Scheduler V8.3 security, IBM DB2 and IBM WebSphere considerations, troubleshooting, tuning for performance, application programming interface, and JnextPlan, which has replaced the JnextDay process in this release. Clients and Tivoli professionals who are responsible for installing, administering, maintaining, or using IBM Tivoli Workload Scheduler V8.3 will find this book a major reference.

• SAP is investing billions to redesign its flagship R/3 product line based on its ESA, and that ESA will become the standard framework for developing all new SAP ERP applications with NetWeaver * This book provides an overview of the core building blocks of SAP's new ESA, and shows how ESA works with the NetWeaver platform as well as mySAP ERP * A step-by-step action plan proposes ideas for designing ESA-based SAP applications * The companion Web site contains in-depth case examples that show how to build various SAP services and applications using the NetWeaver development tools, plus third-party tools * Some of the SAP tools covered include NetWeaver Developer Studio, WebDynPro and NetWeaver Portal, NetWeaver BI, and the SAP Composite Application Framework

Direct from Microsoft Insiders: the Complete Hands-On Guide to SQL Server 2005’s Powerful Tools! Microsoft SQL Server 2005’s high-powered management tools can dramatically improve DBA productivity and effectiveness. Now there’s a comprehensive guide to SQL Server 2005’s toolset, straight from the Microsoft team that created it. This book covers the entire toolset in unprecedented depth, guides database professionals in choosing the right tools, and shows them how to use various tools collectively to solve real-world problems. The authors present “how-to” solutions and never-before-published tips for SQL Server 2005 installation, upgrades, configuration, authoring, schema design, development, deployment, optimization, troubleshooting, and more. Coverage includes  Understanding how SQL Server 2005 tools differ from their predecessors  Leveraging the new Business Intelligence Development Studio and Management Studio to accomplish dozens of common tasks  Improving security by reducing the “surface area” you expose  Executing queries with the new Query Editor and SQLCMD query tools  Optimizing with the revamped SQL Server Profiler and Database Engine Tuning Advisor  Scheduling maintenance tasks with the SQL Server Agent  Monitoring with the Activity Monitor, SQL Server Agent, and other tools  Moving data efficiently and reliably with Integration Services  Using SQL Server’s new e-mail tool, Database Mail  Managing replication in complex distributed environments  Mastering SQL Server’s Analysis Services’ OLAP and Data Mining tools  Using Notification Services 2.0, Reporting Services, and more  Extending functionality using underlying APIs and the included CD-ROM’s sample code. MICHAEL RAHEEM is the senior product manager of the Microsoft SQL Server team and led the design and implementation of several SQL Server tools, such as SQL Server Management Studio, Database Mail, Upgrade Advisors, and Surface Area Configuration. He currently leads the SQL Server enterprise marketing efforts including high availability, scalability, and performance. DIMA SONKIN is development lead in the SQL Server Tools group responsible for SQL Server Agent, SMO, DMO, SQL Profiler, Database Engine Tuning Advisor, Database Mail, SQLMail, SqlCmd, and OSQL. THIERRY D’HERS is the lead program manager on Microsoft’s SQL BI Analysis Services team and has spent five years designing and specifying Analysis Services tools. KAMI LEMONDS is the documentation manager for Microsoft’s SQL Server User Education team and contributed to the SQL Server 2000 Resource Kit. CD-ROM contains all sample code from the book and corresponding Visual Studio project files. Contents Foreword . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . xxvi About the Authors . . . . . . . . . . . . . . . . . . . . . . . xxvii Chapter 1 Inside the Fundamentals. . . . . . . . . . . . . . . . . . . . . 1 Chapter 2 Inside the Installation and Upgrade Tools. . . . . . . 23 Chapter 3 Inside the Configuration Tools . . . . . . . . . . . . . . . 73 Chapter 4 Inside Management and Administration Tools . . 129 Chapter 5 Inside Data Authoring Tools . . . . . . . . . . . . . . . . 181 Chapter 6 Inside SQLCMD Query Tools . . . . . . . . . . . . . . . . 199 Chapter 7 Inside Tuning and Optimization Tools . . . . . . . . . 237 Chapter 8 Inside Scheduling Tools . . . . . . . . . . . . . . . . . . . 273 Chapter 9 Inside Monitoring Tools. . . . . . . . . . . . . . . . . . . . 305 Chapter 10 Inside Email Tools . . . . . . . . . . . . . . . . . . . . . . . . 337 Chapter 11 Inside Programming Object Models . . . . . . . . . . 357 Chapter 12 Inside Replication Tools . . . . . . . . . . . . . . . . . . . 385 Chapter 13 Inside Analysis Services OLAP Tools . . . . . . . . . 429 Chapter 14 Inside Analysis Services Data Mining Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . 519 Chapter 15 Inside Notification Services Tools . . . . . . . . . . . 543 Chapter 16 Inside Integration Services Tools . . . . . . . . . . . . 601 Chapter 17 Inside the Reporting Services Tools . . . . . . . . . . 679 Appendix A Sample KPI Client Code— Retrieving and Exposing Your First KPI. . . . . . . . . . . . . . . . . . . . 711 Appendix B KPI Utilities—Code for Parsing Display Folders and Getting Image Indexes . . . . . . . . . . 713 Appendix C KPI Viewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 721 Appendix D Complete List of Data Mining Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 723 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 733

XML represents a fundamental change in computing. It allows applications to move away from proprietary file and data formats to a world of open data interchange. XML has become ubiquitous not only because of its range of applications, but also because of its ease of use. Although XML solves many problems by providing a standard format for data interchange, some challenges remain. In the real world, applications need reliable services to store, retrieve, and manipulate data. These services have traditionally been offered by DB2 for i5/OS. In this IBM Redbooks publication, we discuss the challenges of representing XML hierarchies in the relational database model. We provide an in-depth explanation of the three most popular approaches to bridge the hierarchy, the relational model dichotomy: Programmatically process the XML documents and map their hierarchy into a relational database. Use database middleware to handle the XML parsing and XML-to-relational database mapping. Use Extensible Stylesheet Language (XSL) Transformation to transform inbound XML documents directly to SQL scripts. We also share best practices and techniques aimed at streamlining the XML and DB2 for i5/OS integration. Please note that the additional material referenced in the text is not available from IBM.

Plug Yourself In with the Ultimate Guide to the Internet! EXHAUSTIVE INDEX: An exhaustive index with thorough cross-references helps you find exactly what you want, quickly and easily. INTERNATIONAL COVERAGE: International coverage makes your discoveries on the Web virtually limitless. SEARCH SECRETS: Michael Miller, along with Mikal Belicove and Joe Kraynak, have written the foreward that gets you up to speed on searching the Internet, blocking pop-up ads, protecting children online, accessing the wireless Web, plugging in to podcasts and webcasts, and reading fascinating weblogs (blogs). Use This Complete Guide to Web Surfing at Its Best: • Find new job opportunities • Find information and resources on all aspects of adoption • Download music from your favorite artists • Get tips, strategies, and information on improving your poker game • Get free technical support for your PC or Mac • Learn the ancient Chinese art of Feng Shui • Find sites devoted to men’s and women’s health and related issues Category Internet–Directories Covers The Internet and the World Wide Web User Level All In this Edition Icons identify unique information about each listed website BEST OF THE BEST This icon identifies THE best website in any given category. If you have time to visit only one site in a category, look for the Best of the Best! KID ICON The child-rating icon is designed to help you weed out sites that are inappropriate for children. BLOG ICON The blog icon identifies those sites that allow visitors to post comments and are interactive. PODCAST The Podcast icon identifies sites that provide audio-on-the-go content. WEBCAST The webcast icon identifies those sites that feature dynamic audio-visual content RSS FEED ICON The RSS Feed icon indicates, quickly and easily, those sites that offer live feeds in any given category. DIRECTORY ICON The Directory icon indicates websites that may not provide a lot of quality information on their own but instead point you to the best sites that deal with a particular topic. QUALITY INDICATOR The quality indicator icon rates sites on a scale of 1 to 5 based on content, appearance, and ease of use. Look for a ranking of 5 and you’ve found the most user-friendly sites. 789736292 100307

This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.

Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems. This book is recommended for database programmers with a good knowledge of SQL. A great collection of tricky SQL puzzles with a variety of solutions and explanations Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems New edition features: Many new puzzles added!, Dozens of new solutions to puzzles, and using features in SQL-99, Code is edited to conform to SQL STYLE rules, New chapter on temporal query puzzles, New chapter on common misconceptions about SQL and RDBMS that leads to problems

This IBM Redbooks publication is a study guide for Tivoli Provisioning Manager Express for Software Distribution V4.1 and is aimed at the people who want to get an IBM Professional Certification for this product.

The IBM System i family, which encompasses the IBM AS/400, eServer iSeries, eServer i5, and System i5, has a successful 24-year history of satisfying hundreds of customers' requirements, thanks to its developers. DB2 for i5/OS, also known as DB2 Universal Database for iSeries, is deeply rooted in the architecture and heritage of the AS/400 and its predecessor System/38. The database has undergone significant changes over the years to maintain its competitive advantage including fundamental changes to the structure of the database to compete successfully in the industry. In doing so, IBM Rochester launched a project to re-engineer and redesign important components of the database. The redesigned components were architected using object-oriented design concepts and then implemented using object-oriented implementation techniques. The query optimizer was one of the key components that was redesigned. This IBM Redbooks publication gives a broad understanding of the architectural changes of the database concerning the query optimizer. It explains the following concepts: The architecture of the query optimizer The data access methods used by the query optimizer The Statistics Manager included in V5R2 The feedback message changes of the query optimizer Some performance measurements Changes and enhancements made in V5R4 The objective of this book is to help you minimize any SQL or database performance issues when upgrading to OS/400 V5R2 or V5R3 or to IBM i5/OS V5R4. Prior to reading this book, you should have some knowledge of database performance and query optimization.

This IBM Redbooks publication provides an introduction to the Enterprise Workload Manager (EWLM) Version 2 Release 1. In addition to describing the overall product concept and functionality, it presents a detailed discussion of the elements that comprise an EWLM solution. Step-by-step instructions take you through the installation of EWLM code on multiple platforms, for both the domain manager and managed servers, and also show how to enable the instrumentation of the middleware for a 3-tier Web application. The features for administering EWLM are described, along with the monitoring, managing, and reporting capabilities. Sample scenarios implemented in the ITSO environment are used to guide you through the process of classifying workload and defining and deploying your own EWLM policy. These scenarios are then used to demonstrate the business goal based partition management capabilities of EWLM. Techniques for securing your EWLM domain as well as the load balancing capabilities of EWLM are described. Troubleshooting hints and tips are provided, along with some basic performance considerations to help you design the optimum EWLM solution. Please note that the additional material referenced in the text is not available from IBM.

The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL. Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master. Writing queries and updating data: all you need to know about SELECT Working with joins, functions, and subqueries Creating database objects: tables, indexes, views, and more Specifying keys and other integrity constraints Using indexes to improve efficiency Enforcing security via passwords and privileges Building stored procedures and triggers Developing with embedded SQL and ODBC Working with transactions, including rollbacks, savepoints, isolation levels, and more Optimizing performance by reformulating SQL statements Using object-relational features: subtables, references, sets, and user-defined data types Reference section: SQL statement definitions and SQL function lists

This IBM Redbooks publication introduces the IBM Problem Determination and Deployment Tools for z/OS and OS/390. The tools covered are: -> IBM Application Performance Analyzer for z/OS Version 1 Release 1 This comprehensive suite of powerful yet easy-to-use tools helps developers to efficiently build, test, and service applications while minimizing errors and increasing cost-effectiveness. The tools allow users to quickly identify and resolve problems that occur in batch, IMS, DB2, CICS, and UNIX System Services applications. For each tool, this book provides step-by-step instructions for installation and customization, a detailed discussion of the features and capabilities, and guidance for using the tool in your environment.

This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70443) Addresses the database tasks that the MCITP exam focuses on such as design, development, deployment, optimization, maintenance, and support Reviews key topics, including defining high availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and much more The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

In-depth coverage of Microsoft’s powerful new data integration tool Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.