IBM i5/iSeries Primer Concepts and Techniques

This comprehensive, 35-chapter book is the ultimate resource and a "must-have" for every professional working with the i5/iSeries. It is perfect for novice and intermediate programmers as well as for system administrators and operators. In simple, straightforward style, the authors explain core i5/iSeries concepts and show you step by step how to perform a wide variety of essential functions. This book is a learning tool and valuable reference you will use for years to come. As one satisfied reader put it, "If you could own only one i5/iSeries book, this would be it."

Ted Holt is the author of Complete CL, The MC Press Desktop Encyclopedia of Tips, Techniques, and Programming Practices for iSeries and AS/400, and Open Query File Magic. He lives in Corinth, Mississippi. Kevin Forsythe has 20 years of experience on the iSeries and other platforms as programmer, analyst, consultant, and instructor. He lives in Oregon, Ohio. Doug Pence and Ron Hawkins make up the research and development department of CPU Medical Management Systems.

Preface to the Fourth Edition

xiii

Introduction

xv

SECTION 1: Installation

Getting Up and Running

3

(14)

Planning Physical Space

3

(4)

IBM's Part of the Deal

7

(1)

You Take Over

8

(4)

Make the System Available

12

(5)

SECTION 2: Operations

Powering Up and Down

17

(12)

Unattended IPL

17

(1)

Attended IPL

18

(1)

The Start-Up Program

18

(4)

Ending Subsystems

22

(3)

Power Down the System

25

(1)

Automatic Power Schedule

25

(4)

Controlling the System

29

(14)

The System Console

29

(1)

The Hardware Management Console

30

(3)

Getting Help

33

(1)

Checking System Activity

34

(2)

Display Jobs

36

(1)

Job Logs

37

(3)

The System Log, QHST

40

(3)

Subsystems

43

(8)

Running QBASE

43

(2)

Running Multiple Subsystems

45

(2)

Maintaining Your Own Subsystems

47

(4)

Working with Printed Output

51

(16)

About Output Queues

52

(2)

Commands to Control Printed Output

54

(8)

Controlling Printer Writers

62

(1)

Holding and Releasing Writers

63

(4)

Backup and Recovery

67

(18)

Initializing

68

(1)

Backing Up

69

(9)

Restoring

78

(4)

Disaster Recovery Planning

82

(1)

Using Save Files

83

(2)

Operational Assistant

85

(16)

Accessing OA

85

(16)

User Messages

101

(10)

Sending Messages

101

(3)

Displaying Messages

104

(2)

Sending Break Messages

106

(5)

Commands and System Help

111

(24)

OS/400 Command Name Structure

111

(3)

Finding a Command

114

(5)

Command Parameters

119

(1)

Customizing IBM Commands

120

(2)

The Command Prompter

122

(5)

System Help

127

(8)

SECTION 3: Administration

iSeries Navigator

135

(40)

Installing

135

(39)

Summary

174

(1)

System Values

175

(16)

System Value References

175

(1)

Managing System Values

176

(2)

Date Time and Editing System Values

178

(2)

Security System Values

180

(6)

Library List System Values

186

(1)

System Control System Values

187

(2)

Power Up and Down System Values

189

(2)

iSeries Access on i5

191

(14)

Where Do I Get iSeries Access?

191

(1)

iSeries Access Basics

192

(1)

Configuring iSeries Access

193

(9)

iSeries Access File Transfer

202

(1)

iSeries Access Macros

203

(1)

Summary

204

(1)

Elements of Security and Configuration

205

(36)

Authorities

205

(6)

User Profiles

211

(3)

Group Profiles and Authorization Lists

214

(3)

Device Descriptions

217

(6)

Job Descriptions

223

(2)

Output Queues

225

(3)

Security Tools

228

(13)

Printing

241

(10)

Output Queues

241

(4)

Printers

245

(2)

Assigning a Printer to a User

247

(1)

Workstations

247

(2)

Where Output Goes

249

(2)

Journaling and Commitment Control

251

(10)

Journals and Journal Receivers

251

(7)

Commitment Control

258

(3)

Maintenance

261

(8)

IBM or Third Party?

261

(1)

Maintenance Agreements

262

(1)

IPLing Regularly

263

(1)

Performing an Unattended IPL

263

(1)

Reclaiming Storage

263

(2)

DASD Saving Techniques

265

(4)

Manuals

269

(10)

Printed Manuals

269

(1)

Online Manuals

270

(3)

Some Important Manuals

273

(6)

Upgrading to a New Release

279

(12)

Preparation

280

(3)

Execution

283

(8)

SECTION 4: System Architecture

Libraries, Objects, and Library Lists

291

(24)

Single-Level Storage

291

(1)

Libraries

292

(1)

Objects

292

(1)

Other System Storage

293

(1)

IBM Libraries

293

(6)

User Libraries

299

(2)

Working with Objects

301

(4)

Objects

305

(5)

Library Lists

310

(5)

Database and Device Files

315

(20)

Classification of Files

315

(1)

Physical Files

316

(4)

Source Files

320

(1)

Simple Logical Files

321

(2)

Join Logical Files

323

(2)

Display and Printer Files

325

(2)

Sharing Files

327

(2)

Overriding Files

329

(6)

Understanding the S/36 Environment

335

(18)

Libraries and Objects

335

(1)

Names

336

(1)

S/36E Structure

336

(1)

Entering the Environment

337

(2)

Leaving the Environment

339

(1)

Maintaining the Environment

340

(3)

Operation Control Language

343

(5)

RPG II

348

(5)

SECTION 5: Programming

Data Description Specifications

353

(30)

Coding DDS

354

(1)

The A-Specs

355

(2)

Complexity of DDS

357

(1)

Physical Files

357

(1)

A Simple Example

357

(4)

Simple Logical Files

361

(3)

Join Logical Files

364

(1)

An Example of a Join File

364

(2)

Multiformat Logical Files

366

(4)

Display Files

370

(6)

Printer Files

376

(7)

Control Language

383

(18)

Commands and Parameters

383

(5)

Control Commands

388

(5)

Dealing with Errors

393

(2)

Retrieving Data

395

(2)

Using Files

397

(4)

RPG IV

401

(16)

Overview

401

(7)

The C-Specs

408

(9)

SQL on i5 and iSeries

417

(42)

SQL Basics for Beginners

417

(11)

Schemas, Collections, Libraries, and Databases

428

(6)

Getting Started with STRSQL

434

(2)

Getting Started with the SQL Scripting Tool

436

(9)

Optimizing SQL

445

(7)

Using QM Query

452

(5)

RUNSQLSTM

457

(1)

Summary

458

(1)

JAVA on i5 and iSeries

459

(16)

What Is Java?

459

(3)

Why Use Java on i5?

462

(1)

Where to Get Java

462

(1)

Java Basics

462

(2)

Compiling Java

464

(1)

Running Java

465

(1)

Java Variables

465

(2)

Passing Arguments to Java

467

(1)

Arithmetic in Java

468

(1)

Adding Logic to Java

469

(1)

Exception Handling in Java

470

(1)

Instantiation

471

(1)

Java Methods

472

(1)

Inheritance

473

(1)

Summary

474

(1)

Qshell

475

(10)

Installation of Qshell

476

(1)

Running Qshell

476

(5)

Qshell Scripting

481

(1)

Utilities

482

(3)

Sorting Data

485

(12)

Using Physical File Keys

486

(1)

Using a Logical File

486

(3)

Using OPNQRYF

489

(4)

Using FMTDTA

493

(4)

IBM Utilities

497

(34)

PDM

497

(9)

SEU

506

(10)

SDA

516

(15)

SECTION 6: The Internet

Putting the i5 on the Net

531

(14)

Terminology

532

(2)

Internet Connection

534

(1)

Transmission Control Protocol/Internet Protocol

535

(5)

Internet Security

540

(1)

i5 Security

540

(1)

Implementing a Firewall

541

(1)

All Connected and No Place to Go

542

(1)

Net.Data

542

(1)

CGIDEV2

543

(1)

Web Sites to Visit

543

(2)

Programming with the HTTP Server

545

(22)

HTTP Server

545

(1)

Which HTTP Server?

546

(1)

Installing the HTTP Server

546

(1)

Creating a New Server Instance

547

(5)

Using an HTTP Server

552

(1)

Configuring an HTTP Server

553

(5)

Building a Simple Web Page

558

(1)

Calling iSeries Programs from a Browser

559

(1)

What Is a CGI Program?

560

(1)

Where Do I Start?

560

(1)

How Do I Write the RPG Code?

561

(2)

Small Steps in Web Development

563

(4)

SECTION 7: Troubleshooting

Basic Troubleshooting

567

(6)

Severe Trouble

567

(1)

Mild Trouble

568

(5)

Using ECS

573

(10)

Managing ECS

573

(8)

Uses of ECS

581

(2)

Reporting Problems

583

(14)

The ANZPRB Command

583

(12)

Working with Problem Logs

595

(2)

PTF Management

597

(8)

Reporting a Problem

597

(1)

HIPER PTFs

598

(1)

Requesting PTFs

599

(2)

Installing PTFs

601

(1)

Displaying PTFs

602

(1)

Applying PTFs Permanently

603

(1)

Removing PTFs

604

(1)

Glossary

605

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

IBM i5/iSeries Primer Concepts and Techniques for Programmers, Administrators, and System Operators

Summary

Author Biography

Table of Contents

Supplemental Materials