DB2 Universal Database for iSeries Administration : The Graphical Way on V5R3.

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.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.