In this IBM® Redbooks® publication, we describe recommendations based on an IBM b-type storage area network (SAN) environment that is utilizing VMware vSphere ESXi. We describe the hardware and software and the unique features that they bring to the marketplace. We then highlight those features and how they apply to the SAN environment, and the best practices for ensuring that you get the best out of your SAN. For background reading, we recommend the following Redbooks publications: - Introduction to Storage Area Networks and System Networking, SG24-5470 - IBM System Storage SAN Volume Controller Best Practices and Performance Guidelines, SG24-7521 - IBM System Storage SAN Volume Controller and Storwize V7000 Replication Family Services, SG24-7574 - Implementing the IBM System Storage SAN Volume Controller V6.3, SG24-7933 - IBM SAN Volume Controller Stretched Cluster with PowerVM and PowerHA, SG24-8142 - Implementing the IBM SAN Volume Controller and FlashSystem 820, SG24-8172 - IBM System Storage DS8000 Copy Services for Open Systems, SG24-6788 - IBM System Storage DS8000: Host Attachment and Interoperability, SG24-8887 This book is aimed at pre- and post-sales support, system administrators, and storage administrators.

This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.

In today's 24 x 7 world, there is likely not a business on this planet, IBM® Smarter Planet® or not, that finds that their storage requirements are growing too fast and demand is starting to outpace supply. Not only this, but in this cost-conscious environment of today, the costs of managing this growth are likely to be eating into the IT budget. One way to make better use of existing storage without adding more complexity to the infrastructure is the IBM System Storage® SAN Volume Controller (SVC). For many years now this has helped business become more flexible, agile, and introduced an extremely efficient storage environment. SAN Volume Controller is designed to deliver the benefits of storage virtualization in environments from large enterprises to small businesses and midmarket companies. Virtualizing storage with SAN Volume Controller helps make new and existing storage more effective. SAN Volume Controller includes many functions that are traditionally deployed separately in disk systems. By including these in a virtualization system, SAN Volume Controller standardizes functions across virtualized storage for greater flexibility and potentially lower costs. Now, with IBM FlashSystem™ storage, SAN Volume Controller is enabled to extend its reach and benefit all virtualized storage. For example, IBM Easy Tier® optimizes use of flash storage. And IBM Real-time Compression™ enhances efficiency even further by enabling the storage of up to five times as much active primary data in the same physical disk space. In this IBM Redbooks® publication, we show how to integrate the IBM FlashSystem 820 to provide storage to the SAN Volume Controller, and show how they are designed to operate seamlessly together, reducing management effort. In this book, which is aimed at pre- and post-sales support, storage administrators, and people that want to get an overview of this new and exciting technology, we show the steps required to implement the IBM FlashSystem 820 in an existing SAN Volume Controller environment. We also highlight some of the new features in SAN Volume Controller that increase performance. If you are not already familiar with the SAN Volume Controller, it is beneficial to read the following IBM Redbooks publications: - Implementing the IBM System Storage SAN Volume Controller V6.3, SG24-7933 - Implementing the IBM Storwize V7000 V6.3, SG24-7938 - Real-time Compression in SAN Volume Controller and Storwize V7000, REDP-4859 - IBM SAN Volume Controller and IBM FlashSystem 820: Best Practices and Performance Capabilities, REDP-5027 - IBM FlashSystem 710 and IBM FlashSystem 810, TIPS1002 - IBM FlashSystem 720 and IBM FlashSystem 820, TIPS1003 - Flash or SSD: Why and When to Use IBM FlashSystem, REDP-5020

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutions

Learn how IBM has overcome its toughest challenges—and how you can replicate iconic company's success Over the past 100 years, the IBM Corporation has survived several recessions and innumerable twists and turns in the global technology market. And even in an economy of global recession, this icon continues to repeat remarkable performance after remarkable performance—reinventing the meaning of corporate sustainability, employee loyalty and value-added leadership—and followed by memorable customer service. Repeat the Remarkable reveals the leadership lessons of a top IBM leadership development trainer. In it, Holley gives you the tools to tap into your own personal success—so you can lead your company to remarkable and repeatable performances Perry Holley is program director, IBM Leadership Development.

Building a successful supply chain processing EDI implementation in BizTalk Server can be complex. Decisions must be made around how to extract and publish data, how to map to the various EDI standards, and how to appropriately batch and deliver data. If architected properly, your BizTalk solution can be highly efficient, simple, and something that can be managed and extended for years to come. The topics in this book include building complete inbound and outbound solutions for 810, 845, and 850 EDI document types, which will lay the groundwork for any document type you may be implementing. In addition, topics on how to set up FTP, SFTP, and AS2 protocols for document exchange, working with 997/999 acknowledgements, and creating custom applications for archiving and monitoring data are included. Covering mapping, architectural patterns, orchestrations, trading partner configurations, AS2, SFTP, FTP, usage of role links, and data routing, you will find that BizTalk 2013 EDI for Supply Chain Management gives you the detail and knowledge needed for success with your own implementations. What you'll learn Successfully create professional, industry-standard and compliant implementations Build fully operational inbound and outbound processes using AS2, SFTP, and FTP Integrate with SQL Server, .NET Libraries, and other platforms and technologies Develop maps, schemas, orchestrations and configure encrypted file delivery Configure role links to allow for shipment of outbound data to multiple parties Who this book is for BizTalk Developers, technical architects, and executives of manufacturing or supply companies looking to implement EDI on BizTalk

Making Sense of NoSQL clearly and concisely explains the concepts, features, benefits, potential, and limitations of NoSQL technologies. Using examples and use cases, illustrations, and plain, jargon-free writing, this guide shows how you can effectively assemble a NoSQL solution to replace or augment the traditional RDBMS you have now. About the Technology About the Book If you want to understand and perhaps start using the new data storage and analysis technologies that go beyond the SQL database model, this book is for you. Written in plain language suitable for technical managers and developers, and using many examples, use cases, and illustrations, this book explains the concepts, features, benefits, potential, and limitations of NoSQL. Making Sense of NoSQL starts by comparing familiar database concepts to the new NoSQL patterns that augment or replace them. Then, you'll explore case studies on big data, search, reliability, and business agility that apply these new patterns to today's business problems. You'll see how NoSQL systems can leverage the resources of modern cloud computing and multiple-CPU data centers. The final chapters show you how to choose the right NoSQL technologies for your own needs. What's Inside NoSQL data architecture patterns NoSQL for big data Search, high availability, and security Choosing an architecture About the Reader Managers and developers will welcome this lucid overview of the potential and capabilities of NoSQL technologies. About the Authors Dan McCreary and Ann Kelly lead an independent training and consultancy firm focused on NoSQL solutions and are cofounders of the NoSQL Now! Conference. Quotes Easily digestible, practical advice for technical managers, architects, and developers. - From the Foreword by Tony Shaw, CEO of DATAVERSITY Cuts through the jargon and gives you the information you need to know. - Craig Smith, Unbound DNA A concise yet thorough description of the many facets of NoSQL, from big data to search. - John Guthrie, Pivotal Brings common sense to the world of NoSQL. - Ignacio Lopez Vellon, Atos Worldgrid Get ahead of your peers ... fast-track to NoSQL now! - Ian Stirk, Stirk Consultancy, Ltd

Uncover the secrets of SQL and start building better relational databases today! This fun and friendly guide will help you demystify database management systems so you can create more powerful databases and access information with ease. Updated for the latest SQL functionality, SQL For Dummies, 8th Edition covers the core SQL language and shows you how to use SQL to structure a DBMS, implement a database design, secure your data, and retrieve information when you need it. Includes new enhancements of SQL:2011, including temporal data functionality which allows you to set valid times for transactions to occur and helps prevent database corruption Covers creating, accessing, manipulating, maintaining, and storing information in relational database management systems like Access, Oracle, SQL Server, and MySQL Provides tips for keeping your data safe from theft, accidental or malicious corruption, or loss due to equipment failures and advice on eliminating errors in your work Don't be daunted by database development anymore - get SQL For Dummies, 8th Edition, and you'll be on your way to SQL stardom.

Instant Apache Camel Message Routing is your guide to understanding and implementing integration solutions using Apache Camel. This book introduces you to Camel's routing capabilities and enterprise integration patterns, making it accessible for learners aiming to streamline their message handling processes. With a concise and practical approach, this book helps you quickly gain valuable routing and integration skills. What this Book will help me do Gain an in-depth understanding of Apache Camel's architecture and message routing capabilities. Learn to implement enterprise integration patterns such as content-based routing and dynamic routing effectively. Get hands-on experience with Camel's components for connecting disparate systems with ease. Master advanced Camel features like parallel processing, message splitting, and aggregation techniques. Develop robust message error handling strategies using Camel's error handling capabilities. Author(s) Bilgin Ibryam, the author of this concise guide, is an experienced software engineer specializing in application integration and distributed systems. With a deep understanding of Apache Camel and related technologies, he offers a step-by-step approach to teach effective message routing. Bilgin's writing style focuses on clarity and practical learning to empower developers. Who is it for? This book is tailored for Java developers eager to learn about Apache Camel and message routing. Beginners will appreciate the structured introduction to integration patterns, while intermediate learners can benefit from the deep dive into Camel's advanced features. It's ideal for developers seeking to connect applications seamlessly using a powerful, open-source tool.

Explore the powerful features of the GSON library in this concise and practical book. "Instant GSON" provides a hands-on guide to efficiently handling JSON data using Google's GSON library. In this book, you'll learn essential techniques to convert Java objects to JSON and vice versa, utilize field exclusion strategies, and implement GSON in real-world applications. What this Book will help me do Convert Java objects into JSON format and retrieve Java objects from JSON data. Understand and work with GSON's handling of generic types and nested classes. Learn how to implement field exclusion strategies and write custom JSON converters. Gain knowledge on pretty-printing JSON and utilizing versioning support. Effectively use GSON in various practical Java-based applications, including web projects. Author(s) Sandeep Patel is an experienced software developer specializing in Java programming and JSON data interchange. With years of hands-on experience working with GSON, Sandeep has a deep understanding of its capabilities and nuances. His writing style is focused on practical examples and clear explanations, aimed at helping readers efficiently integrate advanced JSON management into their programming projects. Who is it for? If you are a Java developer who is new to the GSON library and keen to incorporate it into your projects, this book is for you. "Instant GSON" will appeal to software developers aiming to boost productivity and master JSON data handling. Readers should have a basic understanding of Java programming and an interest in JSON serialization and deserialization. This book provides guidance tailored to beginner and intermediate skill levels.

This book is your hands-on guide to mastering Mongoose for application development on the Node.js stack. By working through practical examples, you'll learn how to define data schemas, efficiently interact with your database, and build a real-life project management application using this powerful tool. What this Book will help me do Master connecting Node.js applications to MongoDB using Mongoose. Define and leverage data schemas and models for robust data management. Perform CRUD operations seamlessly using Mongoose's accessible APIs. Integrate advanced concepts like schema validators, population, and sub-documents. Learn to enhance productivity by developing and utilizing reusable plugins. Author(s) Simon Holmes, an experienced web developer, specializes in JavaScript, Node.js, and database technologies. Known for his clear and effective teaching style, Simon has authored several books and tutorials to help developers be more proficient and productive. His insights on Mongoose bridge the gap between practical application and theoretical knowledge. Who is it for? This book is perfect for developers interested in Node.js who want to incorporate MongoDB into their applications and need a structured yet hands-on approach. It's suitable for learners new to Mongoose as well as experienced developers seeking to optimize their database interactions. Key audiences include backend developers, full-stack developers, and software engineers aiming to enhance their database schemas and queries.

This IBM® Redbooks® publication describes how IBM PureApplication™ System supports the creation of virtual systems and virtual applications. PureApplication System does so using a pattern model that enables you to take advantage of predefined, pre-configured, and proven middleware topologies and deployments. This book also presents an abstraction level that focuses on functional capabilities and applications, completely encapsulating the underlying middleware. It describes in detail the model and the associated frameworks in PureApplication System, as well as a methodology and approach toward designing and implementing a custom pattern model. This book shows concrete implementation examples that you can use when creating your own pattern model, paired with a collection of leading practices. This IBM Redbooks publication gives critical guidance to, and serves as a reference for, independent software vendors (ISVs) who want to create patterns for their packaged applications on PureApplication System. Clients who want to extend and enhance their existing patterns can also use this book.

To meet today's complex and ever-changing business demands, you need a solid foundation of server, storage, networking, and software resources. It must be simple to deploy and able to quickly and automatically adapt to changing conditions. You also need access to, and the ability to take advantage of, broad expertise and proven best practices in systems management, applications, hardware maintenance, and more. IBM® PureFlex™ System is part of the IBM PureSystems™ family of expert integrated systems. It combines advanced IBM hardware and software along with patterns of expertise and integrates them into three optimized configurations that are simple to acquire and deploy. With the PureFlex System, you can achieve faster time to value. If you want a pre-configured, pre-integrated infrastructure with integrated management and cloud capabilities, factory tuned from IBM with x86 and Power hybrid solution, IBM PureFlex System is the answer. In this IBM Redbooks® publication, the examples use a Cisco Nexus 5000 Series Switch, although any configurations should also apply to the Cisco Nexus 7000 Series Switch too. However, it is wise to check as there might be minor differences. This book also covers the different variations for the implementation of these use cases when you use Cisco Catalyst Series Switches.

Expert Oracle RAC 12c is a hands-on book helping you understand and implement Oracle Real Application Clusters (RAC), and to reduce the total-cost-of-ownership (TCO) of a RAC database. As a seasoned professional, you are probably aware of the importance of understanding the technical details behind the RAC stack. This book provides deep understanding of RAC concepts and implementation details that you can apply toward your day-to-day operational practices. You’ll be guided in troubleshooting and avoiding trouble in your installation. Successful RAC operation hinges upon a fast-performing network interconnect, and this book dedicates a chapter solely to that very important and easily overlooked topic. All four authors are experienced RAC engineers with a wealth of hard-won experience encountering and surmounting the challenges of running a RAC environment that delivers on its promise. In Expert Oracle RAC 12c they provide you a framework in which to avoid repeating their hard-won lessons. Their goal is for you to manage your own RAC environment with ease and expertise. • Provides a deep conceptual understanding of RAC • Provides best practices to implement RAC properly and match application workload • Enables readers to troubleshoot RAC with ease

Authoritative and comprehensive coverage for building Access 2013 Solutions Access, the most popular database system in the world, just opened a new frontier in the Cloud. Access 2013 provides significant new features for building robust line-of-business solutions for web, client and integrated environments. This book was written by a team of Microsoft Access MVPs, with consulting and editing by Access experts, MVPs and members of the Microsoft Access team. It gives you the information and examples to expand your areas of expertise and immediately start to develop and upgrade projects. Explores the new development environment for Access web apps Focuses on the tools and techniques for developing robust web applications Demonstrates how to monetize your apps with Office Store and create e-commerce solutions Explains how to use SQL Server effectively to support both web and client solutions Provides techniques to add professional polish and deploy desktop application Shows you how to automate other programs using Macros, VBA, API calls and more. Professional Access 2013 Programming is a complete guide on the latest tools and techniques for building Access 2013 applications for both the web and the desktop so that developers and businesses can move forward with confidence. Whether you want to add expand your expertise with Client/Server deployments or start developing web apps, you will want this book as a companion and reference.

This completely refreshed IBM Redbooks® publication provides a detailed introduction to the latest capabilities for business event processing with IBM® CICS® V5. Events make it possible to identify and react to situations as they occur, and an event-driven approach, where changes are detected as they happen, can enable an application or an Enterprise to respond in a much more timely fashion. CICS event processing support was first introduced in CICS TS V4.1, and this IBM Redbooks® publication now covers all the significant enhancements and extensions which have been made since then. CICS Transaction Server for z/OS provides capabilities for capturing application events, which can give insight into the business activities carried out within CICS applications, and system events, which give insight into changes in state within the CICS system. Application events can be generated from existing applications, without requiring any application changes. Simple tooling allows both application and system events to be defined and deployed into CICS without disruption to the system, and the resulting events can be made available to a variety of event consumers. CICS events can amongst other things be used to drive processing within CICS, to populate dashboards that are provided by IBM Business Monitor and to search for patterns in events using IBM Operational Decision Manager. This IBM Redbooks® publication is divided into the following parts: Part 1 introduces event processing. We explain what it is and why you need it, and discuss how CICS makes it easy to both capture and emit events. Part 2 of the book focuses on the details of event processing with CICS. It gives a step-by-step guide to implementing CICS events, along with the environment used in the examples. Part 3 provides some guidance on governance and troubleshooting for CICS events, and describes how to integrate CICS events with IBM Operational Decision Manager and IBM Business Monitor. The Appendices include additional reference information.

The mobile industry is evolving rapidly. An increasing number of mobile devices, such as smartphones and tablets, are sold every year and more people are accessing services from a mobile device than ever before. For an enterprise, this can mean that a growing number of customers, business partners, and even employees now expect to access services on a mobile channel. This opens new opportunities for the business but also presents new challenges, both in terms of business processes and information technology (IT) infrastructure. IBM® Worklight® is an open mobile application platform. It helps organizations of all sizes to efficiently develop, connect, run, and manage HTML5, hybrid, and native applications. IBM Worklight provides the essential elements needed for complete mobile application development, deployment, and management within a business. This IBM Redbooks® publication provides information necessary to design, develop, deploy, and maintain mobile applications using IBM Worklight Version 5.0.5. It includes information about decision points that the IT organization will need to make, the roles that are involved in a mobile strategy and the responsibilities of the individuals in those roles. It also describes integration points with other IBM products that can enhance the mobile solution. This book has two parts: Part 1 is for a business-oriented IT audience and addresses business aspects of the mobile industry. It is for the IT architect or CTO, who can translate business needs into information technology solutions Part 2 is intended for a technical audience, including application developers, testers, and system administrators.

This IBM® Redbooks® publication describes the IBM Storage Area Network and IBM SAN Volume Controller Stretched Cluster solution when combined with PowerVM® and PowerHA®. We describe guidelines, settings, and the implementation steps that are necessary to achieve a successful implementation. This book is for administrators who are familiar with the SAN, IBM SAN Volume Controller, and IBM PowerVM and PowerHA Systems.

This IBM® Redbooks® publication describes the concepts, architecture, and implementation of the IBM System Storage® DS8870 storage system. The book provides reference information to assist readers who need to plan for, install, and configure the DS8870. The IBM System Storage DS8870 is the most advanced model in the IBM DS8000® series and is equipped with IBM POWER7® based controllers. Various configuration options are available that scale from dual 2-core systems up to dual 16-core systems with up to 1 TB of cache. The DS8870 also features enhanced 8 Gbps device adapters and host adapters. Connectivity options, with up to 128 Fibre Channel/IBM FICON® ports for host connections, make the DS8870 suitable for multiple server environments in open systems and The DS8870 supports advanced disaster recovery solutions, business continuity solutions, and thin provisioning. All disk drives in the DS8870 storage system have the Full Disk Encryption (FDE) feature. The DS8870 also can be integrated in a Lightweight Directory Access Protocol (LDAP) infrastructure. The DS8870 is equipped with high-density storage enclosures and can be equipped with solid-state drives (SSDs). The DS8870 can automatically optimize the use of each storage tier, particularly SSDs through the IBM Easy Tier® feature, which is available at no extra charge. With Licensed Machine Code 7.7.10.xx.xx, Easy Tier offers new features, still at no charge.

Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions. Set up Oracle Database 12c or upgrade from an earlier version Design Oracle databases and plan for application implementation Construct SQL and SQLPlus statements and execute powerful queries Secure data with roles, privileges, virtualization, and encryption Move data with SQLLoader and Oracle Data Pump Restore databases using flashback and the Oracle Database Automatic Undo Management feature Build and deploy PL/SQL triggers, procedures, and packages Work with Oracle pluggable and container databases Develop database applications using Java, JDBC, and XML Optimize performance with Oracle Real Application Clusters