This IBM Redbook introduces the IBM System z9 109 (z9-109), which offers a continuation of the IBM scalable mainframe servers. The z9-109 server is based on z/Architecture and provides extensions to the architecture. In addition to increased performance and expansion options, particular emphasis has been placed on the integration of the z9-109 into a complete system and software environment.

MS/VCR provides a fast, reliable facility with high integrity for the renaming and recataloging of data sets on target volumes after a FlashCopy or Snapshot volume copy, solving the cloned data access dilemma. This facility enables the immediate use of the data from the same system as the original copy. MS/VCR resolves catalog conflicts of like-named datasets that are created by "cloning" a volume. It also solves internal conflicts that are created when copying a volume to a different VOLSER. MS/VCR is designed to rename and catalog target volume datasets in record time. The window of time required to copy and rename a target dataset is a critical factor for many customers. This IBM Redbooks publication provides a broad understanding of the MS/VCR product and how to use it in real situations.

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.

This IBM Redbooks publication provides advice for Business Partners or other technical people about how to plan, implement, and demonstrate IBM Tivoli Storage Manager Version 5.3 in a proof-of-concept simulated environment. This environment can be used to demonstrate the capabilities of the IBM Tivoli Storage Manager solutions using customer data, in order to gain customer acceptance for the next phase of the sell cycle to engage the Business Partner in a real proof-of-concept of IBM Tivoli Storage Manager. Please note that the additional material referenced in the text is not available from IBM.

Deploying and managing distributed systems in hundreds or thousands of branch banks and retail stores, called outlets, requires careful planning of the automation to cope with the sheer numbers of systems involved. This IBM Redbooks publication demonstrates how to architect, establish, and configure a Tivoli systems management environment that supports the central management of thousands of outlet systems based on the open United Linux platform. The main focus of this book is to provide step-by-step instructions, sample scripts, and code to install and deploy the core Tivoli products that enable the organization to: - Deploy and maintain distributed application solutions This book is intended for IT professionals with a basic understanding of the core Tivoli product set and who are responsible for deploying a Tivoli management infrastructure. Please note that the additional material referenced in the text is not available from IBM.

In development scenarios where things can't be run in a debugger, or when you run the risk of masking the problem, logs are the greatest source of information about running a program. Pro Apache Log4j, Second Edition provides best practices guidelines and comprehensive coverage of the most recent release. Step by step, the book explains core concepts, from basic to advanced. Code samples are in Java and include guidelines for different application-specific needs. You’ll also learn how to extend the API to write custom components and best practices for using the feature-rich log4j API. This book concludes with enterprise Java applications using log4j with JSP and J2EE.

This IBM Redbooks publication is an easy-to-follow guide that describes how to implement IBM Tivoli Storage Manager Version 5.3 products in highly available clustered environments. The book is intended for those who want to plan, install, test, and manage the IBM Tivoli Storage Manager Version 5.3 in various environments by providing best practices and showing how to develop scripts for clustered environments. The book covers the following environments: IBM AIX HACMP, IBM Tivoli System Automation for Multiplatforms on Linux and AIX, MicrosoftCluster Server on Windows 2000 and Windows 2003, VERITAS Storage Foundation HA on AIX, and Windows Server 2003 Enterprise Edition. Please note that the additional material referenced in the text is not available from IBM.

With the help of the Internet and accompanying tools, creating and publishing online maps has become easier and rich with options. A city guide web site can use maps to show the location of restaurants, museums, and art venues. A business can post a map for reaching its offices. The state government can present a map showing average income by area.Developers who want to publish maps on the web often discover that commercial tools cost too much and hunting down the free tools scattered across Internet can use up too much of your time and resources. Web Mapping Illustrated shows you how to create maps, even interactive maps, with free tools, including MapServer, OpenEV, GDAL/OGR, and PostGIS. It also explains how to find, collect, understand, use, and share mapping data, both over the traditional Web and using OGC-standard services like WFS and WMS.Mapping is a growing field that goes beyond collecting and analyzing GIS data. Web Mapping Illustrated shows how to combine free geographic data, GPS, and data management tools into one resource for your mapping information needs so you don't have to lose your way while searching for it.Remember the fun you had exploring the world with maps? Experience the fun again with Web Mapping Illustrated. This book will take you on a direct route to creating valuable maps.

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to: Deploy the right MySQL product for your performance needs. Set up a performance management and monitoring environment using tools from MySQL. Implement the right indexing strategy Apply good performance strategy when developing software to work with the MySQL database. Configure dozens of variable to correctly tune the MySQL engine. If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.

Since the dawn of creation, man has designed maps to help identify the space that we occupy. From Lewis and Clark's pencil-sketched maps of mountain trails to Jacques Cousteau's sophisticated charts of the ocean floor, creating maps of the utmost precision has been a constant pursuit. So why should things change now? Well, they shouldn't. The reality is that map creation, or "cartography," has only improved in its ease-of-use over time. In fact, with the recent explosion of inexpensive computing and the growing availability of public mapping data, mapmaking today extends all the way to the ordinary PC user. Mapping Hacks, the latest page-turner from O'Reilly Press, tackles this notion head on. It's a collection of one hundred simple--and mostly free--techniques available to developers and power users who want draw digital maps or otherwise visualize geographic data. Authors Schuyler Erle, Rich Gibson, and Jo Walsh do more than just illuminate the basic concepts of location and cartography, they walk you through the process one step at a time. Mapping Hacks shows you where to find the best sources of geographic data, and then how to integrate that data into your own map. But that's just an appetizer. This comprehensive resource also shows you how to interpret and manipulate unwieldy cartography data, as well as how to incorporate personal photo galleries into your maps. It even provides practical uses for GPS (Global Positioning System) devices--those touch-of-a-button street maps integrated into cars and mobile phones. Just imagine: If Captain Kidd had this technology, we'd all know where to find his buried treasure! With all of these industrial-strength tips and tools, Mapping Hacks effectively takes the sting out of the digital mapmaking and navigational process. Now you can create your own maps for business, pleasure, or entertainment--without ever having to sharpen a single pencil.

This IBM Redbooks publication provides practical information related to problem determination using IBM Self-Managing Autonomic Technology, with an emphasis on the components provided by the IBM Autonomic Computing Toolkit. The primary objective of this book is to empower software developers to provide facilities to enable applications or other system components to participate in an autonomic environment and focuses on the problem determination capabilities provided by the IBM Autonomic Computing Toolkit and other Self-Managing Autonomic Technology. The tools, components, and techniques used and demonstrated in this book provide the base for automating problem determination and self-healing of applications and components using Self-Managing Autonomic Technology. As with the technologies themselves, components of the IBM Autonomic Computing Toolkit will evolve as new capabilities and tools become available. Software developers are encouraged to check the latest releases of both IBM Autonomic Computing Toolkit and other tools provided by IBM at http://www.ibm.com/developerworks/autonomic. Please note that the additional material referenced in the text is not available from IBM.

DFSMSrmm from IBM is the full function tape management system available in OS/390 and z/OS. With DFSMSrmm, you can manage all types of tape media at the shelf, volume, and data set level, simplifying the tasks of your tape librarian. Are you a new DFSMSrmm user? Then this IBM Redbooks publication introduces you to the DFSMSrmm basic concepts and functions. Are you already using DFSMSrmm? In that case, this book provides the most up-to-date information about the new functions and enhancements introduced with the latest release of DFSMSrmm. You will find useful information for implementing these new functions and getting more benefits from DFSMSrmm. Do you want to test DFSMSrmm functions? If you are using another tape management system and are thinking about converting to DFSMSrmm, you may start DFSMSrmm and run it in parallel to your current system for testing purposes. This book is intended to be a starting point for new professionals and a handbook for using the basic DFSMSrmm functions. Please note that the additional material referenced in the text is not available from IBM.

IBM Tivoli Workload Scheduler is a strategic, multiplatform distributed scheduling product that provides high-volume, complex scheduling capability. Although Tivoli Workload Scheduler provides native support for many platforms and applications, its robust scheduling capabilities can be extended to cover additional platforms and applications by writing an extended agent. This IBM Redbooks publication shows how to write a Tivoli Workload Scheduler Version 8.2 extended agent to schedule jobs on IBM Tivoli Storage Manager. With the extended agent, you can schedule on platforms and applications for which Tivoli Workload Scheduler has no native agent, as well as integrate IBM Tivoli Storage Manager with Tivoli Workload Scheduler. The Tivoli Workload Scheduler scheduling facility enables you to assign dependencies among tasks scheduled through Tivoli Storage Manager or to assign limits or priorities. By extending Tivoli Storage Manager to schedule these Tivoli Storage Manager tasks, you can take advantage of its advanced scheduling capabilities. This book will be essential for those who write a Tivoli Workload Scheduler extended agent for any platform in general, or use the extended agent provided in this book (TSM Extended Agent) to schedule Tivoli Storage Manager tasks. Please note that the additional material referenced in the text is not available from IBM.

Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. Toad makes developers far more productive; using Toad, you'll find that program changes that once took hours can now be completed in minutes. Toad allows developers to browse their database tables, procedures, and object types; use code templates; and show errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics. Updated for Toad Versions 8.0 and 8.5, this pocket book is packed with quick-reference material: Toad feature and menu summaries, shortcut keys, suggested changes to Toad defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic Toad components: the SQL Editor, Procedure Editor, SQL Modeler, Schema Browser, Project Manager, and Debugger. The second edition includes coverage of new SQL Editor features, improvements in usability, and new tools such as CodeXpert (a robust code analyzer and advisor) and Script Debugger (the only tool available that provides real-time debugging of SQL*Plus scripts). It also provides helpful hints on using Toad to perform database administration and SQL tuning and optimization. Whether you're a new or experienced Toad user, you'll find this quick reference an indispensable companion to the product and its online help files.

This IBM Redbooks publication prepares you with the necessary knowledge to help you complete Certification Test 593: IBM Tivoli Monitoring V5.1.1 Implementation . This test leads to certification for Tivoli Certified Deployment Professional for IBM Tivoli Monitoring. The scope of the certification tests your ability to demonstrate the following areas of expertise required for IBM Tivoli Monitoring V5.1.1: Prerequisite knowledge for IBM Tivoli Monitoring Planning the implementation Installation prerequisites The installation process Configuration of the IBM Tivoli Monitoring server Problem determination General operations IBM Tivoli Monitoring Workbench You can find the information that you need about these topics all in this book. Plus, you have a chance to test your knowledge using the sample questions at the back of the book.

This IBM Redbooks publication explains the benefits and technical merits of integrating IBM Tivoli Workload Scheduler Distributed and IBM Tivoli Workload Scheduler for z/OS with other IBM products. Scheduling is a mission critical process for any company. However, when you talk about scheduling, you are really talking about an ecosystem. In this ecosystem, each solution is a building block that adds value to the overall solution. With IBM Tivoli Workload Scheduler, you can collect and add data to and from each component. In addition, expanding the scheduling ecosystem to include monitoring, management, help desk, storage, and business systems management provides greater value. Please note that the additional material referenced in the text is not available from IBM.

Mid-market companies are looking for complete solutions from the solution providers who know their businesses and specialize in a particular solution category such as warehouse management or supply chain integration, within their industry. In order to provide an environment for the business solution, either the solution provider or the end customer must obtain the software needed to run the provider’s application program. This software normally consists of a database, a Web server, and an application server. These components, which are not actually part of the business solution, but are required to support the application program, are called middleware. The process of obtaining, installing, configuring, and supporting the middleware components is a complex process for the solution provider, who currently has to absorb the cost of setting up the environment. The provider has to work with multiple suppliers who have multiple terms and conditions, different license structures, and multiple departments to work with on the contracts and support structures, all of which leads to added infrastructure costs and inefficiency. IBM designed the Express Runtime offering to address the needs of the solution providers serving mid-market customers. The main design criteria were reducing complexity for the providers by offering a pre-integrated and pre-configured middleware solution with a single contract, one license, one set of contracts, and a very competitive price. With Express Runtime, you get WebSphere Application Server - Express, DB2 UDB Express, and IBM HTTP Server with a single install, one contract, and a significantly lower cost compared to purchasing the individual components. Express Runtime includes quick start samples and documentation to get you up and running quickly and easily. Please note that the additional material referenced in the text is not available from IBM.

See how XML works for business needs and RSS feeds Create consistency on the Web, or tag your data for different purposes Tag -- XML is it! XML tags let you share your format as well as your data, and this handy guide will show you how. You'll soon be using this markup language to create everything from Web sites to business forms, discovering schemas and DOCTYPES, wandering the Xpath, teaming up XML with Office 2003, and more. Discover how to * Make information portable * Use XML with Word 2003 * Store different types of data * Convert HTML documents to XHTML * Add CSS to XML * Understand and use DTDs

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students’ SQL style issues, Joe Celko can help you become an even better SQL programmer. Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people. Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style. Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language — one that someone else might not know!

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too-- no programming experience required! After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage. Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..