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

by Holt, Ted; Forsythe, Kevin; Pence, Doug; Hawkins, Ron

• ISBN13: 9781583470398
• ISBN10: 1583470395
• Edition: 4th
• Format: Paperback
• Copyright: 2006-05-01
• Publisher: MC Press

Summary

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."

Author Biography

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.

Table of Contents

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