You are previewing Getting Started with the IBM Smart Analytics System 9600.
O'Reilly logo
Getting Started with the IBM Smart Analytics System 9600

Book Description

The IBM® Smart Analytics System 9600 is a single, end-to-end business analytics solution to accelerate data warehousing and business intelligence initiatives. It provides integrated hardware, software, and services that enable enterprise customers to quickly and cost-effectively deploy business-changing analytics across their organizations.

As a workload-optimized system for business analytics, it leverages the strengths of the System z® platform to drive:

  • Significant savings in hardware, software, operating, and people costs to deliver a complete range of data warehouse and BI capabilities

  • Faster time to value with a reduction in the time and speed associated with deploying Business Intelligence

  • Industry-leading scalability, reliability, availability, and security

  • Simplified and faster access to the data on System z

Table of Contents

  1. Front cover
  2. Notices
    1. Trademarks
  3. Preface
    1. The team who wrote this book
    2. Now you can become a published author, too!
    3. Comments welcome
    4. Stay connected to IBM Redbooks
  4. Chapter 1. Overview of the IBM Smart Analytics System 9600
    1. 1.1 Architectural overview
    2. 1.2 Hardware specification
    3. 1.3 Software overview
    4. 1.4 Network specifications
    5. 1.5 Optional software components overview
  5. Chapter 2. Getting started
    1. 2.1 Procedure overview
    2. 2.2 Identifying the roles
    3. 2.3 InfoSphere Warehouse for System z
    4. 2.4 The Enterprise Data Warehouse
    5. 2.5 Preparing Cognos BI to create reports
  6. Chapter 3. DB2 design for the Enterprise Data Warehouse
    1. 3.1 Database design
      1. 3.1.1 Buffer pool design
      2. 3.1.2 Stored procedures
      3. 3.1.3 Database partition group design
    2. 3.2 DB2 for z/OS settings and configuration
      1. 3.2.1 DSNZPARM
      2. 3.2.2 Logging and backup considerations
    3. 3.3 DB2 9 for z/OS enhancements and features for data warehousing
    4. 3.4 Database and enterprise data warehouse design considerations
      1. 3.4.1 Tablespaces, tables, indexes, compression, stored procedures
      2. 3.4.2 MQTs, views, cubes, and fact table dimension tables
      3. 3.4.3 DB2 multi-level security
      4. 3.4.4 Subjects and objects
      5. 3.4.5 Network-trusted context
    5. 3.5 XML and the data warehouse
  7. Chapter 4. Managing the IBM Smart Analytics System 9600 components
    1. 4.1 Startup procedure for IBM Smart Analytics System 9600 components
    2. 4.2 Shutdown procedure for IBM Smart Analytics System 9600 components
    3. 4.3 Other administration tasks
      1. 4.3.1 Stopping Cognos application when content store is unavailable
      2. 4.3.2 Backup and restore tasks
  8. Chapter 5. InfoSphere Warehouse administrative tasks
    1. 5.1 InfoSphere Warehouse and the IBM Smart Analytics System 9600
    2. 5.2 Architecture of InfoSphere Warehouse
    3. 5.3 Designing Warehouse applications using Design Studio
      1. 5.3.1 Data Warehouse/Business Intelligence solution design overview
      2. 5.3.2 The Design Studio workspace
      3. 5.3.3 Next steps
  9. Chapter 6. Cognos 8 Business Intelligence
    1. 6.1 Cognos architecture
    2. 6.2 Adding authentication credentials to a data source
    3. 6.3 Accessing Cognos 8 BI components
    4. 6.4 Cognos 8 BI performance configuration settings
    5. 6.5 Accessing IBM Cognos 8 BI Metadata
    6. 6.6 Application build process overview
    7. 6.7 Topology overview with install considerations
  10. Chapter 7. System z and the IBM Smart Analytics System 9600
    1. 7.1 IBM Smart Analytics System 9600 WLM Policies
    2. 7.2 Managing users
    3. 7.3 DFSMS
    4. 7.4 High-availability and backup considerations
    5. 7.5 Backup and restore tasks
      1. 7.5.1 Backing up the DB2 catalog and directories
      2. 7.5.2 Backing up Cognos 8 BI
      3. 7.5.3 Backing up Linux on System z and important z/VM files
    6. 7.6 Disaster recovery for System z
    7. 7.7 Capacity management for System z
    8. 7.8 System Management Facilities
    9. 7.9 Resource Measurement Facility (RMF)
      1. 7.9.1 RMF monitors
      2. 7.9.2 RMF Spreadsheet Reporter overview
  11. Chapter 8. Managing users of the IBM Smart Analytics System 9600
    1. 8.1 TCP/IP and TELNET
    2. 8.2 DB2 for z/OS
    3. 8.3 InfoSphere Warehouse
    4. 8.4 IBM Cognos 8 BI
      1. 8.4.1 DB2 customization for IBM Cognos 8 BI
      2. 8.4.2 Cognos 8 Security
      3. 8.4.3 Authentication providers
      4. 8.4.4 Authorization
      5. 8.4.5 Cognos namespace
      6. 8.4.6 Optimizing users, groups, and roles in Cognos Namespace
      7. 8.4.7 Application security
    5. 8.5 Cognos users, groups, and roles
      1. 8.5.1 Users
      2. 8.5.2 Deleting and recreating users
      3. 8.5.3 User locales
      4. 8.5.4 Groups and roles
      5. 8.5.5 Access permissions
      6. 8.5.6 Cognos Application Firewall
    6. 8.6 Configuring IBM Cognos 8 components to use LDAP
    7. 8.7 Cognos security model
  12. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get Redbooks
    5. Help from IBM
  13. Back cover