DB2 Universal Database for iSeries administration : the graphical way on V5R3

DB2 Universal Database for iSeries administration the graphical way on V5R3

iSeries Navigator for IBM i5/OS and OS/400 is the graphical interface to manage your IBM eServer iSeries runtime environment. V5R3 iSeries Navigator contains major functions and interface enhancements over previous releases. This IBM Redbooks publication presents an overview of all V5R3 iSeries Navi...

Descripción completa

Detalles Bibliográficos
Autor principal: Bedoya, Hernando (-)
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Otros Autores: Neerukonda, Nandoo, Perez, Edwin
Formato: Libro electrónico
Idioma:Inglés
Publicado: [S.l.] : IBM, International Technical Support Organization c2004.
Edición:1st ed
Colección:IBM redbooks.
Materias:
IBM Database 2.
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627146006719
Tabla de Contenidos:
  • Front cover
  • Contents
  • Notices
  • Trademarks
  • Preface
  • The team that wrote this redbook
  • Become a published author
  • Comments welcome
  • Part 1 Basic concepts
  • Chapter 1. Introducing DB2 Universal Database for iSeries
  • 1.1 An integrated relational database
  • 1.2 DB2 UDB for iSeries: Features overview
  • 1.3 DB2 UDB for iSeries sample schema
  • Chapter 2. Introducing iSeries Navigator
  • 2.1 Spotlight on iSeries Navigator
  • 2.2 What you can do with iSeries Navigator
  • 2.3 What's new for iSeries Navigator in V5R2
  • 2.4 What's new for iSeries Navigator in V5R3
  • Part 2 Database administration
  • Chapter 3. Working with databases using iSeries Navigator
  • 3.1 Getting started with iSeries Navigator
  • 3.1.1 Overview of DB2 UDB for iSeries through iSeries Navigator
  • 3.1.2 Introduction to database objects in iSeries Navigator
  • 3.2 Working with database objects
  • 3.2.1 Schemas
  • 3.2.2 Tables
  • 3.2.3 Views
  • 3.2.4 Aliases
  • 3.2.5 Indexes
  • 3.2.6 Triggers, procedures, functions, and distinct types
  • 3.2.7 Sequences
  • 3.2.8 Packages
  • 3.2.9 Journal management
  • 3.2.10 Reorganizing tables
  • 3.2.11 Transactions
  • Chapter 4. Defining and managing constraints
  • 4.1 Constraints
  • 4.2 Key constraints
  • 4.2.1 Unique constraints
  • 4.2.2 Primary key constraints
  • 4.3 Referential constraints
  • 4.3.1 Constraint prerequisites
  • 4.3.2 Creating a referential constraint
  • 4.4 Check constraints
  • 4.4.1 Defining a check constraint
  • 4.4.2 General considerations
  • 4.5 Managing constraints
  • 4.5.1 Constraint states
  • 4.5.2 Managing check pending constraints
  • Chapter 5. Database Navigator maps
  • 5.1 Closeup on Database Navigator
  • 5.2 Database Navigator map interface
  • 5.2.1 Database Navigator map display
  • 5.3 Available options on each active icon on a map
  • 5.3.1 Table options
  • 5.4 Index options.
  • 5.4.1 Constraint options
  • 5.4.2 View options
  • 5.4.3 Journal options
  • 5.4.4 Journal receiver options
  • 5.5 Creating a Database Navigator map
  • 5.5.1 Adding new objects to a map
  • 5.5.2 Changing the objects to include in a map
  • 5.5.3 Changing object placement and arranging objects in a map
  • 5.5.4 Creating a user-defined relationship
  • 5.6 The Database Navigator map icons
  • Chapter 6. Reverse engineering and Generate SQL
  • 6.1 A closer look at the Generate SQL function
  • 6.1.1 System requirements and planning
  • 6.1.2 Generate SQL features and options
  • 6.2 Generating SQL from the schema in iSeries Navigator
  • 6.2.1 Generating SQL to PC and data source files on the iSeries server
  • 6.2.2 Generating SQL from the Database Navigator map
  • 6.2.3 Generating SQL from DDS
  • Chapter 7. Run SQL Script Center
  • 7.1 Run SQL Scripts
  • 7.1.1 ODBC and JDBC connection
  • 7.1.2 Running a CL command under SQL script
  • 7.1.3 Run SQL Scripts Run options
  • 7.1.4 SQL Assist
  • 7.2 Change Query Attributes
  • 7.3 Current SQL for a job
  • 7.4 SQL Performance Monitors
  • 7.5 System Debugger
  • Chapter 8. Visual Explain
  • 8.1 A brief history of the database and SQL
  • 8.2 Database tuning so far
  • 8.2.1 Query optimizer debug messages
  • 8.2.2 Database Monitor
  • 8.2.3 The PRTSQLINF command
  • 8.2.4 Iterative approach
  • 8.3 A closer look at Visual Explain
  • 8.3.1 What is Visual Explain
  • 8.3.2 Finding Visual Explain
  • 8.4 Using Visual Explain with the SQL Script Center
  • 8.4.1 The SQL Script Center
  • 8.4.2 Visual Explain Only
  • 8.4.3 Run and Explain
  • 8.5 Navigating Visual Explain
  • 8.5.1 Menu options
  • 8.5.2 Action menu items
  • 8.5.3 Controlling the diagram level of detail
  • 8.5.4 Displaying the query environment
  • 8.5.5 Visual Explain query attributes and values
  • 8.6 Using Visual Explain with Database Monitor data.
  • 8.7 Non-SQL interface considerations
  • 8.7.1 Query for iSeries and Visual Explain
  • 8.7.2 The Visual Explain icons
  • 8.8 SQL performance analysis using Visual Explain
  • Related publications
  • IBM Redbooks
  • Other publications
  • Online resources
  • How to get IBM Redbooks
  • Help from IBM
  • Index
  • Back cover.

Ejemplares similares