DB2 UDB for Linux on iSeries implementation guide

This IBM Redbooks publication discusses DB2 UDB for Linux on iSeries. We provide the installation and configuration steps for DB2 UDB for Linux on iSeries. We also present connectivity scenarios between OS/400 resources and Linux resources. With V8.1, DB2 UDB for Linux is available for running in a...

Descripción completa

Detalles Bibliográficos
Autor principal: Johng, Yessong (-)
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Otros Autores: Kimachi, Takaki, Wang, Wei
Formato: Libro electrónico
Idioma:Inglés
Publicado: White Plains, NY : IBM, International Technical Support Organization 2004.
Edición:1st ed
Colección:IBM redbooks.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627170506719
Tabla de Contenidos:
  • Front cover
  • Contents
  • Notices
  • Trademarks
  • Preface
  • The team that wrote this redbook
  • Become a published author
  • Comments welcome
  • Chapter 1. Introduction to DB2 for Linux on iSeries
  • 1.1 What is DB2 UDB for Linux on iSeries ?
  • 1.2 DB2 UDB for Linux on iSeries products overview
  • 1.3 Positioning of DB2 UDB for Linux on iSeries
  • 1.3.1 Common features across the DB2 family
  • 1.3.2 DB2 UDB for Linux on iSeries V8 features
  • 1.3.3 iSeries benefits
  • Chapter 2. Installation and configuration
  • 2.1 Tutorial for a basic understanding of DB2 for Linux
  • 2.1.1 Database objects
  • 2.1.2 Users and authorities
  • 2.1.3 Topics for DB2 operation
  • 2.2 Installation of DB2 UDB 8.1
  • 2.2.1 Requirements
  • 2.2.2 vnc overview
  • 2.2.3 Installing the DB2
  • 2.3 Create and test the sample database
  • 2.3.1 Create the db2 sample database
  • 2.3.2 Test the sample database
  • Chapter 3. Connectivity with DB2 UDB for iSeries
  • 3.1 Connectivity overview
  • 3.2 DB2 Connect introduction
  • 3.2.1 Overview
  • 3.2.2 DB2 Connect and .NET Framework Application
  • 3.3 How to configure DB2 Connect
  • 3.3.1 The environment
  • 3.3.2 Configuration parameters
  • 3.3.3 Configuration on the OS/400 partition
  • 3.3.4 Configuration on the Linux partition
  • 3.4 Introduction to the scenarios
  • 3.4.1 Create the sample database in OS/400
  • 3.5 CLI scenario
  • 3.5.1 CLI programming
  • 3.5.2 Compile and run
  • 3.6 ODBC scenario
  • 3.6.1 ODBC setup
  • 3.6.2 isql
  • 3.6.3 ODBC programming
  • 3.6.4 Compile and run
  • 3.7 Embedded SQL scenario
  • 3.7.1 Embedded SQL programming
  • 3.7.2 Compile and run
  • 3.8 JDBC scenario
  • 3.8.1 JDBC overview
  • 3.8.2 JDBC drivers provided by DB2 UDB for Linux
  • 3.8.3 JDBC type 2 driver scenario
  • 3.8.4 JDBC type 4 driver scenario
  • 3.8.5 Sample JDBC program
  • 3.9 SQLJ scenario
  • 3.9.1 What is SQLJ ?.
  • 3.9.2 How SQLJ works in Linux on iSeries
  • 3.9.3 Configuration
  • 3.9.4 Sample programs
  • Appendix A. Accessing DB2 UDB for Linux from OS/400 application
  • Overview
  • Requirements
  • Configuration
  • OS/400 configuration
  • Linux configuration
  • Interactive SQL
  • CLI scenario
  • Compile and run
  • CLI for OS/400 local DB
  • Embedded SQL scenario
  • Compile and run
  • Related publications
  • IBM Redbooks
  • Other publications
  • Online resources
  • How to get IBM Redbooks
  • Help from IBM
  • Index
  • Back cover.