The Easy, Visual Guide to IBM DB2 V8.2 IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM. Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more. Understanding DB2 For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations. Coverage includes Understanding the DB2 product family, DB2 commands, and the DB2 environment Configuring client and server connectivity: walkthroughs of four typical scenarios Managing DB2 storage: partitions, tablespaces, buffer pools, and more Leveraging the power of SQL: queries, inserts, deletes, and updates Implementing security: encryption, authentication, and authorization Administering and maintaining data, from LOAD and EXPORT to backup/recovery Providing high availability with online split mirroring and suspended I/O DB2 architecture: process and memory models Managing database performance and troubleshooting

“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.” — Duncan Mackenzie, developer, Microsoft (MSDN) “Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.” — Patrick Birch, database and technical writing consultant “If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.” — Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP “A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!” — Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.” — Paul Irvine, vice president, engineering, Via Training “Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!” — Mike Gunderloy, contributing editor, Application Development Trends “This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.” — Amy Sticksel, Sticksel Data Systems, Inc. “In Riordan’s style, wit, and attention to detail are outstanding.” Designing Effective Database Systems, — Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database Design World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, shows you how to design an effective, high-performance database to solve it. Designing Effective Database Systems Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications. One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability. This book will teach you to Understand relational database models, structures, relationships, and data integrity principles Define database system goals, criteria, scope, and work processes Construct accurate conceptual models: relationships, entities, domain analysis, and normalization Build efficient, secure database schema Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more Architect and construct easy, efficient interfaces for querying and reporting Learn from practice examples based on Microsoft’s Northwind sample database Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.

The need to integrate heterogeneous environments without replacing existing IT infrastructures is growing more and more. Standard application providers offer a wide range of business applications, running on different platforms, and implemented in different languages. A sophisticated Enterprise Service Architecture is required to overcome the challenges implied by such a heterogeneous infrastructure and make the whole enterprise controllable. The WebSphere Business Integration architecture provides different Integration brokers and a multitude of application and technology adapters. It is an essential software component in IBM's e-business on demand strategy. SAP Exchange Infrastructure is SAP’s strategic technology platform for process integration and connectivity of SAP components and non-SAP components. This IBM Redbooks publication illustrates how to integrate data and processes located in SAP back-end systems using WebSphere Business Integration middleware technology. It describes two WebSphere Business Integration adapters: IBM WebSphere Business Integration Adapter for SAP V5.5.0 These adapters are utilized to demonstrate the integration capabilities they provide. Please note that the additional material referenced in the text is not available from IBM.

Managing IT costs requires repeatable and measurable processes such as the best practices for service level management (SLM) documented in the IT Infrastructure Library (ITIL). Central to the ITIL best practices are the service management processes. These are subdivided into the core areas of service support and service delivery. This IBM Redbooks publication takes a top-down approach that starts from the business requirement to improve service management. This includes the need to align IT services with the needs of the business, to improve the quality of the IT services delivered, and to reduce the long-term cost of service provision. It focuses on how clients accomplish this by implementing SLM processes supported by IBM Tivoli Service Level Advisor and IBM Tivoli Business Systems Manager. For IT managers and technical staff who are responsible for providing services to their customers, use this book as a practical guide to SLM with IBM Tivoli products. It takes you from a general outline of SLM to specific implementation examples of banking and trading that incorporate the Tivoli monitoring products.

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides: Clear and concise information on database administration with Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Installing Oracle Database 10g Software Creating and Controlling Oracle Databases Administering Users Managing Schema Objects and Data Implementing Oracle Security Features Monitoring Performance Performing Database Backup and Recovery Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

This IBM Redbooks publication describes how to install and configure the Cisco MDS 9000 family in an IBM Fibre Connection (FICON), Fibre Channel Protocol (FCP), and Fibre Channel over IP (FCIP) environment. We have tried to consolidate as much of the critical information as possible while covering procedures and tasks that are likely to be encountered on a daily basis. Each of the products described has much more functionality than we could ever hope to cover in just one book. The IBM/Cisco SAN portfolio is rich in quality products that bring a vast amount of technicality and vitality to the SAN world. Their inclusion and selection is based on a thorough understanding of the storage networking environment that positions Cisco and IBM, and therefore its customers and partners, in an ideal position to take advantage by their subsequent deployment. In this book we cover the latest announcements related to the IBM/Cisco SAN family. We show how these announcements and the products can be implemented in both a mainframe and an open systems environment. We address some of the key concepts that they bring to the market, and in each case, we give an overview of those functions that are essential to building a robust SAN environment in an effective and concise manner.

This book explains how to architect and deploy high availability (HA) solutions with Oracle Real Application Clusters (Oracle RAC) in a Sun™ Cluster 3.x environment. It presents information to help you decide when an Oracle RAC and Sun Cluster software solution is appropriate to satisfy the availability requirements of your business. In addition, this book explains the technology behind these products, describes successful customer deployments, and provides technical tips and preferred practice recommendations. This book features detailed case studies, including A large German bank that has implemented an Oracle RAC and Sun Cluster software solution to meet the ever-increasing business demands of the banking industry. One of the largest companies in Europe for alpine skiing that has implemented Oracle RAC and Sun Cluster software to support HA requirements in a consolidated environment. A benchmark case that describes the use of Oracle RAC with Sun’s Remote Shared Memory (RSM) technology to improve the performance of single-instance databases. A large financial institution that uses Sun Cluster’s HA Oracle agent to provide the necessary level of HA required for their database.

This IBM Redbooks publication provides an overview of the new functions and enhancements in IBM Information Management System (IMS) Version 9. IMS Version 9 contains over 50 enhancements, in all areas of the product. that address availability, scalability, capacity, usability, manageability, operations, on demand business, and application development requirements from its huge customer base. All of the enhancements in this new version resulted from specific customer requirements. The major enhancements include: Improved database availability for HALDB databases is provided by the long-awaited online reorganization (OLR) enhancement. The functionality of the IMS Connect product is included as an integrated function of IMS. DBRC provides a new API that allows assembler programs to query the RECON. IMS Java users will have new JDBC SQL calls and DLI Model Utility support for retrieving existing IMS data in XML format as well as storing, indexing, searching, and retrieving valid XML documents into new or existing IMS databases. We describe these enhancements and all other major changes in IMS Version 9. This book gives you the essential information that you need when you are migrating your IMS systems to IMS Version 9.

This IBM Redbook describes configuration management in general and how it is implemented in the Rational products ClearCase and ClearQuest. The target audience for this redbook is anyone considering a software configuration management (SCM) solution, and in particular, project managers and configuration management leaders responsible for medium and large UCM deployments. In Part 1 we introduce the general concept of software configuration management (SCM), and why software asset and lifecycle management is good business. We describe an SCM strategy that leads to the ClearCase and ClearQuest products. In Part 2 we provide the details for planning and implementing SCM using a ClearCase environment, focusing on the test environment, network, servers, and clients. In Part 3 we introduce ClearQuest, its terminology, the roles and responsibilities of the different types of users, and the infrastructure required for a UCM environment. We also provide the details for planning and implementing ClearQuest. In Part 4 we introduce unified change management (UCM) using ClearCase UCM and ClearQuest, including design considerations for an effective UCM implementation, and how UCM is used to manage complexity by raising the level of abstraction. In Part 5 we describe how to do parallel development in multiple geographical locations using ClearCase and ClearQuest MultiSite, including detailed procedures for planning and implementing MultiSite for a UCM environment.

Small and medium-sized businesses are among the fastest-growing segments of the global economy. As these businesses strive to capture opportunities in a rapidly changing marketplace, they often turn to independent software vendors (ISVs) for the IT solutions they need. Large enterprises also require customized solutions to help them stay competitive in the global marketplace. This IBM Redbooks publication describes how ISVs and corporate information technology centers can use IBM Integrated Runtime V1.1 to deploy solutions to their customers quickly and efficiently. By reducing the complexity of deploying complete solutions, Integrated Runtime shortens time-to-market for ISVs and reduces time-to-productivity for users. The result is efficient deployment of solutions by ISVs and corporate technology departments, rapid access to new solutions by users, and improved customer satisfaction. This book is intended for: Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication discusses Portable Data Containers. Portable Data Containers are a tool that allows customers to migrate their applications from UNIX to Linux more seamlessly. They are a part of VERITAS Storage Foundations 4.0. With Portable Data Containers, a customer can migrate an application without moving that application's data. This book describes the concepts of storage management and the key features of VERITAS Storage Foundations 4.0 and . In addition, it discusses a number of considerations that you should review prior to a UNIX to Linux migration, and then takes you through a step-by-step migration from Solaris to Linux. It discusses the performance and scalability of Portable Data Containers and compares the throughput of Portable Data Containers with theoretical network throughput and disk transfer speeds. Finally, this book includes best practices for migrating applications to Linux using Portable Data Containers. In particular, it identifies the steps that are required to migrate an Oracle or DB2 database from a UNIX server to a Linux server. With this knowledge, customers can accelerate their migration plans to Linux to take advantage of the cost benefits provided by the open-source operating system. The audience for this book are IBM Clients and Business Partners as well as IT specialists and database administrators.

You own your own business. You have also created a website for your business that details the products or services that you offer, but it doesn't allow potential customers to purchase anything online. Don't risk losing business-learn to create a dynamic online environment using only three programs. PHP, MySQL and Apache are three popular open-source tools that can work together to help you create a dynamic website, such as an online shopping experience. Sams Teach Yourself PHP, MySQL and Apache All in One is a complete reference manual for all three development tools. Learn how they work individually and more importantly, how they work together to create your dynamic website. Use the book and the included CD to create a simple website, as well as a mailing list, online address book, shopping cart and storefront. Open your website to limitless possibilities with Sams Teach Yourself PHP, MySQL and Apache All in One.

This IBM Redbooks publication is a practical cookbook that provides up-to-date information about Cluster Systems Management (CSM) for AIX 5L for a pSeries environment. The book provides information about the latest CSM for AIX 5L enhancements, including implementation techniques, installation changes, installation tools, system management tools, monitoring tools, hardware control, file distribution, problem determination, and management server high availability. This book summarizes the latest news in CSM 1.4.0. It contains a Q&A chapter, a CSM installation scenario, a CSM advanced chapter, CSM migration scenarios, and a CSM cluster administration chapter. We include information about how to manage Linux nodes on pSeries hardware including operating system installation and node management in a mixed cluster environment. This book is targeted to technical professionals (consultants, IT architects, and IT specialists) who are responsible for providing pSeries clustering solutions.

The newest addition to the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Author David Kurtz is a field expert and provides answers to common questions that arise when using PeopleSoft on an Oracle database. Kurtz begins the book with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Kurtz transitions smoothly between subsequent chapters, explaining database structures, connectivity, keys and indexing, the PeopleSoft DDL, and tablespaces. Kurtz gives appropriate weight to advanced topics as well, like schemas, performance metrics, performance monitoring utilities, and SQL optimization techniques. The final chapters provide crucial, advanced information about Tuxedo.

Build fast, high-performance Java database applications with Hibernate. Hibernate makes it far easier to build robust, high-performance database applications with Java. Now there's a practical, hands-on guide to using Hibernate's flexible, fast object/relational persistence and query services. Will Iverson covers every facet of development with Hibernate, from its mapping system toits advanced query mechanisms and transaction support. Iverson shows you how to build Hibernate solutions that can integrate with Swing, with JSP, and even with EJBs utilizing bean-managed persistence. Using realistic examples, he demonstrates how to work with persistent objects, manage schema, and optimize database application performance. After you've mastered Hibernate's core techniques, Iverson presents best practices, tips, tricks, and style guidance for even more effective development. Coverage includes Case study applications: starting from object/relational mapping files, Java code, and existing schema Writing Hibernate queries using HQL—Hibernate's object-oriented SQL extension Using Hibernate with Java-based Criteria and Example or native SQL The Hibernate mapping file format in detail: a complete reference How Hibernate handles class and database relationships Managing session and database transactions with Hibernate Tracking and optimizing performance with p6spy and IronTrack SQL Automatically generating DDL scripts that create, update, and drop tables Even if your Java database experience is limited to basic JDBC, this book will help you leverage Hibernate's remarkable power. You'll spend far less time writing code to bridge databases with Java applications—so you can get to market faster, with more features. © Copyright Pearson Education. All rights reserved.

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL Plus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database query the data dictionary tables customize an SQLPlus environment and much moreIt also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

IBM's definitive guide to writing DB2 SQL PL stored procedures, triggers, UDFs, and dynamic compound SQL Fully updated to reflect the entire DB2 UDB product family, and new SQL PL improvements for Windows, UNIX, Linux, iSeries, and zSeries Presents expert tips and best practices drawn from extensive experience in real customer environments Covers everything from basic program structure through advanced techniques Includes up-to-the-minute coverage of optimization and troubleshooting Using the IBM DB2 SQL Procedural Language (SQL PL), programmers can drive major improvements in database performance, manageability, and time-to-market. Now, IBM's own experts present the definitive guide to DB2 SQL PL development on any platform: Windows, UNIX, Linux, iSeries, or zSeries. DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions. The only book to combine practical SQL PL tutorials and a detailed syntax reference, DB2 SQL PL, Second Edition draws on the authors' unparalleled expertise with SQL PL in real business environments. Coverage includes Using SQL PL to improve manageability and performance, while clearly separating DBA and development roles Writing more efficient stored procedures, triggers, user-defined functions (UDFs), and dynamic compound SQL Identifying SQL PL performance bottlenecks--and resolving them Leveraging new language enhancements for Windows, UNIX, and Linux: improved table function support, session based locking, nested save points, new prepare options, and more Using new features for iSeries V5R3: built-in string and date/time manipulation functions, SEQUENCE objects, and more Utilizing zSeries Version 8's integrated stored procedures debugging and improved SQL Conditions support Mastering DB2 Development Center, the unified development environment for creating DB2 stored procedures Whether you're developing new SQL PL applications, migrating or tuning existing applications, or administering DB2, you'll find this book indispensable.

Customize Applications for Maximum Availability in Sun Cluster Environments The Sun Cluster 3 environment offers developers and administrators a powerful API for creating custom "data services" that maximize the availability and enhance the horizontal scalability of many enterprise applications. Now, here's an authoritative tutorial and reference to building custom data services with the Sun Cluster 3 API. In , three leading Sun Cluster experts systematically review the tools, programming interfaces, and features that make custom data services possible. Then, through a series of step-by-step examples, they demonstrate how to ensure that applications can recover smoothly from even the most serious failures. Sun Cluster 3 Programming This book Reviews every facet of "availability" and what it takes to make software available Provides extensive easy-to-understand code examples, all available for download Covers all areas of agent development, from quick basics to advanced techniques Covers all the APIs provided with Sun Cluster 3 Walks step-by-step through making existing applications available, scalable, and cluster-aware Until now, this information has been available only in a three-day Sun training course. Now, with the help of Sun's in-house experts, you have all the information you need to build Sun Cluster 3 custom applications that deliver unprecedented levels of application availability.

The Oracle SQL is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQL Plus Pocket Reference Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQL to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10 Plus Pocket Reference g features, this handy, on-the-job guide specifically shows readers how to: The new third edition of this book has been updated for Oracle Database 10 Differentiate between SQL and SQL Plus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQL Plus Specify SQLPlus commands and format elements Tune SQL queries g to include information on both SQL Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Plus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQL Oracle SQL Plus, the bestselling Plus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience. Oracle SQL

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day.As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Reference supplies--the syntax and options for whatever utility a DBA needs to perform a given task.Some of the utilities documented in this guide include: Packed with information in an easy-to-read format, this valuable resource is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the SQL*Loader, for loading data expdp and exp for exporting data to another database oradebug for use in troubleshooting loadjava and dropjava for loading and unloading Java programs Oracle Utilities Pocket Reference close at hand.Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "pocket reference" books.