DB2 UDB for Linux on iSeries implementation guide / International Technical Support Organization, [Yessong Johng, Takaki Kimachi, Wei Wang].

Format:

Book

Author/Creator:

Johng, Yessong.

Contributor:

Kimachi, Takaki.

Wang, Wei.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

IBM Database 2.

Linux.

Physical Description:

1 online resource (144 p.)

Edition:

1st ed.

Other Title:

Database two UDB for Linux on iSeries implementation guide

Place of Publication:

White Plains, NY : IBM, International Technical Support Organization, 2004.

Language Note:

English

System Details:

text file

Summary:

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 Linux partition on an IBM eServer iSeries system. Linux is one of the fastest growing operating systems in the industry today. Linux is quickly becoming a key enabler for e-business applications that are demanding more robust local database capabilities. Applications running in the Linux partition can certainly leverage DB2 UDB for iSeries through a variety of interfaces (DB2 Connect, JDBC, ODBC), and this is an excellent choice to leverage the low administration overhead, autonomic computing, and security benefits provided by DB2’s tight integration with OS/400. DB2 for Linux is an excellent choice to support Linux (or other client/server) applications when there is a need to have local data storage within the Linux application environment or to leverage specific features of DB2 UDB V8 such as Federated Database or Microsoft .NET Framework support.

Contents:

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

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"April 2004."

"SG24-6081-00."

Includes bibliographical references and index.

OCLC:

62772173