This IBM Redbooks publication is a study guide for IBM Tivoli Access Manager for e-business Version 6 and is meant for those who want to achieve IBM Certifications for this specific product. The IBM Tivoli Access Manager for e-business Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM Tivoli Access Manager for e-business Version 6 product. This book provides a combination of theory and practical experience needed for a general understanding of the subject matter by discussing the planning, installation, configuration and customization, programming, auditing and troubleshooting of Access Manager for e-business solutions. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This publication does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool which, when combined with education activities and experience, can be a very useful preparation guide for the exam.

FileMaker 8 Functions and Scripts Desk Reference is the only book on the market expressly focused on describing each calculation formula and how and when to use each one. With this book's real-world, concrete examples of how to use each function, you will go far beyond FileMaker 8's help system. Just as a dictionary helps supplement one's memory, this book is an invaluable companion to users working to develop solutions to their every day software problems.

When an application is part of the Microsoft Office suite, it's sure to be a leader in its field. In the realm of desktop database management, Access is top dog with millions of users. But this is one dog that can bite. Although Access is a powerful, relational tool with the fetching talents of a Labrador, it's not an easy beast to train. Still, millions of users count on Access for everything from managing parts databases to running Web catalogs to working as a front end to mondo SQL databases. But Access is chockablock with annoyances---report hassles, query conundrums, VBA bugs, arcane error messages, and more. O'Reilly's Annoyances series offer real-world help, right now, and Fixing Access Annoyances continues tradition. You'll not only squash bugs and workaround Access' limits, but you'll learn how to use Access to the max, whether you're a newbie or a seasoned pro. Coverage includes install/configuration annoyances, building better tables and queries, creating forms that work right, generating reliable and sophisticated reports, pulling in data from a variety of sources, crafting macros and VBA code to customize Access, and much more. You could grab those other books for help, but do they solve problems from page one? Meet a book of a different stripe. The authors come armed with knowledge of the program's quirks, design hurdles and interface snags. They provide you with battle plans in Fixing Access Annoyances to save you time and bouts of hair pulling. Stop information from spiraling out of control when working with Access and trying to make this #$@@#$ thing work! Don't let its quirks, bugs, and troublemaking features beat you. Who you gonna call for help? Instead of waiting on the line for tech support or searching for the answer on the Internet with its too many resources to find exactly what you need, take control of databases with Fixing Access Annoyances, your partner on database adventures.

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on. Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005. Programming SQL Server 2005 can help you: Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it's beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts. Any IT professional who wants to learn about SQL Server 2005's comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.

This IBM Redbooks publication discusses running Linux under z/VM on IBM System z9 and zSeries platforms. We describe enhancements available in z/VM Version 5.1. The intended audience for this book is IT administrators responsible for installing and configuring z/VM 5.1 systems running Linux guests. Using Fibre Channel Protocol (FCP), z/VM 5/1 can be installed on and operate from SCSI disks. Configured as emulated Fixed Block Architecture (FBA) disks, z/VM 5.1 can use FCP-attached disks for its system paging, spooling, directory, and minidisks. z/VM 5.1 adds new functions for Virtual Switches (VSWITCH). For increased network security, guests must have authorization before connecting to a VSWITCH. z/VM 5.1 introduces VSWITCH Layer 2 support. Operating at Layer 2, a VSWITCH delivers and receives network traffic in Ethernet frames. This provides the ability to handle non-IP protocols such as SNA, NetBIOS, and IPX. In addition, Layer 2 support reduces network latency and CPU overhead.

This IBM Redbooks publication is a study guide for IBM Tivoli Monitoring Version 6.1 and is aimed at the people who want to get an IBM Professional Certification for this product. The IBM Tivoli Monitoring Version 6.1 Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM Tivoli Monitoring Version 6.1 product. This book provides a combination of theory and practical experience needed for a general understanding of the subject matter. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This publication does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with education activities and experience, can be a very useful preparation guide for the exam. For your convenience, we structure the chapters based on the sections of the IBM Tivoli Monitoring V6.1 Implementation Certification test, such as Planning, Prerequisites, Installation, and so on, so studying each chapter will help you prepare for one section of the exam.

Microsoft SQL Server 2005 Notification Services covers the basic problems of notification applications, describes the SQL Notification Services platform and describes how to use it to build rich, scalable notification applications. Written by Shyam Pather, the Technical Lead for the SQL Notification Services Team, this book is based on his three years of experience teaching SQL Notification Services to new customers. This book is your complete resource for learning SQL Notification Services application development and the underlying architectural concepts.

IBM DB2 Recovery Expert for Multiplatforms provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. DB2 Recovery Expert creates and maintains additional recovery assets that you can use for intelligent analysis of both DB2 and DB2 Recovery Expert assets to find the most efficient recovery path. DB2 Recovery Expert facilitates the process of rebuilding your database assets, such as tables, indexes, and data, to a specified point-in-time, often without taking the database or the business operations offline. This IBM Redbooks publication shows you how to install and implement DB Recovery Expert and the Fast Backup and Grouper components. It also describes the DB2 Recovery Expert assets and how to manage these assets. In addition, this book explains the summary and detail reports of Log Analysis, including the DPF environment. It shows, in detailed examples, point-in-time recovery and cloning of tables, table spaces, and databases. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication is a study guide for the IBM TotalStorage Productivity Center for Data V2.1, and it is meant for those who want to achieve an IBM Certification for this specific product. The IBM TotalStorage Productivity Center for Data V2.1 Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM TotalStorage Productivity Center for Data V2.1 product. This book provides a combination of theory and practical experiences necessary for a general understanding of the subject matter. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This publication does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with education activities and experience, can be a useful preparation guide for the exam.

All Access takes a “before they were stars” look at twenty-five giants in the graphic design industry by juxtaposing an edited selection of the stars’ greatest hits with their “pre-fame” work.

This IBM Redbooks publication introduces Infrastructure Simplification. Infrastructure Simplification

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language. What you will learn from this book Ways to quickly move and transform data How to configure every aspect of SSIS How to interface SSIS with web services and XML Techniques to scale the SSIS and make it more reliable How to migrate DTS packages to SSIS How to create your own custom tasks and user interfaces How to create an application that interfaces with SSIS to manage the environment A detailed usable case study for a complete ETL solution Who this book is for This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

As more companies need to manage their e-mail to support regulatory compliance, litigation, and corporate policy and to improve system performance and productivity, the e-mail archiving and records management solution presented in this IBM Redbooks publication is here to rescue. In this book, we provide a general solution guide to address e-mail archiving and records management issues using the following IBM products: We describe the products’ roles in the solution and introduce the basic concepts behind e-mail archiving and e-mail records enabling. We cover features and functions of CommonStore, Records Manager, and Records Enabler, and address key areas to understand and consider when planning and designing each piece of the solution and the overall integrated solution. In addition, we discuss different system configurations, implementation paths, security, the end-to-end solution installation and configuration, and some advanced topics such as records disposition and discovery. This book is intended for IT architects and specialists who will be responsible in planning, designing, and implementing an e-mail archiving and records management solution. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication discusses configuring and administering Linux systems running on IBM System z9 and zSeries. It is intended for system administrators and IT architects responsible for deploying Linux servers on System z9 and zSeries servers. We examine new features and enhancements of the Linux 2.6 kernel. We demonstrate Linux device configuration using sysfs and udev and discuss running Linux servers under z/VM. Networking options available for Linux on IBM System z9 and zSeries are examined in detail. Configuration of FCP-attached SCSI disks and traditional ECKD storage is demonstrated.

Want to find every pizza place within a 15-mile radius? Where the dog parks are in a new town? The most central meeting place for your class, club or group of friends? The cheapest gas stations on a day-to-day basis? The location of convicted sex offenders in an area to which you may be considering moving? The applications, serendipitous and serious, seem to be infinite, as developers find ever more creative ways to add to and customize the satellite images and underlying API of Google Maps. Written by Schuyler Erle and Rich Gibson, authors of the popular Mapping Hacks, Google Maps Hacks shares dozens of tricks for combining the capabilities of Google Maps with your own datasets. Such diverse information as apartment listings, crime reporting or flight routes can be integrated with Google's satellite imagery in creative ways, to yield new and useful applications. The authors begin with a complete introduction to the "standard" features of Google Maps. The adventure continues with 60 useful and interesting mapping projects that demonstrate ways developers have added their own features to the maps. After that's given you ideas of your own, you learn to apply the techniques and tools to add your own data to customize and manipulate Google Maps. Even Google seems to be tacitly blessing what might be seen as unauthorized use, but maybe they just know a good thing when they see one. With the tricks and techniques you'll learn from Google Maps Hacks, you'll be able to adapt Google's satellite map feature to create interactive maps for personal and commercial applications for businesses ranging from real estate to package delivery to home services, transportation and more. Includes a foreword by Google Maps tech leads, Jens and Lars Rasmussen.

IBM communication controllers have reliably carried the bulk of the world's business traffic for more than 30 years. Over the years, IBM controllers have been enhanced to the point that the functional capabilities of the current products, the 3745 Communication Controller and the 3746 Nways Multiprotocol Controller , surpass the capabilities of any other data networking equipment ever developed. Beyond the SNA architecture PU Type 4, beyond APPN, even beyond IP routing, these controllers support an extraordinary set of functions and protocols. Because of their long history and their functional richness, IBM controllers continue to play a critical role in the networks of most of the largest companies in the world. Over the past decade, however, focus has shifted from SNA networks and applications to TCP/IP and Internet technologies. In some cases, SNA application traffic now runs over IP-based networks using technologies such as TN3270 and Data Link Switching (DLSw). In other cases, applications have been changed, or business processes reengineered, using TCP/IP rather than SNA. Consequently, for some organizations, the network traffic that traverses IBM communication controllers has declined to the point where it is in the organization’s best interest to find functional alternatives for the remaining uses of their controllers so they can consolidate and possibly eliminate controllers from their environments. This IBM Redbooks publication provides you with a starting point to help in your efforts to optimize your communication controller environment, whether simply consolidating them or migrating from them altogether. We discuss alternative means to provide the communication controller functions that you use or ways to eliminate the need for those functions outright. Where multiple options exist, we discuss the relative advantages and disadvantages of each.

Conducting business via the Web and remaining open for business 24 hours a day, seven days a week is now commonplace. Customers come in with unexpected workloads through the Web and operate in a self-service fashion with mostly context-sensitive metadata to guide them. The strong requirement is availability. However, even with new Web applications, most of the core business systems considerations still apply, and performance is critical. Technology has been accelerating for mainframe systems. They had become adept at providing business resiliency accommodating strategic software that has been around for the last several decades such as IMS™ , DB2® , and CICS® , and they have also become a host for developing and running Web applications built in Java™ accommodating the latest business requirements. Businesses need to leverage, extend and integrate the strategic assets which represent multi-year investments to support leading edge technology. DB2 for z/OS® has come a long way and provides facilities to exploit the latest hardware and software technologies, accommodating a majority of user requirements. However, special considerations are required to build high performance applications. If you want to achieve high performance or high availability, you must use the design, programming, and operational techniques applicable to DB2. Please note that the additional material referenced in the text is not available from IBM.

Key Features Architecture, syntax, development and composition of Business Processes and Services using BPEL Advanced BPEL features such as compensation, concurrency, links, scopes, events, dynamic partner links, and correlations Oracle BPEL Process Manager and BPEL Designer Microsoft BizTalk Server as a BPEL server Book Description Web services provide the basic technical platform required for application interoperability. They do not, however, provide higher level control, such as which web services need to be invoked, which operations should be called and in what sequence. Nor do they provide ways to describe the semantics of interfaces, the workflows, or e-business processes. BPEL is the missing link to assemble and integrate web services into a real business process BPEL4WS standardizes process automation between web services. This applies both within the enterprise, where BPEL4WS is used to integrate previously isolated systems, and between enterprises, where BPEL4WS enables easier and more effective integration with business partners. In providing a standard descriptive structure BPEL4WS enables enterprises to define their business processes during the design phase. Wider business benefits can flow from this through business process optimization, reengineering, and the selection of most appropriate processes . Supported by major vendors - including BEA, Hewlett-Packard, IBM, Microsoft, Novell, Oracle, SAP, Sun, and others - BPEL4WS is becoming the accepted standard for business process management. This book provides detailed coverage of BPEL4WS, its syntax, and where, and how, it is used. It begins with an overview of web services, showing both the foundation of, and need for, BPEL. The web services orchestration stack is explained, including standards such as WS-Security, WS-Coordination, WS-Transaction, WS-Addressing, and others. The BPEL language itself is explained in detail, with Code snippets and complete examples illustrating both its syntax and typical construction. Having covered BPEL itself, the book then goes on to show BPEL is used in context. by providing an overview of major BPEL4WS servers. It covers the Oracle BPEL Process Manager and Microsoft BizTalk Server 2004 in detail, and shows how to write BPEL4WS solutions using these servers. What you will learn Chapter 1 provides a detailed introduction to BPEL and Service Oriented Architecture (SOA). It discusses business processes and their automation, explains the role of BPEL, web services, and Enterprise Service Buses (ESB) in SOA, provides insight into business process composition with BPEL, explains the most important features, compares BPEL to other specifications, provides an overview of BPEL servers, and discusses the future of BPEL. Chapter 2 provides a detailed introduction to the Web Services Technology Stack. It discusses the important standards and specifications for using BPEL and implementing SOA with web services, such as WS-Security, WS-Addressing, WS-Coordination, WS-AtomicTransaction, WS-BusinessActivity, WS-Reliable Messaging, etc. Chapter 3 discusses the composition of web services with BPEL. The chapter introduces the core concepts of BPEL and explains how to define synchronous and asynchronous business processes with BPEL. The reader gets familiar with BPEL process structure, partner links, sequential and parallel service invocation, variables, conditions, etc. Chapter 4 goes deeper into the BPEL specification and covers advanced features for modeling complex business processes. Advanced activities, scopes, serialization, fault handing, compensations, event handling, correlation sets, concurrent activities and links, process lifecycle, and dynamic partner links are covered in detail. Chapter 5 explains how to use the Oracle BPEL Process Manager for deploying and executing business processes defined in BPEL. It describes the server architecture, tools, features, and common approaches for managing and debugging BPEL processes. The chapter also looks at graphical development of BPEL processes using Oracle BPEL Designer for JDeveloper and for Eclipse. Chapter 6 takes a detailed look at the advanced features of the Oracle BPEL Process Manager including extension functions, dynamic parallel flows, Web Services Invocation Framework, Java embedding, Notification service, Workflow service, Identity service, and Oracle BPEL Server APIs. Chapter 7 discusses MS BizTalk Server 2004 and its support for BPEL. It explains how to develop business processes in BizTalk and export them to BPEL. It also explains how to import BPEL processes into BizTalk and how to use the Orchestration Designer tool to define processes graphically, and compares BizTalk and BPEL constructs. Appendix A provides a syntax reference for BPEL version 1.1. The appendix covers standard BPEL activities and elements, functions, attributes, and faults. Who this book is for This book is aimed at architects and developers in the design, implementation, and integration phases of advanced information systems and e-business solutions, developing business processes and dealing with the issues of composition, orchestration, transactions, coordination, and security. The book presumes knowledge of XML and web services, web services development (either on J2EE or .NET), and multi-tier architecture

The IBM eServer X3 Architecture servers are the new third-generation Enterprise X-Architecture servers from IBM. The xSeries 366 was announced in February 2005, the xSeries 460 was announced in May, and the xSeries 260 was announced in August. These X3 Architecture servers are ideal for random commercial workloads with high processor and memory bandwidth requirements. Although aimed at different client sets, they share common components and options. The x460 is targeted at clients who need to implement a large single image “scale-up” configuration of up to 32 processors and 512 GB of RAM. The x366 is targeted at the high-performance environment where rack space is a premium. The x260 is for clients who need high performance but also require large amounts of internal disk storage. This IBM Redbooks publication provides a detailed technical description of the three servers and explains how to plan, install, configure, and manage these high-performance servers running 32-bit and 64-bit versions of Windows Server 2003, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and VMware ESX Server.

Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.