This IBM® Redbooks® publication will help you learn how to build a storage cloud with the IBM SmartCloud™ Storage Access solution, which consists of multiple hardware and software products including IBM Scale Out network Attached Storage (SONAS), IBM Storwize® V7000 Unified, IBM Tivoli® Storage Productivity Center, and more. To get you started, we cover the planning, installation, and configuration for each component. SmartCloud Storage Access is an IBM software product for storage cloud management that enables the cloud service with virtualization and automation. SCSA is the focal point to administer the storage cloud environment providing a self-service provision approach for the storage cloud users. New storage capacity can be easily deployed and accessed by the Internet or intranet. SmartCloud Storage Access also supports simple and fast resource elasticity as user demand changes. With the SmartCloud Storage Access solution, the storage resources will be displayed as unified resource pools with different service levels. Users no longer need to know the exact location of their files and there is no more need to configure the underlying storage subsystems manually. All storage resources are still well monitored and the cloud administrators can easily track the historical storage resource utilization. This publication is intended for anyone who wants to understand more about IBM SmartCloud Storage Access planning, implementation, configuration, and usage. This book is suitable for IBM clients, IBM Business Partners, IBM specialist sales representatives, and technical specialists.

In today’s highly competitive and real-time environment, the ability to manage all IT operations on a continuous basis makes the creation of copies and backups of data a core requirement for any IT deployment. Furthermore, it is necessary to provide proactive efficient disaster recovery strategies that can ensure continuous data availability for business operations. The Copy Services functions available with the IBM® System Storage® DS8000® are part of these strategies. This IBM Redbooks® publication helps you plan, install, configure, and manage the Copy Services functions of the DS8000 when they are used in Open System and IBM i environments. This book provides the details necessary to implement and control each of the Copy Services functions. Numerous examples illustrate how to use the various interfaces with each of the Copy Services. This book also covers the 3-site Metro/Global Mirror with Incremental Resync feature and introduces the IBM Tivoli® Storage Productivity Center for Replication solution. This book should be read with The IBM System Storage DS8000 Series: Architecture and Implementation, SG24-8886. There is also a companion book, IBM System Storage DS8000 Copy Services for IBM System z®, SG24-6787, which supports the configuration of the Copy Services functions in IBM z/OS® environments.

This publication helps strengthen the position of IBM® software solutions and enables for High Performance Computing (hardware, software, and tools) with a well-defined and documented deployment model within an IBM environment. As a result, customers receive a planned foundation for dynamic infrastructure for parallel High Performance Computing (HPC) applications. This IBM Redbooks® publication addresses topics to take advantage of the strengths of IBM PE Developers Edition for HPC applications. The objective is to solve customer's challenges and maximize systems' throughput, performance, and management. This publication examines the tools, utilities, documentation, and other resources available to help the IBM technical teams provide solutions and support for IBM HPC solutions in an IBM hardware environment. This IBM Redbooks is targeted toward technical professionals (consultants, technical support staff, IT Architects, and IT Specialists) responsible for providing HPC solutions and support.

In today’s highly competitive and real-time environment, the ability to manage all IT operations on a continuous basis makes the creation of copies and backups of data a core requirement for any IT deployment. Furthermore, it is necessary to provide proactive efficient disaster recovery strategies that can ensure continuous data availability for business operations. The Copy Services functions available with the IBM® System Storage® DS8000® are part of these strategies. This IBM Redbooks® publication helps you plan, install, configure, and manage the Copy Services functions of the DS8000 when they are used in Open System and IBM i environments. This book provides the details necessary to implement and control each of the Copy Services functions. Numerous examples illustrate how to use the various interfaces with each of the Copy Services. This book also covers the 3-site Metro/Global Mirror with Incremental Resync feature and introduces the IBM Tivoli® Storage Productivity Center for Replication solution. This book should be read with The IBM System Storage DS8000 Series: Architecture and Implementation, SG24-8886. There is also a companion book, IBM System Storage DS8000 Copy Services for IBM System z, SG24-6787, which supports the configuration of the Copy Services functions in IBM z/OS® environments.

This IBM® Redbooks® publication addresses host attachment and interoperability considerations for the IBM System Storage® DS8000® series. Within this book, you can find information about the most popular host operating systems platforms, including Windows®, IBM AIX®, VIOS, Linux®, Solaris, HP-UX, VMware, Apple, and IBM z/OS® The topics covered in this book target administrators or other technical personnel with a working knowledge of storage systems and a general understanding of open systems. You can use this book as guidance when installing, attaching, and configuring System Storage DS8000. The practical, usage-oriented guidance provided in this book complements the IBM System Storage DS8000 Host Systems Attachment Guide, SC26-7917.

IBM® PowerSC provides a security and compliance solution that is optimized for virtualized environments on IBM Power Systems™ servers, running IBM PowerVM® and IBM AIX®. Security control and compliance are some of the key components that are needed to defend the virtualized data center and cloud infrastructure against ever evolving new threats. The IBM business-driven approach to enterprise security used in conjunction with solutions such as PowerSC makes IBM the premier security vendor in the market today. This IBM Redbooks® deliverable helps IT and Security managers, architects, and consultants to strengthen their security and compliance posture in a virtualized environment running IBM PowerVM.

This IBM® Redbooks® publication describes how the IBM Content Collector family of products can help companies to create value-based archiving solutions. IBM Content Collector provides enterprise-wide content archiving and retention management capabilities. It also provides IT administrators with a high level of control over the archiving environment. From a common interface, organizations can implement policies that define what gets archived from which source system, make decisions about how content gets archived based on the content or metadata of the information, and determine the retention and governance rules associated with that type of content. Content Collector enables IT staff to implement granular archiving policies to collect and archive specific pieces of information. IBM Content Collector helps with the following tasks: Eliminating point solutions and lowering costs with a unified collection, management, and governance approach that works effectively across a broad range of source systems and information types Appraising, improving understanding of, culling, and properly selecting the information to archive Retaining, holding, and disposing of archived content efficiently and defensibly Eliminating the costs and risks inherent with over-retention This book covers the basic concepts of the IBM Content Collector product family. It presents an overview explaining how it provides value-based archiving and a defensible disposal capability in the archiving solutions. With the integration of IBM Content Classification and IBM Enterprise Records, the book also explains and showcases how these products can be used to add more flexibility, power, and capabilities to archiving solutions. The book is intended for IT architects and solution designers who need to understand and use IBM Content Collector for archiving solution implementations. Use cases are included to provide specific, step-by-step details about implementing common solutions that fulfill some of the general business requirements.

This IBM® Redbooks® publication consolidates, in one document, detailed descriptions of the hardware configurations and options offered as part of the IBM System Storage DS5000 families of products. This edition covers updates and additional functions available with the IBM System Storage DS® Storage Manager Version 10.77 (firmware level 7.77). This book presents the concepts and functions used in planning and managing the storage servers, such as multipathing and path failover. The book offers a step-by-step guide to using the Storage Manager to create arrays, logical drives, and other basic (as well as advanced) management tasks. This publication also contains practical information about diagnostics and troubleshooting, and includes practical examples of how to use scripts and the command-line interface. This publication is intended for customers, IBM Business Partners, and IBM technical professionals who want to learn more about the capabilities and advanced functions of the DS5000 series of storage servers with Storage Manager Software V10.77. It also targets those who have a DS5000 storage subsystem and need detailed advice about how to configure it. This book is designed specifically to address the hardware features and configuration of the IBM System Storage DS5000 family and can be used in conjunction with the following IBM Redbooks publications: IBM System Storage DS5000 Series Implementation and Best Practices Guide, SG24-8024

IBM® Information Management System (IMS™) provides leadership in performance, reliability, and security to help you implement the most strategic and critical enterprise applications. IMS, IMS utilities, and IMS tools continue to evolve to provide value and meet the needs of enterprise customers. With IMS 12, integration and open access improvements provide flexibility and support business growth requirements. Scalability improvements have been made to the well-known performance, efficiency, availability, and resilience of IMS by using 64-bit storage. In this IBM Redbooks® publication we provide IMS performance monitoring and tuning information by describing the key IMS performance functions and by showing how to monitor and tune them with traditional and new strategic applications. This book is for database administrators and system programmers. We summarize methods and tools for monitoring and tuning IMS systems, describe IMS system-wide performance, database, and transaction considerations. Based on lab measurements, we provide information about recent performance enhancements that are available with IMS 12, and advice about setting performance-related parameters.

This IBM® Redbooks® publication captures several of the best practices based on field experience and describes the performance gains that can be achieved by implementing the IBM System Storage® SAN Volume Controller V6.2. This book begins with a look at the latest developments with SAN Volume Controller V6.2 and reviews the changes in the previous versions of the product. It highlights configuration guidelines and best practices for the storage area network (SAN) topology, clustered system, back-end storage, storage pools and managed disks, volumes, remote copy services, and hosts. Then, this book provides performance guidelines for SAN Volume Controller, back-end storage, and applications. It explains how you can optimize disk performance with the IBM System Storage Easy Tier® function. Next, it provides best practices for monitoring, maintaining, and troubleshooting SAN Volume Controller. Finally, this book highlights several scenarios that demonstrate the best practices and performance guidelines. This book is intended for experienced storage, SAN, and SAN Volume Controller administrators and technicians. Before reading this book, you must have advanced knowledge of the SAN Volume Controller and SAN environment. For background information, read the following Redbooks publications: Implementing the IBM System Storage SAN Volume Controller V5.1, SG24-6423 Introduction to Storage Area Networks, SG24-5470

This IBM® Redbooks® publication represents a compilation of best practices for deploying and configuring the IBM System Storage® DS5000 Series family of products. This book is intended for IBM technical professionals, Business Partners, and customers responsible for the planning, deployment, and maintenance of the IBM System Storage DS5000 Series family of products. We realize that setting up DS5000 Storage Servers can be a complex task. There is no single configuration that will be satisfactory for every application or situation. First, we provide a conceptual framework for understanding the hardware in a Storage Area Network. Then, we offer our guidelines, hints, and tips for the physical installation, cabling, and zoning, using the Storage Manager setup tasks. Next, we provide a quick guide to help you install and configure the DS5000 using best practices. After that, we turn our attention to the performance and tuning of various components and features, including numerous guidelines. We look at performance implications for various application products such as IBM DB2®, Oracle, IBM Tivoli® Storage Manager, Microsoft SQL server, and in particular, Microsoft Exchange server. Then we review the various tools available to simulate workloads and to measure, collect, and analyze performance data. We also consider the IBM AIX® environment, including IBM High Availability Cluster Multiprocessing (HACMP™) and IBM General Parallel File System (GPFS™). This edition of the book also includes guidelines for managing and using the DS5000 with the IBM System Storage SAN Volume Controller (SVC) and IBM Storwize® V7000.

In a smarter planet, information-centric processes are exploding in growth. The mainframe has always been the IT industry's leading platform for transaction processing, consolidated and secure data serving, and support for available enterprise-wide applications. IBM® has extended the mainframe platform to help large enterprises reshape their client experiences through information-centric computing and to deliver on key business initiatives. IBM zEnterprise® is recognized as the most reliable and trusted system, and the most secure environment for core business operations. The new zEnterprise System consists of the IBM zEnterprise EC12 (zEC12), an updated IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension (zBX) Model 003. This IBM Redbooks® publication describes the zEC12, with its improved scalability, performance, security, resiliency, availability, and virtualization. The zEC12 has no peer as a trusted platform that also provides the most efficient transaction processing and database management. With efficiency at scale delivering significant cost savings on core processes, resources can be freed up to focus on developing new services to drive growth. This book provides a technical overview of the zEC12, zBX Model 003, and Unified Resource Manager. This publication is intended for IT managers, architects, consultants, and anyone else who wants to understand the elements of the zEnterprise System. For this introduction to the zEC12, readers are not expected to be familiar with current IBM System z® technology and terminology.

Typical deployment architectures introduce challenges to fully using the shared metadata platform across products, environments, and servers. Data privacy and information security requirements add even more levels of complexity. IBM® InfoSphere® Information Server provides a comprehensive, metadata-driven platform for delivering trusted information across heterogeneous systems. This IBM Redbooks® publication presents guidelines and criteria for the successful deployment of InfoSphere Information Server components in typical logical infrastructure topologies that use shared metadata capabilities of the platform, and support development lifecycle, data privacy, information security, high availability, and performance requirements. This book can help you evaluate information requirements to determine an appropriate deployment architecture, based on guidelines that are presented here, and that can fulfill specific use cases. It can also help you effectively use the functionality of your Information Server product modules and components to successfully achieve your business goals. This book is for IT architects, information management and integration specialists, and system administrators who are responsible for delivering the full suite of information integration capabilities of InfoSphere Information Server.

This IBM® Platform Computing Solutions Redbooks® publication is the first book to describe each of the available offerings that are part of the IBM portfolio of Cloud, analytics, and High Performance Computing (HPC) solutions for our clients. This IBM Redbooks publication delivers descriptions of the available offerings from IBM Platform Computing that address challenges for our clients in each industry. We include a few implementation and testing scenarios with selected solutions. This publication helps strengthen the position of IBM Platform Computing solutions with a well-defined and documented deployment model within an IBM System x® environment. This deployment model offers clients a planned foundation for dynamic cloud infrastructure, provisioning, large-scale parallel HPC application development, cluster management, and grid applications. This IBM publication is targeted to IT specialists, IT architects, support personnel, and clients. This book is intended for anyone who wants information about how IBM Platform Computing solutions use IBM to provide a wide array of client solutions.

IBM® defines a smarter city as one that makes optimal use of all available information to better understand and control its operations and optimize the use of resources. There is much information available from different sources. However, city officials often lack the holistic view of the city's operations that is required to respond to the citizens' needs in a timely manner and use the city resources wisely. IBM Intelligent Operations Center delivers a unified view of city agencies, providing three primary elements for successful management of cities: use information, anticipate problems, and coordinate actions and resources. Chapter 1 of this IBM Redbooks® publication introduces the IBM Intelligent Operations Center solution. The chapter provides a high-level overview of its features, benefits, and architecture. This information is intended for city officials and IT architects that must understand the business value of IBM Intelligent Operations Center and its architecture. The remaining chapters of this book focus on information that help IBM Intelligent Operations Center administrators perform daily administration tasks. This book describes commands and tools that IBM Intelligent Operations Center administrators must use to keep the solution running, troubleshoot and diagnose problems, and perform preventive maintenance. This book includes preferred practices, tips and techniques, and general suggestions for administrators of IBM Intelligent Operations Center on-premises deployments. For related information about this topic, refer to the following IBM Redbooks publications: IBM Intelligent Operations Center for Smarter Cities Redpaper, REDP-4939 IBM Intelligent Operations Center for Smarter Cities Solution Guide

This IBM® Redbooks® publication provides advice and technical information about optimizing and tuning application code to run on systems that are based on the IBM POWER7® and POWER7+™ processors. This advice is drawn from application optimization efforts across many different types of code that runs under the IBM AIX® and Linux operating systems, focusing on the more pervasive performance opportunities that are identified, and how to capitalize on them. The technical information was developed by a set of domain experts at IBM. The focus of this book is to gather the right technical information, and lay out simple guidance for optimizing code performance on the IBM POWER7 and POWER7+ systems that run the AIX or Linux operating systems. This book contains a large amount of straightforward performance optimization that can be performed with minimal effort and without previous experience or in-depth knowledge. This optimization work can: Improve the performance of the application that is being optimized for the POWER7 system Carry over improvements to systems that are based on related processor chips Improve performance on other platforms The audience of this book is those personnel who are responsible for performing migration and implementation activities on IBM POWER7-based servers, which includes system administrators, system architects, network administrators, information architects, and database administrators (DBAs).

IBM® CICS® Transaction Server (CICS TS) has been available in various guises for over 40 years, and continues to be one of the most widely used pieces of commercial software. This IBM Redbooks® publication helps application architects discover the value of CICS Transaction Server to their business. This book can help architects understand the value and capabilities of CICS Transaction Server and the CICS tools portfolio. The book also provides detailed guidance on the leading practices for designing and integrating CICS applications within an enterprise, and the patterns and techniques you can use to create CICS systems that provide the qualities of service that your business requires.

To meet today's complex and ever-changing business demands, you need a solid foundation of compute, storage, networking, and software resources. This system must be simple to deploy, and be able to quickly and automatically adapt to changing conditions. You also need to be able to take advantage of broad expertise and proven guidelines in systems management, applications, industry solutions, and more. IBM® PureFlex™ System combines no-compromise system designs along with built-in expertise, and integrates them into complete, optimized scalable solutions. With IBM Flex System™ Manager, multiple solution components that include compute nodes, network and storage infrastructures, storage systems, and heterogeneous virtualization environments can be managed from a single panel. This IBM Redbooks® publication introduces IBM PureFlex System and its management devices and appliances. It provides implementation guidelines for managing Linux KVM, IBM PowerVM®, VMware vSphere and Microsoft Hyper-V virtualization environments. This book is intended for the IT community of clients, Business Partners, and IBM employees who are interested in planning and implementing systems management of the IBM PureFlex System.

IBM® z/VM® 6.2 introduced significant changes to z/VM with a multi-system clustering technology that allows up to four z/VM instances in a single system image (SSI) cluster. This technology is important because it offers you an attractive alternative to vertical growth by adding new z/VM systems. In the past, this capability required duplicate efforts to install, maintain, and manage each system. With SSI, these duplicate efforts are reduced or eliminated. Support for live guest relocation (LGR) allows you to move Linux virtual servers without disrupting your business or incurring loss of service, thus reducing planned outages. The z/VM systems are aware of each other and take advantage of their combined resources. LGR enables you to relocate guests from a system requiring maintenance to a system that will remain active during maintenance. A major advantage for DB2 v10 customers is that using z/VM 6.2 does not require any changes to existing DB2 structures. This remarkable benefit is due to the fact that DB2 v10 is installed as part of the LInux guest on z/VM and is fully integrated into LGR. This allows you to smoothly move DB2 v10 when you move Linux virtual servers, without interrupting either DB2 v10 or z/VM operations and services. This IBM Redbooks® publication will help you understand how DB2 10 on Linux for System z® behaves while running on a z/VM that is being relocated using z/VM’s 6.2 Live Guest Relocation feature. In this book, we explore memory management, the DB2 Self-tuning memory manager feature, time synchronization, networking, and storage and performance considerations with regards to relocation. We also offer some best practices found during a live guest relocation for DB2 v10.

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see how SQL statements are structured Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete. With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language. 10 minutes is all you need to learn how to... Use the major SQL statements Construct complex SQL statements using multiple clauses and operators Retrieve, sort, and format database contents Pinpoint the data you need using a variety of filtering techniques Use aggregate functions to summarize data Join two or more related tables Insert, update, and delete data Create and alter database tables Work with views, stored procedures, and more Table of Contents 1 Understanding SQL 2 Retrieving Data 3 Sorting Retrieved Data 4 Filtering Data 5 Advanced Data Filtering 6 Using Wildcard Filtering 7 Creating Calculated Fields 8 Using Data Manipulation Functions 9 Summarizing Data 10 Grouping Data 11 Working with Subqueries 12 Joining Tables 13 Creating Advanced Joins 14 Combining Queries 15 Inserting Data 16 Updating and Deleting Data 17 Creating and Manipulating Tables 18 Using Views 19 Working with Stored Procedures 20 Managing Transaction Processing 21 Using Cursors 22 Understanding Advanced SQL Features Appendix A: Sample Table Scripts Appendix B: Working in Popular Applications Appendix C : SQL Statement Syntax Appendix D: Using SQL Datatypes Appendix E: SQL Reserved Words