i5/OS Information Center, Version 5 Release 4
About information center
Overview and what's new
Notices
Hardware topics
Software topics
Printable PDFs and manuals
FAQ about information center
Information center updates
Site map
Memo to users
Connecting to System i
Choose your connection
Connecting to System i: Web clients
iSeries Access for Web
Connecting to System i: Windows clients
iSeries Access for Windows
EZ-Setup
iSeries Navigator
Connecting to System i: Linux clients
iSeries Access for Linux iSeries
Connecting to System i: Wireless clients
iSeries Access for Wireless
iSeries Navigator for Wireless
IBM Toolbox for Java 2 Micro Edition
Connecting to System i: Interfaces
iSeries Navigator
EZ-Setup
Character-based interface
Connecting to System i: Consoles
Telnet
Connecting to System i: Consoles
Operations Console
Twinaxial Console
Hardware Management Console (HMC)
Thin Console
iSeries Access
iSeries Access for Web
What's new for V5R4
Printable PDF
License information
Planning
iSeries Access for Web offerings
Web application
Portal application
Security considerations
Single sign-on considerations
Configuring Enterprise Identity Mapping
Checklist: Planning, installing, and configuring
Prerequisites for installing iSeries Access for Web
Hardware requirements
Performance tuning
iSeries software requirements
SSL usage notes
PTF requirements
Web browser requirements
Browser considerations
Deleting the beta release
Upgrade considerations
Installing iSeries Access for Web on the iSeries server
Installing iSeries Access for Web
Installing iSeries Access for Web PTFs
iSeries Access for Web in a Web application server environment
Configuring iSeries Access for Web
Examples for configuring a new Web application server environment
i5/OS integrated Web application server
WebSphere Application Server V6.1 for i5/OS
WebSphere Application Server Network Deployment V6.1 for i5/OS
WebSphere Application Server - Express V6.1 for i5/OS
WebSphere Application Server V6.0 for OS/400
WebSphere Application Server V6.0 for OS/400 with Single sign-on
WebSphere Application Server Network Deployment V6.0 for OS/400
WebSphere Application Server - Express for iSeries V5.1
WebSphere Application Server V5.1 for iSeries
WebSphere Application Server - Express for iSeries V5.0
WebSphere Application Server V5.0 for iSeries
ASF Tomcat
Examples for configuring an existing Web application server environment
WebSphere Application Server V6.1 for i5/OS
WebSphere Application Server Network Deployment V6.1 for i5/OS
WebSphere Application Server - Express V6.1 for i5/OS
WebSphere Application Server V6.0 for OS/400
WebSphere Application Server Network Deployment V6.0 for OS/400
WebSphere Application Server - Express for iSeries V5.1
WebSphere Application Server V5.1 for iSeries
WebSphere Application Server - Express for iSeries V5.0
WebSphere Application Server V5.0 for iSeries
ASF Tomcat
New Web application server considerations
Customizing iSeries Access for Web
Policies
Default page content
Home page
Customized content
Special tags
Style sheets
Main page
Customized content
Page template
Customized content
Special tags
Style sheets
Login template
Customized content
Special tags
Style sheets
Using iSeries Access for Web
iSeries Access for Web functions
5250
Command
Customize
Database
Download
File
Jobs
Mail
Messages
My folder
My home page
Other
Print
URL interfaces
NLS considerations
Saving and restoring iSeries Access for Web
iSeries Access for Web in a portal environment
Portal concepts
Cooperative portlets
Cross-site scripting
Configuring iSeries Access for Web
Examples for configuring a new portal environment
Workplace Services Express V2.6
WebSphere Portal - Express for Multiplatforms V5.0.2 (iSeries)
WebSphere Portal - Express for Multiplatforms V5.0.2 (iSeries) with Single sign-on
Examples for configuring an existing portal environment
IBM WebSphere Portal V6.0
Workplace Services Express V2.6
WebSphere Portal - Express for Multiplatforms V5.0.2 (iSeries)
Customizing iSeries Access for Web
Creating pages
Customizing portlets
Portal roles
Using iSeries Access for Web
iSeries Access for Web functions
5250
Command
Database
Files
IFrame
Other
Print
NLS considerations
Saving and restoring iSeries Access for Web
Deleting iSeries Access for Web
Related information
iSeries Access for Windows
Introduction
Installation and setup
What's new for V5R4
Printable PDF
License information
Setting up the System i platform
Prerequisites to install iSeries Access for Windows on i5/OS
i5/OS release requirements
i5/OS storage requirements
Required and optional programs to install
Installing iSeries Access for Windows on the i5/OS
Obtaining and installing PTFs
Configuring TCP/IP on i5/OS platform
Configuring iSeries NetServer on i5/OS
Removing iSeries Access for Windows from i5/OS
Setting up the PC
Prerequisites to set up the PC
Setting up TCP/IP on the PC
Installing a network adapter or modem
Configuring TCP/IP support on the PC
Configuring TCP/IP on Windows operating systems
Adding the system name to the HOSTS file
Configuring TCP/IP over twinaxial connections
Verifying the TCP/IP configuration
Configuring the PC for iSeries NetServer
Installing iSeries Access for Windows on the PC
Installing from iSeries NetServer
Installing from a CD-ROM
Installing from a network drive
Installing on multiple PCs
Creating and using a tailored installation image of iSeries Access for Windows
Creating a CD-ROM
Performing a silent installation of iSeries Access for Windows
Creating response files for iSeries Access for Windows installations
Example: Response file (setup.iss)
Starting a silent installation
Return codes for silent installations
SMS switch
Installing service packs
Installing the service pack silently
When to check service level function
Setting check service level properties
Scheduling check service level
Obtaining and installing PTFs
Sites for downloading service packs
Accessing scheduled tasks remotely
Integrating plug-ins
Installing or removing individual components
Installing other language versions
Upgrading iSeries Access for Windows
Uninstalling iSeries Access for Windows from the PC
Related information
Using
Administration
What's new for V5R4
Printable PDF
iSeries Access for Windows network environments
Microsoft Windows Terminal Server
Use iSeries Access for Windows in a three-tier environment
Using distributed transaction support
Access iSeries services from the middle tier
Add TCP/IP configuration to all users
Set PC5250 files location for all users
User profiles for PCs with multiple users
ODBC administration
Overview of the iSeries Access ODBC driver
Set up your system for the iSeries Access ODBC driver
Adding the local system to the RDB directory
Specify the ODBC data source
Use independent ASPs through ODBC
iSeries Access for Windows ODBC security
Common ODBC strategies that are not secure
ODBC program security strategies
Related information for ODBC security
Troubleshoot ODBC
ODBC diagnostic and performance tools
Client-side ODBC diagnostic and performance tools
Server-side ODBC diagnostic and performance tools
Collecting an ODBC Trace (SQL.LOG)
Gather a detailed trace
Gather a detail trace for a Microsoft Transaction Server (MTS)
iSeries Access ODBC error messages
Troubleshoot the iSeries connection
Checking the server status
Verifying that subsystems are active
Verifying that prestart jobs are running
Additional TCP/IP considerations
Common ODBC errors
SQL errors
SQL0104 - Token &1 was not valid. Valid tokens: &2
SQL0113 - Name &1 not allowed.
SQL0114 - Relational database &1 not the same as current &2 server
SQL0204 - MYSYSCONF not found
SQL0208 - ORDER BY column not in result table
SQL0900 - Application process not in a connected state
SQL0901 - SQL System Error
SQL5001 - Column qualifier or table &2 undefined.
SQL5016 - Object name &1 not valid for naming convention
SQL7008 - &1 in &2 not valid for operation. The reason code is 3
Stored procedure errors
SQL0444 - External program &A in &B not found (DB2 UDB SQL)
No data returned on OUTPUT and INPUT_OUTPUT parameters
SQL0501 - Cursor CRSR000x not open
ODBC incorrect output and unpredictable errors
Gather information for IBM Support
Host server administration
Identify i5/OS host servers and associated programs.
Host servers by function
File server
Database server
Database server programs
SQL packages
SQL package names
Cleanup SQL packages
Statement naming conventions
Rules and restrictions when using DRDA
Data queue server
Network print server
Central server
Remote command and distributed program call server
Signon server
Server Port Mapper
Extended Dynamic Remote SQL server (QXDAEDRSQL)
DRDA/DDM server
Use i5/OS host servers
Establish client/server communications
Host Servers port numbers
Port numbers for host servers and server mapper
Start host servers
Server daemons
Example: STRHOSTSVR
End host servers
Example: ENDHOSTSVR
iSeries Subsystems
Subsystems used for server Jobs
Use of autostart jobs
Use of prestart jobs
iSeries system values
Identify and display iSeries server jobs
Use iSeries Navigator to identify server jobs
Use the iSeries character-based interface to display server job
iSeries job names
Display using WRKACTJOB
Display using the history log
Display server job for a user
Use EZ-Setup and iSeries Navigator with host servers
Use server exit programs
Register exit programs
Write exit programs
Exit program parameters
File server
Database server
Data queue server
Network print server
Central server
Remote command and distributed program call server
Signon server
Examples: Exit programs
Examples: Creating exit programs with RPG
Examples: Create exit programs with CL commands
iSeries NetServer administration
Restrict users with policies and application administration
Overview of iSeries Access for Windows policies
Set up your system to use policies
Configure a system for using iSeries Access for Windows policies
Configure client PCs for policies
Create policy files
Microsoft System Policy Editor
Create iSeries Access for Windows policy templates
Create and update policy files
iSeries Access for Windows policy list
Policies by function
Policies by function: .NET Data provider
.NET Data Provider policy: Prevent .NET Data Provider usage
Policies by function: ActiveX automation objects
ActiveX policy: Prevent data transfer upload automation object
ActiveX policy: Prevent data transfer download automation object
ActiveX policy: Prevent Remote Command automation object
ActiveX policy: Prevent Remote program automation object
ActiveX policy: Prevent data queue automation object
Policies by function: Communication
Communication policy: Default user mode
Communications policy: TCP/IP Address Lookup Mode
Communication policy: Port lookup mode
Communication policy: Require Secure Sockets
Communication policy: Prevent changes to active environment
Communication policy: Prevent environment list changes
Communication policy: Prevent connections to systems not previously defined
Communication policy: Prevent use of non-mandated environments
Communication policy: Timeout value
Policies by function: Data Transfer
Policies by function: Data Transfer uploads
Data Transfer policy: Prevent all Data Transfer
Data Transfer policy: Prevent appending and replacing host files
Data Transfer policy: Prevent Data Transfer GUI upload
Data Transfer policy: Prevent usage of RFROMPCB
Data Transfer policy: Prevent autostart uploads
Data Transfer policy: Data Transfer iSeries file creation
Data Transfer policy: Prevent host file creation
Data Transfer policy: Prevent Wizard iSeries file creation
Data Transfer policy: Prevent non-Wizard iSeries file creation
Data Transfer policy: Data Transfer downloads
Data Transfer policy: Prevent all Data Transfers from a system
Data Transfer policy: Prevent Data Transfer GUI download
Data Transfer policy: Prevent usage of RTOPCB
Data Transfer policy: Prevent autostart downloads
Policies by function: Directory update
Directory update policy: Prevent using directory update
Policies by function: Incoming Remote Command
Incoming Remote Command policy: Run as system
Incoming Remote Command policy: Command mode
Incoming Remote Command policy: Cache security
Incoming Remote Command policy: Allow generic security
Incoming Remote Command policy: Generic Security Runs command as logged on user
Policies by function: Installation
Installation policy: Selective setup source directory
Installation policy: Prevent Setup
Installation policy: Prevent Selective Setup
Installation policy: Prevent uninstall
Installation policy: Prevent check service pack level
Installation policy: Prevent installation of service pack
Installation policy: Prevent upgrades
Installation policy: Prevent installation of individual components
Policies by function: License management
License policy: Time to delay before releasing iSeries Access for Windows license
Policies by function: National Language Support
National Language Support policy: ANSI code page
National Language Support policy: OEM code page
National Language Support policy: EBCDIC code page
Language policy: BiDi Transform
Policies by function: ODBC
ODBC policy: Prevent use of named data sources
ODBC policy: Prevent use of program generated data sources
Policies by function: OLE DB
OLE DB Provider policy: Prevent OLE DB Provider usage
Policies by function: iSeries Navigator
iSeries Navigator policy: Prevent usage of iSeries Navigator
Policies by function: Passwords
Password policy: Warn user before iSeries password expires
Password policy: Prevent iSeries Access for Windows password changes
Policies by function: PC5250 emulation
PC5250 emulation policy: Prevent configuration of display sessions
PC5250 emulation policy: Prevent configuration of printer sessions
PC5250 emulation policy: Prevent usage of PC5250 Emulator
PC5250 emulation policy: Maximum number of PC5250 sessions
PC5250 emulation policy: Prevent changing of .WS profiles
PC5250 emulation policy: Prevent menu configuration
PC5250 emulation policy: Prevent toolbar configuration
PC5250 emulation policy: Prevent multi-session configuration
PC5250 emulation policy: Prevent keyboard configuration
PC5250 emulation policy: Prevent mouse configuration
PC5250 emulation policy: Prevent Java applet execution
PC5250 emulation policy: Prevent access to macros
PC5250 emulation policy: Prevent profile imports in Emulator Session Manager
PC5250 emulation policy: Prevent profile deletion in Emulator Session Manager
PC5250 emulation policy: Prevent directory changes in Emulator Session Manager
Policies by function: PC Commands
PC command policy: Prevent use of Cwblogon.exe
PC command policy: Prevent use of Cwbcfg.exe
PC command policy: Prevent use of Cwbback.exe
PC command policy: Prevent use of Cwbrest.exe
PC command policy: Prevent use of Cwbenv.exe
PC command policy: Prevent use of cwbundbs.exe
PC command policy: Prevent use of Wrksplf.exe
PC command policy: Prevent use of wrkmsg.exe
PC command policy: Prevent use of wrkprt.exe
PC command policy: Prevent use of wrkusrj.exe
Policies by function: Service
Service policy: When to check service level
Service policy: Delay time
Service policy: Frequency
Service policy: Copy image to PC
Service policy: Run silently
Service policy: Service path
Service policy: Autostart background service job
Policies by function: User interface
User interface policy: Prevent creation of desktop icons
Policies by template
Caecfg.adm
Caerestr.adm: iSeries Access for Windows Runtime Restrictions
Config.adm: iSeries Access for Windows mandated connections
Caeinrst.adm: Install restrictions
SYSNAME.adm: Per-system policies
Secure Sockets Layer (SSL) administration
Code license and disclaimer information
Programming
What's new
Printable PDFs
iSeries Access for Windows C/C++ APIs
iSeries Access for Windows C/C++ APIs overview
API groups, header files, import libraries, and DLLs
Programmer's Toolkit
Install the Programmer's Toolkit
Launch the Programmer's Toolkit
iSeries name formats for connection APIs
OEM, ANSI, and Unicode considerations
Use a single iSeries Access for Windows API type
Use mixed iSeries Access for Windows API types
Write a generic iSeries Access for Windows application
Obsolete iSeries Access for Windows APIs
Obsolete Communications APIs
Obsolete Data Queues APIs
Obsolete Remote Command/Distributed Program Call APIs
Obsolete Security APIs
Obsolete Serviceability APIs
Obsolete System Object Access (SOA) API
Obsolete National Language Support (NLS) APIs
Obsolete Database APIs
Return codes and error messages
iSeries Access for Windows return codes that correspond to operating system errors
iSeries Access for Windows return codes
Global iSeries Access for Windows return codes
iSeries Access for Windows-specific return codes
Security return codes
Communications return codes
Configuration return codes
Automation Object return codes
WINSOCK return codes
SSL return codes
iSeries Access for Windowscomponent-specific return codes
Administration APIs return code
Communications APIs return codes
Database APIs return codes
Data Queues APIs return codes
Directory Update APIs return codes
National language support APIs return codes
iSeries Object APIs return codes
Remote Command/Distributed Program Call APIs return codes
Security APIs return codes
Serviceability APIs return codes
System Object Access APIs return codes
iSeries Access for WindowsAdministration APIs
Administration APIs list
cwbAD_GetClientVersion
cwbAD_GetProductFixLevel
cwbAD_IsComponentInstalled
cwbAD_IsOpNavPluginInstalled
Example: Administration APIs
iSeries Access for Windows Communications and Security APIs
System object attributes
System object attributes list
Communications and security: Create and delete APIs
cwbCO_CreateSystem
cwbCO_CreateSystemLike
cwbCO_DeleteSystem
Communications and security: Connect and disconnect APIs
cwbCO_Connect
cwbCO_Disconnect
cwbCO_GetConnectTimeout
cwbCO_GetPersistenceMode
cwbCO_IsConnected
cwbCO_SetConnectTimeout
cwbCO_SetPersistenceMode
cwbCO_Verify
Communication and security: Security validation and data APIs
cwbCO_ChangePassword
cwbCO_GetDefaultUserMode
cwbCO_GetFailedSignons
cwbCO_GetPasswordExpireDate
cwbCO_GetPrevSignonDate
cwbCO_GetPromptMode
cwbCO_GetSignonDate
cwbCO_GetUserIDEx
cwbCO_GetValidateMode
cwbCO_GetWindowHandle
cwbCO_HasSignedOn
cwbCO_SetDefaultUserMode
cwbCO_SetPassword
cwbCO_SetPromptMode
cwbCO_SetUserIDEx
cwbCO_SetWindowHandle
cwbCO_SetValidateMode
cwbCO_Signon
cwbCO_VerifyUserIDPassword
Communications and security: Get and set attribute APIs
cwbCO_CanModifyDefaultUserMode
cwbCO_CanModifyIPAddress
cwbCO_CanModifyIPAddressLookupMode
cwbCO_CanModifyPersistenceMode
cwbCO_CanModifyPortLookupMode
cwbCO_CanModifyUseSecureSockets
cwbCO_GetDescription
cwbCO_GetHostCCSID
cwbCO_GetHostVersionEx
cwbCO_GetIPAddress
cwbCO_GetIPAddressLookupMode
cwbCO_GetPortLookupMode
cwbCO_GetSystemName
cwbCO_IsSecureSockets
cwbCO_SetIPAddress
cwbCO_SetIPAddressLookupMode
cwbCO_SetPortLookupMode
cwbCO_UseSecureSockets
Defines for cwbCO_Service
Differences between cwbCO_Signon and cwbCO_VerifyUserIDPassword
Similarities between cwbCO_Signon and cwbCO_VerifyUserIDPassword
Communications: Create and delete APIs
cwbCO_CreateSysListHandle
cwbCO_CreateSysListHandleEnv
cwbCO_DeleteSysListHandle
cwbCO_GetNextSysName
cwbCO_GetSysListSize
Communications: System information APIs
cwbCO_GetActiveConversations
cwbCO_GetConnectedSysName
cwbCO_GetDefaultSysName
cwbCO_GetHostVersion
cwbCO_GetUserID
cwbCO_IsSystemConfigured
cwbCO_IsSystemConfiguredEnv
cwbCO_IsSystemConnected
Communications: Configured environments information
cwbCO_GetActiveEnvironment
cwbCO_GetEnvironmentName
cwbCO_GetNumberOfEnvironments
Communications: Environment and connection information
cwbCO_CanConnectNewSystem
cwbCO_CanModifyEnvironmentList
cwbCO_CanModifySystemList
cwbCO_CanModifySystemListEnv
cwbCO_CanSetActiveEnvironment
Example: Using iSeries Access for Windows communications APIs
iSeries Access for Windows Data Queues APIs
Data queues
Ordering data queue messages
Work with data queues
Typical use of data queues
Data Queues: Create, delete, and open APIs
cwbDQ_CreateEx
cwbDQ_DeleteEx
cwbDQ_OpenEx
Data Queues: Accessing data queues APIs
cwbDQ_AsyncRead
cwbDQ_Cancel
cwbDQ_CheckData
cwbDQ_Clear
cwbDQ_Close
cwbDQ_Create
cwbDQ_Delete
cwbDQ_GetLibName
cwbDQ_GetQueueAttr
cwbDQ_GetQueueName
cwbDQ_GetSysName
cwbDQ_Open
cwbDQ_Peek
cwbDQ_Read
cwbDQ_Write
Data Queues: Attributes APIs
cwbDQ_CreateAttr
cwbDQ_DeleteAttr
cwbDQ_GetAuthority
cwbDQ_GetDesc
cwbDQ_GetForceToStorage
cwbDQ_GetKeySize
cwbDQ_GetMaxRecLen
cwbDQ_GetOrder
cwbDQ_GetSenderID
cwbDQ_SetAuthority
cwbDQ_SetDesc
cwbDQ_SetForceToStorage
cwbDQ_SetKeySize
cwbDQ_SetMaxRecLen
cwbDQ_SetOrder
cwbDQ_SetSenderID
Data Queues: Read and write APIs
cwbDQ_CreateData
cwbDQ_DeleteData
cwbDQ_GetConvert
cwbDQ_GetData
cwbDQ_GetDataAddr
cwbDQ_GetDataLen
cwbDQ_GetKey
cwbDQ_GetKeyLen
cwbDQ_GetRetDataLen
cwbDQ_GetRetKey
cwbDQ_GetRetKeyLen
cwbDQ_GetSearchOrder
cwbDQ_GetSenderInfo
cwbDQ_SetConvert
cwbDQ_SetData
cwbDQ_SetDataAddr
cwbDQ_SetKey
cwbDQ_SetSearchOrder
Example: Using Data Queues APIs
iSeries Access for Windows Data Transformation and National Language Support (NLS) APIs
iSeries Access for Windows data transformation APIs
iSeries Access for Windows data transformation API list
cwbDT_ASCII11ToBin4
cwbDT_ASCII6ToBin2
cwbDT_ASCIIPackedToPacked
cwbDT_ASCIIToHex
cwbDT_ASCIIToPacked
cwbDT_ASCIIToZoned
cwbDT_ASCIIZonedToZoned
cwbDT_Bin2ToASCII6
cwbDT_Bin2ToBin2
cwbDT_Bin4ToASCII11
cwbDT_Bin4ToBin4
cwbDT_EBCDICToEBCDIC
cwbDT_HexToASCII
cwbDT_PackedToASCII
cwbDT_PackedToASCIIPacked
cwbDT_PackedToPacked
cwbDT_ZonedToASCII
cwbDT_ZonedToASCIIZoned
cwbDT_ZonedToZoned
Example: Using data transformation APIs
iSeries Access for Windows National Language Support (NLS) APIs
Coded character sets
iSeries Access for Windows general NLS APIs list
cwbNL_FindFirstLang
cwbNL_FindNextLang
cwbNL_GetLang
cwbNL_GetLangName
cwbNL_GetLangPath
cwbNL_SaveLang
iSeries Access for Windows conversion NLS APIs list
cwbNL_CCSIDToCodePage
cwbNL_CodePageToCCSID
cwbNL_Convert
cwbNL_ConvertCodePages
cwbNL_ConvertCodePagesEx
cwbNL_CreateConverter
cwbNL_CreateConverterEx
cwbNL_DeleteConverter
cwbNL_GetCodePage
cwbNL_GetANSICodePage
cwbNL_GetHostCCSID
iSeries Access for Windows dialog-box NLS API list
cwbNL_CalcControlGrowthXY
cwbNL_CalcDialogGrowthXY
cwbNL_GrowControlXY
cwbNL_GrowDialogXY
cwbNL_LoadDialogStrings
cwbNL_LoadMenu
cwbNL_LoadMenuStrings
cwbNL_SizeDialog
Example: iSeries Access for Windows NLS APIs
iSeries Access for Windows Directory Update APIs
Typical use of iSeries Access for Windows Directory Update APIs
Requirements for Directory Update entries
Options for Directory Update entries
Directory Update package files syntax and format
Directory Update sample program
Directory Update: Create and delete APIs
cwbUP_CreateUpdateEntry
cwbUP_DeleteEntry
Directory Update: Access APIs
cwbUP_FindEntry
cwbUP_FreeLock
cwbUP_GetEntryHandle
Directory Update: Free Resources APIs
cwbUP_FreeEntryHandle
Directory Update: Change APIs
cwbUP_AddPackageFile
cwbUP_RemovePackageFile
cwbUP_SetCallbackDLL
cwbUP_SetDescription
cwbUP_SetEntryAttributes
cwbUP_SetSourcePath
cwbUP_SetTargetPath
Directory Update: Information APIs
cwbUP_GetCallbackDLL
cwbUP_GetDescription
cwbUP_GetEntryAttributes
cwbUP_GetLockHolderName
cwbUP_GetSourcePath
cwbUP_GetTargetPath
iSeries Access for Windows PC5250 emulation APIs
System Objects APIs for iSeries Access for Windows
iSeries Access objects attributes
Advanced Function Printing
Align Page
Allow Direct Print
Authority
Authority to Check
Automatically End Writer
Back Margin Offset Across
Back Margin Offset Down
Backside Overlay Library Name
Backside Overlay Name
Back Overlay offset across
Back Overlay Offset Down
Characters per Inch
Code Page
Coded Font Name
Coded Font Library Name
Copies
Copies left to Produce
Current Page
Data Format
Data Queue Library Name
Data Queue Name
Date File Opened
User Specified DBCS Data
DBCS Extension Characters
DBCS Character Rotation
DBCS Characters per Inch
DBCS SO/SI Spacing
Defer Write
Degree of Page Rotation
Delete File After Sending
Destination Option
Destination Type
Device Class
Device Model
Device Type
Display any File
Drawer for Separators
Ending Page
File Separators
Fold Records
Font Identifier
Form Feed
Form Type
Form Type Message Option
Front Margin Offset Across
Front Margin Offset Down
Front Overlay Library Name
Front Overlay Name
Front Overlay Offset Across
Front Overlay Offset Down
Graphic Character Set
Hardware Justification
Hold Spool File
Initialize the writer
Internet Address
Job Name
Job Number
Job Separators
Job User
Last Page Printed
Length of Page
Library Name
Lines Per Inch
Manufacturer Type and Model
Maximum Spooled Output Records
Measurement Method
Message Help
Message ID
Message Queue Library Name
Message Queue
Message Reply
Message Text
Message Type
Message Severity
Number of Bytes to Read/Write
Number of Files
Number of Writers Started to Queue
Object Extended Attribute
Open time commands
Operator Controlled
Order of Files On Queue
Output Priority
Output Queue Library Name
Output Queue Name
Output Queue Status
Overflow Line Number
Pages Per Side
Pel Density
Point Size
Print Fidelity
Print on Both Sides
Print Quality
Print Sequence
Print Text
Printer
Printer Device Type
Printer File Library Name
Printer File Name
Printer Queue
Record Length
Remote System
Replace Unprintable Characters
Replacement Character
Resource library name
Resource name
Resource object type
Restart Printing
Save Spooled File
Seek Offset
Seek Origin
Send Priority
Separator page
Source Drawer
Spool SCS
Spool the Data
Spooled File Name
Spooled File Number
Spooled File Status
Spooled Output Schedule
Starting Page
Text Description
Time File Opened
Total Pages
Transform SCS to ASCII
Unit of Measure
User Comment
User Data
User defined data
User defined object library
User defined object name
User defined object type
User defined option(s)
User driver program
User driver program library
User driver program name
User ID
User ID Address
User transform program library
User transform program name
VM/MVS Class
When to Automatically End Writer
When to End Writer
When to Hold File
Width of Page
Workstation Customizing Object Name
Workstation Customizing Object Library
Writer Job Name
Writer Job Number
Writer Job Status
Writer Job User Name
Writer Starting Page
Network Print Server Object Attributes
NPS Attribute Default Value
NPS Attribute High Limit
NPS Attribute ID
NPS Attribute Low Limit
NPS Attribute Possible Value
NPS Attribute Text Description
NPS Attribute Type
NPS CCSID
NPS Object
NPS Object Action
NPS Level
List APIs for iSeries Access for Windows
cwbOBJ_CloseList
cwbOBJ_CreateListHandle
cwbOBJ_DeleteListHandle
cwbOBJ_GetListSize
cwbOBJ_OpenList
cwbOBJ_ResetListAttrsToRetrieve
cwbOBJ_ResetListFilter
cwbOBJ_SetListAttrsToRetrieve
cwbOBJ_SetListFilter
cwbOBJ_SetListFilterWithSplF
iSeries Access for Windows Object APIs
cwbOBJ_CopyObjHandle
cwbOBJ_DeleteObjHandle
cwbOBJ_GetObjAttr
cwbOBJ_GetObjAttrs
cwbOBJ_GetObjHandle
cwbOBJ_GetObjHandleFromID
cwbOBJ_GetObjID
cwbOBJ_RefreshObj
cwbOBJ_SetObjAttrs
iSeries Access for Windows Parameter object APIs
cwbOBJ_CopyParmObjHandle
cwbOBJ_CreateParmObjHandle
cwbOBJ_DeleteParmObjHandle
cwbOBJ_GetParameter
cwbOBJ_SetParameter
iSeries Access for Windows Writer job APIs
cwbOBJ_EndWriter
cwbOBJ_StartWriter
iSeries Access for Windows output queues APIs
cwbOBJ_HoldOutputQueue
cwbOBJ_PurgeOutputQueue
cwbOBJ_ReleaseOutputQueue
iSeries Access for Windows AFP resource APIs
cwbOBJ_CloseResource
cwbOBJ_CreateResourceHandle
cwbOBJ_DisplayResource
cwbOBJ_OpenResource
cwbOBJ_OpenResourceForSplF
cwbOBJ_ReadResource
cwbOBJ_SeekResource
iSeries Access for Windows APIs for new spooled files
cwbOBJ_CloseNewSplF
cwbOBJ_CloseNewSplFAndGetHandle
cwbOBJ_CreateNewSplF
cwbOBJ_GetSplFHandleFromNewSplF
cwbOBJ_WriteNewSplF
APIs for reading spooled files for iSeries Access for Windows
cwbOBJ_CloseSplF
cwbOBJ_OpenSplF
cwbOBJ_ReadSplF
cwbOBJ_SeekSplF
APIs for manipulating spooled files for iSeries Access for Windows
cwbOBJ_CallExitPgmForSplF
cwbOBJ_CreateSplFHandle
cwbOBJ_CreateSplFHandleEx
cwbOBJ_DeleteSplF
cwbOBJ_DisplaySplF
cwbOBJ_HoldSplF
cwbOBJ_IsViewerAvailable
cwbOBJ_MoveSplF
cwbOBJ_ReleaseSplF
cwbOBJ_SendNetSplF
cwbOBJ_SendTCPSplF
APIs for handling spooled file messages for iSeries Access for Windows
cwbOBJ_AnswerSplFMsg
cwbOBJ_GetSplFMsgAttr
APIs for analyzing spooled file data for iSeries Access for Windows
cwbOBJ_AnalyzeSplFData
Server program APIs for iSeries Access for Windows
cwbOBJ_DropConnections
cwbOBJ_GetNPServerAttr
cwbOBJ_SetConnectionsToKeep
Example: Using iSeries Objects APIs for iSeries Access for Windows
iSeries Access for Windows Remote Command/Distributed Program Call APIs
Typical use of iSeries Access for Windows Remote Command/Distributed Program Call APIs
Remote Command/Distributed Program Call: Access remote command APIs list for iSeries Access for Windows
cwbRC_GetClientCCSID
cwbRC_GetHostCCSID
cwbRC_StartSysEx
cwbRC_StopSys
Remote Command/Distributed Program Call: Run APIs list for iSeries Access for Windows
cwbRC_RunCmd
Remote Command/Distributed Program Call: Access programs APIs list for iSeries Access for Windows
cwbRC_AddParm
cwbRC_CallPgm
cwbRC_CreatePgm
cwbRC_DeletePgm
cwbRC_GetLibName
cwbRC_GetParm
cwbRC_GetParmCount
cwbRC_GetPgmName
cwbRC_SetLibName
cwbRC_SetParm
cwbRC_SetPgmName
Example: Using Remote iSeries Access for Windows Command/Distributed Program Call APIs
iSeries Access for Windows Serviceability APIs
History log and trace files
Error handles
Typical use of Serviceability APIs
Serviceability APIs list: Writing to history log
cwbSV_CreateMessageTextHandle
cwbSV_DeleteMessageTextHandle
cwbSV_LogMessageText
cwbSV_SetMessageClass
cwbSV_SetMessageComponent
cwbSV_SetMessageProduct
Serviceability APIs list: Writing trace data
cwbSV_CreateTraceDataHandle
cwbSV_DeleteTraceDataHandle
cwbSV_LogTraceData
cwbSV_SetTraceComponent
cwbSV_SetTraceProduct
Serviceability API list: Writing trace points
cwbSV_CreateTraceAPIHandle
cwbSV_CreateTraceSPIHandle
cwbSV_DeleteTraceAPIHandle
cwbSV_DeleteTraceSPIHandle
cwbSV_LogAPIEntry
cwbSV_LogAPIExit
cwbSV_LogSPIEntry
cwbSV_LogSPIExit
cwbSV_SetAPIComponent
cwbSV_SetAPIProduct
cwbSV_SetSPIComponent
cwbSV_SetSPIProduct
Serviceability API list: Reading service files
cwbSV_ClearServiceFile
cwbSV_CloseServiceFile
cwbSV_CreateServiceRecHandle
cwbSV_DeleteServiceRecHandle
cwbSV_GetComponent
cwbSV_GetDateStamp
cwbSV_GetMaxRecordSize
cwbSV_GetMessageText
cwbSV_GetProduct
cwbSV_GetRecordCount
cwbSV_GetServiceFileName
cwbSV_GetServiceType
cwbSV_GetTimeStamp
cwbSV_GetTraceData
cwbSV_GetTraceAPIData
cwbSV_GetTraceAPIID
cwbSV_GetTraceAPIType
cwbSV_GetTraceSPIData
cwbSV_GetTraceSPIID
cwbSV_GetTraceSPIType
cwbSV_OpenServiceFile
cwbSV_ReadNewestRecord
cwbSV_ReadNextRecord
cwbSV_ReadOldestRecord
cwbSV_ReadPrevRecord
Serviceability API list: Retrieving message text
cwbSV_CreateErrHandle
cwbSV_DeleteErrHandle
cwbSV_GetErrClass
cwbSV_GetErrClassIndexed
cwbSV_GetErrCount
cwbSV_GetErrFileName
cwbSV_GetErrFileNameIndexed
cwbSV_GetErrLibName
cwbSV_GetErrLibNameIndexed
cwbSV_GetErrSubstText
cwbSV_GetErrSubstTextIndexed
cwbSV_GetErrText
cwbSV_GetErrTextIndexed
Example: Using iSeries Access for Windows Serviceability APIs
iSeries Access for Windows System Object Access (SOA) APIs
SOA objects
iSeries object views
Typical use of System Object Access APIs for iSeries Access for Windows
Displaying a customized list of iSeries objects
Sample program: Displaying a customized list of iSeries objects
Displaying the Properties view for an iSeries Object
Sample program: Displaying the Properties view of an object
Accessing and updating data for iSeries Objects
Sample program: Accessing and updating data for iSeries objects
iSeries Access for Windows System Object Access programming considerations
About System Object Access errors
System Object Access application profiles
Managing iSeries communications sessions for application programs
System Object Access APIs for iSeries Access for Windows List
CWBSO_CloseList
CWBSO_CopyObjHandle
CWBSO_CreateErrorHandle
CWBSO_CreateListHandle
CWBSO_CreateListHandleEx
CWBSO_CreateObjHandle
CWBSO_CreateParmObjHandle
CWBSO_DeleteErrorHandle
CWBSO_DeleteListHandle
CWBSO_DeleteObjHandle
CWBSO_DeleteParmObjHandle
CWBSO_DisallowListActions
CWBSO_DisallowListFilter
CWBSO_DisplayErrMsg
CWBSO_DisplayList
CWBSO_DisplayObjAttr
CWBSO_GetErrMsgText
CWBSO_GetListSize
CWBSO_GetObjAttr
CWBSO_GetObjHandle
CWBSO_OpenList
CWBSO_ReadListProfile
CWBSO_RefreshObj
CWBSO_ResetParmObj
CWBSO_SetListFilter
CWBSO_SetListProfile
CWBSO_SetListSortFields
CWBSO_SetListTitle
CWBSO_SetObjAttr
CWBSO_SetParameter
CWBSO_WaitForObj
CWBSO_WriteListProfile
SOA attribute special values
Job attributes
Message attributes
Printer attributes
Printer output attributes
TCP/IP interfaces attributes
Ethernet lines attributes
Token-ring lines attributes
Hardware resources attributes
Software products attributes
TCP/IP routes attributes
Users and groups attributes
Libraries in QSYS attributes
iSeries Access for Windows: Database programming
iSeries Access for Windows .NET provider
iSeries Access for Windows OLE DB provider
iSeries Access ODBC
Files required to build an ODBC application
Choose an interface to access the ODBC driver
ODBC C/C++ application header files
ODBC APIs: General concepts
Parameter markers
SQLFetch and SQLGetData
Code directly to ODBC APIs
Call stored procedures
Block insert and block fetch C example
Example: Block inserts using Visual Basic
Visual Basic: The compromise between Jet and ODBC APIs
Retrieve results
Access a database server with an ODBC application
Establish ODBC connections
Execute ODBC functions
Execute prepared statements
Convert strings and arrays of byte
ODBC API return codes
End ODBC functions
Implementation issues of ODBC APIs
ODBC 3.x APIs Notes
SQL Statement Considerations
Connection string keywords
Connection string keywords - General properties
Connection string keywords - Server properties
Connection string keywords - Format properties
Connection string keywords - Package properties
Connection string keywords - Performance properties
Connection string keywords - Sort properties
Connection string keywords - Catalog properties
Connection string keywords - Translation properties
Connection string keywords - Diagnostic properties
Connection string keywords - other properties
Version and release changes in the ODBC driver behavior
ODBC API restrictions and unsupported functions
Signon dialog behavior
ODBC data types and how they correspond to DB2 UDB database types
Large objects (LOBs) considerations
Example: Use the BLOB data type
Connection and statement attributes
Connection pooling
SQLPrepare and SQLNativeSQL escape sequences and scalar functions
Distributed transaction support
Cursor Behavior Notes
Extended dynamic disabled error
ODBC 64-bit Windows and Linux Considerations
Restrictions of the 64–bit iSeries Access for Windows ODBC Driver
SQLTables Description
Handle long-running queries
Commitment control considerations
iSeries Access for Windows ODBC performance
Performance-tuning iSeries Access for Windows ODBC
Introduction to server performance
Introduction to client/server performance
The performance architecture of the iSeries Access for Windows ODBC driver
Select a stringent level of commitment control
Fine-tune record-blocking
Use Extended Dynamic SQL
Performance considerations of common end-user tools
Examples: Common tool behaviors that degrade ODBC performance
Example: Query tool A
Example: Query tool B
Example: Query tool C
SQL performance
SQL performance general considerations
Database design
Normalization
Table size
Use indexes
Match attributes of join fields
Optimizer
Cost estimation
Optimizer decision-making rules
ODBC blocked insert statement
Catalog functions
Exit programs
Examples: User exit programs
Example: ILE C/400 user exit program for exit point QIBM_QZDA_INIT
Example: CL user exit program for exit point QIBM_QZDA_INIT
Example: ILE C/400 Program for exit point QIBM_QZDA_SQL1
Example: ILE C/400 program for exit point QIBM_QZDA_ROI1
Exit program parameter formats
Parameter fields for exit point QIBM_QZDA_SQL2 format ZDAQ0200
Parameter fields for exit point QIBM_QZDA_INIT format ZDAI0100
Parameter fields for exit point QIBM_QZDA_NDB1 format ZDAD0100
Parameter fields for exit point QIBM_QZDA_NDB1 format ZDAD0200
Parameter fields for exit point QIBM_QZDA_SQL1 format ZDAQ0100
Parameter fields for exit point QIBM_QZDA_ROI1 format ZDAR0100
Parameter fields for exit point QIBM_QZDA_ROI1 format ZDAR0200
Stored procedures
Stored procedure result sets
Examples: Stored procedures
Example: Run CL commands that use SQL stored procedures and ODBC
Example: Stored procedure calls from Visual Basic with return values
Example: Call an iSeries stored procedure by using Visual Basic
Example: Call CL command stored procedures
Tips: Run and call iSeries stored procedures
ODBC program examples
Example: Visual C++ - Access and return data by a call to a stored procedure
Example: Visual Basic - Access and return data by a call to a stored procedure
Examples: RPG - Host code for ODBC stored procedures
iSeries Access for Windows database APIs
Java programming
ActiveX programming
Operations Console
What's new for V5R4
Printable PDFs
Planning considerations for Operations Console
Planning considerations for your configuration
Console planning considerations
Planning considerations for your backup console
Scenarios: Selecting your configuration
Scenario: A single console directly attached to the system without remote support
Scenario: A single console directly attached to the system with remote support
Scenario: Consoles for multiple systems or partitions
Preparation for your network environment
Security of your Operations Console configuration
Preparation for your Operations Console and iSeries Navigator configuration
Verification of Operations Console requirements
Operations Console hardware requirements
Operations Console software requirements
Operations Console cable requirements
Verification of available communications port
Planning considerations for your Operations Console installation or upgrade
Planning considerations for your control panel
Remote control panel
Virtual control panel
Limitations of the virtual control panel
Installing the virtual control panel
PC preparations for Operations Console
Completing the setup prerequisite checklist
Setting up a local console directly attached to the server
Completing prerequisite checklist for Windows 2000: Local console directly attached to the server
Completing prerequisite checklist for Windows XP: Local console directly attached to the server
Setting up a local console directly attached to the server with remote access allowed
Completing prerequisite checklist for Windows 2000: Local console directly attached to the server with remote access allowed
Completing prerequisite checklist for Windows XP: Local console directly attached to the server with remote access allowed
Setting up a local console on a network
Completing prerequisite checklist for Windows 2000: Local console on a network
Completing prerequisite checklist for Windows XP: Local console on a network
Setting up a remote console through dial-up support
Completing prerequisite checklist for Windows 2000: Remote console through dial-up support
Completing prerequisite checklist for Windows XP: Remote console through dial-up support
Completing required prerequisite tasks
Installing iSeries Access for Windows
Applying iSeries Access for Windows service packs
Installing Operations Console connection modem
Installing Operations Console connection modem for Windows 2000
Installing Operations Console connection modem for Windows XP
Installing PC modem
Installing PC modem for Windows 2000
Installing PC modem for Windows XP
Granting remote access
Granting remote access for Windows 2000
Granting remote access for Windows XP
Creating and configuring incoming connections
Creating and configuring incoming connections for Windows 2000
Creating and configuring incoming connections for Windows XP
Installing an Operations Console cable
Cabling a model 830 or a model 840 Operations Console
Configuring Operations Console on the PC
Completing the setup interview
Managing Operations Console
Managing your console configuration
Changing a console configuration
Deleting a console configuration
Connecting a local console to a system
Connecting a local console on a network to a system
Connecting to another system
Connecting a local console directly attached to the system
Connecting a remote console to a local console by modem
Control tasks between users
Granting or refusing control to a remote console
System i control
Default user (SERVER)
Identifying user in control of a system
Displaying the remote control panel in read-only mode
Requesting and releasing control at the local console
Sending a message to a controlling remote console
Requesting control at the remote console
Releasing control at the remote console
Sending a message to a controlling local console or remote console
Transferring control between users
Using the Properties page
Customizing the Operations Console window
Management of multiple consoles
Multiple local PC consoles on a network
Multiple remote consoles through dial-up support connecting to the same local console directly attached to the system
Switching from one console type to another when a console is currently available
Switching from one console type to another when the current console is not operational
Takeover or recovery of an Operations Console connection
Takeover details
Recovery details
Enabling console takeover
Scenarios: Takeover and recovery
Scenario: LAN connected devices only with takeover enabled
Scenario: A normal IPL and dual-connectivity configurations with take over enabled
Scenario: Recovery of a console requiring a new console type setting
Scenario: How to recover the console during a D-mode IPL with take over enabled
Changing from one console type to another
Changing from a local console directly attached to a local console on a network (LAN)
Changing the console from a local console directly attached to a local console on a network (LAN) in a non-partitioned or primary partitioned system
Changing the console from a local console directly attached to a local console on a network in a logical partition
Configuring the PC to use the new console type when changing from a local console directly attached to a local console on a network
Changing from a local console on a network (LAN) to a local console directly attached
Changing the console from local console on a network (LAN) to a local console directly attached for a non-partitioned system or a primary partition
Changing the console from local console on a network (LAN) to a local console directly attached for a logical partition
Configuring the PC to use the new console type
Changing from a twinaxial console to an Operations Console
Changing the console from a twinaxial console to an Operations Console in a non-partitioned or primary partitioned system
Changing the console from a twinaxial console to an Operations Console in a logical partition
Configuring the PC to use the new console type after changing from a twinaxial console to an Operations Console
Changing from an Operations Console to a twinaxial console
Changing the console from an Operations Console to a twinaxial console in a non-partitioned or primary partitioned system
Changing the console from an Operations Console to a twinaxial console in a logical partition
Performing optional steps on the PC when changing from an Operations Console to a twinaxial console
Managing your local console on a network
Considerations for changing the service tools device ID passwords
Changing the service tools device ID password on the PC and system
Changing the access password
Resynchronizing the PC and service tools device ID password
Resetting the service tools device ID password on the system
Resetting the service tools device ID password on the PC
Creating service tools device IDs on the system
Configuring a service host name (interface name)
Deallocating or moving the LAN adapter card from use by Operations Console
Changing network values for Operations Console (LAN)
Completing the PC changes
Common tasks
Changing keyboard definitions
Starting the system using a manual IPL
Activating the asynchronous communications line on the system
Deactivating the asynchronous communications line on the system
Using the console service functions (65+21)
Using the OPSCONSOLE macro
Using service tools device IDs in system service tools
Troubleshooting Operations Console connection
Troubleshooting status message
Status messages when configuration is running normally
Status messages when you have connection problems
Troubleshooting connection problems
Local console connection problems
Console fails to connect
Network connection errors
Error message: The connection to the system is not a secure connection
Local or remote console status remains Connecting
Console fails to connect and port detection fails
Performance degradation on local console
Unable to make a connection when infrared devices are installed
Unexpected disconnections
Using HyperTerminal to validate connectivity between client and the system
Installing HyperTerminal
Using HyperTerminal
Remote console connection problems
Remote console through dial-up fails to connect to local console
Local console name mismatch when remote console connects to the local console
Troubleshooting authentication problems
Authentication errors
Troubleshooting emulator problems
PC5250 window does not display user data
Troubleshooting system reference code data
System reference code A6nn500x
System reference code A6005001, A6005004, and A6005007
System reference code A6005008
System reference code A9002000
System reference code A6005082
Failure to display D1008065 and D1008066 automatically after calling the function
IPL step C6004031 takes longer than expected
Troubleshooting remote control panel and virtual control panel problems
Remote control panel fails to start
Unable to use the mode function
Authentication problems
Troubleshooting configuration wizard problems
Local console does not detect console cable
Old network data interfering with reconfiguration of network connectivity
Troubleshooting other Operations Console problems
Operations Console remains in QCTL
System requests do not work
Unable to sign on because of a lost or expired password or disabled user ID
iSeries Access for Wireless
iSeries Navigator for Wireless
What's new for V5R4
Printable PDF
Setting up iSeries Navigator for Wireless
Hardware and software requirements
Selecting a device
Selecting a device: Internet-ready telephones
Selecting a device: PDAs
Selecting a device: PCs
Developing an Internet protection program
Configuring your wireless environment
Configuring a Web application server
Configuring your ASF Jakarta Tomcat servlet engine for HTTP Server (powered by Apache)
Configuring your WebSphere Application Server, Base Edition, Version 5.1
Configuring your WebSphere Application Server, Express Edition, Version 5.1
Configuring your WebSphere Application Server, Version 6.0
Configuring your firewall
Configuring Management Central
Selecting a language
Connecting to your central system
Customizing your connection
Managing your systems with iSeries Navigator for Wireless
Working with systems
Working with Integrated xSeries Servers
Working with tasks
Running commands across multiple systems
Viewing and interacting with monitors
System monitors
Job monitors
Message monitors
File monitors
B2B activity monitors
Related information for iSeries Navigator for Wireless
IBM Toolbox for Java 2 Micro Edition
iSeries Access for Linux
What's new
Printable PDFs
IBM iSeries Access for Linux license information
Prerequisites for using iSeries Access for Linux
Install iSeries Access for Linux
Update iSeries Access for Linux
Uninstall iSeries Access for Linux
iSeries Access for Linux security
iSeries Access for Linux 5250 emulation
Prerequisites for using 5250 emulation
Configure 5250 emulation
Command line emulator options
X resources for the iSeries Access for Linux emulator
Color mapping
Image/fax (3849 emulation)
Keyboard remapping
Miscellaneous preferences
Popup/pull down keypads
Record/playback
Screen print
Session ID
Languages for your emulator
Emulator resources
Troubleshoot 5250 emulation
5250 problem isolation
Font problems
iSeries Access for Linux 5250 emulation FAQs
iSeries Access for Linux Open Database Connectivity
Prerequisites for using ODBC
ODBC language considerations
ODBC 64-bit Windows and Linux Considerations
Restrictions when using ODBC with iSeries Access for Linux
Configure an ODBC data source
Use GUI to configure an ODBC data source
Manually configure an ODBC data source
ODBC examples
Troubleshoot an iSeries Access for Linux ODBC
ODBC problem isolation
Error messages
ODBC FAQs
iSeries Access for Linux utilities
CWBCOPWR - Change advanced communications settings
CWBMEDIC - Service information collection tool
CWBNLTBL - Download conversion tables
CWBPING - Test the connection to the server
CWBRUNSQL - Run batch SQL commands and procedures using an ODBC DSN
CWBTRC - Trace iSeries Access for Linux
RMTCMD - Run an iSeries batch/CL command
RMTODBC - Run an iSeries batch/CL command using the ODBC driver
iSeries Navigator
Getting to know iSeries Navigator
What's new for iSeries Navigator in V5R4
Printable PDF
iSeries Navigator functions by release
Requirements for installing iSeries Navigator
Installing iSeries Navigator
Adding system connections to iSeries Navigator
Working with iSeries Navigator
Related information for iSeries Navigator
iSeries Navigator for Wireless
What's new for V5R4
Printable PDF
Setting up iSeries Navigator for Wireless
Hardware and software requirements
Selecting a device
Selecting a device: Internet-ready telephones
Selecting a device: PDAs
Selecting a device: PCs
Developing an Internet protection program
Configuring your wireless environment
Configuring a Web application server
Configuring your ASF Jakarta Tomcat servlet engine for HTTP Server (powered by Apache)
Configuring your WebSphere Application Server, Base Edition, Version 5.1
Configuring your WebSphere Application Server, Express Edition, Version 5.1
Configuring your WebSphere Application Server, Version 6.0
Configuring your firewall
Configuring Management Central
Selecting a language
Connecting to your central system
Customizing your connection
Managing your systems with iSeries Navigator for Wireless
Working with systems
Working with Integrated xSeries Servers
Working with tasks
Running commands across multiple systems
Viewing and interacting with monitors
System monitors
Job monitors
Message monitors
File monitors
B2B activity monitors
Related information for iSeries Navigator for Wireless
iSeries Navigator tasks on the Web
What's new for V5R4
Printable PDF
Setting up iSeries Navigator tasks on the Web
Setting up iSeries Navigator tasks on the Web: Prerequisites
Configuring security for iSeries Navigator tasks on the Web
Configuring Web browser connections to iSeries Navigator tasks on the Web
Configuring data-retrieval connections to the local system and managed secondary systems
Configuring Application Administration
Working with iSeries Navigator tasks on the Web
iSeries Navigator tasks on the Web concepts
iSeries Navigator URL parameters and available Web tasks
Working with iSeries Navigator lists on the Web
Application Administration
What's new for V5R4
Printable PDF
Application Administration concepts
Application registration
Application registration on Local Settings
Application registration on Central Settings
iSeries Navigator plug-ins and Application Administration
Access settings for a function
How access to a function is determined
Administration system
How clients initially discover their administration system
Advanced settings in Central Settings
How advanced settings are obtained for a user
Mandated and suggested values
Management Central and Application Administration
When changes take effect
Application Administration as a security tool
Installing Application Administration
Planning your Application Administration strategy
Planning for Application Administration
Planning for the administration system and Central Settings
Setting up Application Administration
Setting up Application Administration for Local Settings
Setting up the administration system for Central Settings
Managing Application Administration
Registering applications for Application Administration (Local Settings)
Registering applications on the administration system (Central Settings)
Working with a function's access setting
Working with user or group access settings
Working with Central Settings
Scenarios: Application Administration
Scenario: Setting up Application Administration
Scenario: Setting up an administration system for Central Settings
Management Central
What's new for V5R4
Printable PDF
Getting started with Management Central
Before you begin
Configuring TCP prerequisite checklist
Management Central connection considerations
Installing Management Central
Checking for the most current MC code
Installing and accessing Management Central
Verifying the connection function
Setting up the central system
Setting up your central system for the first time
Management Central settings and options
Adding endpoint systems to your Management Central network
How to completely remove endpoints
Creating system groups in your Management Central network
Changing the central system setup
Management Central plug-ins
Backup, Recovery, and Media Services (BRMS)
Clusters
Working with systems with partitions
Advanced Job Scheduler
Troubleshooting Management Central connections
Working with Management Central monitors
Monitor concepts
Management collection objects
Job monitors and Collection Services
The QYRMJOBSEL job
QZRCSRVS jobs and their impact on performance
Special considerations
Creating a new monitor
Selecting the metrics
Specifying the threshold values
Specifying the collection interval
Specifying threshold run commands
Specifying event logging and actions
Applying thresholds and actions for a monitor
Viewing monitor results
Graph history concepts
Viewing graph history
Resetting triggered threshold for a monitor
Scenarios: iSeries Navigator monitors
Scenario: System monitor
Scenario: Job monitor for CPU utilization
Scenario: Job monitor with Advanced Job Scheduler notification
Scenario: Message monitor
Using other features of Management Central
Working with inventory
Viewing an inventory
How to use inventories
Running actions on an inventory
Searching a Management Central users and groups inventory
Extreme Support
Working with systems with partitions
Running commands with Management Central
Packaging and sending objects with Management Central
Distributing fixes to multiple systems with iSeries Navigator
Packaging and distribution considerations
Managing users and groups with Management Central
Sharing with other users in Management Central
Synchronizing date and time values
Synchronizing functions
Scheduling tasks or jobs with Management Central scheduler
Advanced Job Scheduler
Advanced Job Scheduler for Wireless
Scheduling jobs with Advanced Job Scheduler
What's new in Advanced Job Scheduler for V5R4
Installing the Advanced Job Scheduler
Setting up the Advanced Job Scheduler
Assigning the general properties
Specifying permission levels
Setting up a scheduling calendar
Setting up a holiday calendar
Setting up a fiscal calendar
Specifying a mail server to use for notification
Setting up multiple scheduling environments
Assigning data libraries to users
Managing the Advanced Job Scheduler
Creating and scheduling a job
Creating and scheduling a job group
Predefined schedules
Setting up a predefined schedule
Adding a schedule to a scheduled job
Adding a schedule to a holiday calendar
Creating a temporary scheduled job
Scheduling job dependencies
The Work Flow Manager
Creating a new work flow
Starting a work flow
Working with work flows
Monitoring job activity for the Advanced Job Scheduler
Scheduled job activity
Specifying the activity retention
Viewing the scheduled job activity details
Viewing the scheduled job activity for a specific job
Viewing the activity log details
Viewing the activity log for a specific job
Monitoring for messages with Advanced Job Scheduler
Creating and working with local data area
Creating and working with application controls and job controls
Working with notification
Working with library lists
Working with command variables
Working with Advanced Job Scheduler for Wireless
Hardware and software requirements
Selecting a device
Configuring your wireless environment
Configuring your Web application server
Configuring your firewall
Selecting a language
Connecting to your i5/OS operating system
Customizing your connection
Managing Advanced Job Scheduler for Wireless
Troubleshooting the Advanced Job Scheduler
Related information for Management Central
Intelligent agents
Developing iSeries Navigator plug-ins
What's new for V5R4
Printable PDF
Plug-in support in iSeries Navigator
What you can do with a plug-in
How plug-ins work
Plug-in requirements
Distributing plug-ins
Setup.ini file
Example: Information section of setup.ini
Example: Service section of setup.ini
Example: Identify files section of setup.ini
Example: Exit programs section of the setup.ini
MRI setup file
Identifying plug-ins to iSeries Navigator
Installing and running sample plug-ins
Setting up sample C++ plug-ins
Setting up sample Visual Basic plug-ins
Sample Visual Basic plug-in directory of files
Setting up the sample Java plug-ins
Sample Java plug-in directory of files
Plug-in programming reference
C++ reference
iSeries Navigator structure and flow of control for C++ plug-ins
iSeries Navigator COM interfaces for C++
Description of IA4HierarchyFolder Interface
IA4HierarchyFolder interface specifications listing
IA4HierarchyFolder::Activate
IA4HierarchyFolder::BindToList
IA4HierarchyFolder::DisplayErrorMessage
IA4HierarchyFolder::GetAttributesOf
IA4HierarchyFolder::GetColumnDataItem
IA4HierarchyFolder::GetColumnInfo
IA4HierarchyFolder::GetIconIndexOf
IA4HierarchyFolder::GetItemCount
IA4HierarchyFolder::GetToolBarInfo
IA4HierarchyFolder::GetListObject
IA4HierarchyFolder::ItemAt
IA4HierarchyFolder::ProcessTerminating
IA4HierarchyFolder::Refresh
Description of IA4PropSheetNotify interface
IA4PropSheetNotify interface specifications listing
IA4PropSheetNotify::ApplyChanges
IA4PropSheetNotify::GetErrorMessage
IA4PropSheetNotify::InformUserState
iSeries Navigator APIs
iSeries Navigator API listing
cwbUN_GetSystemValue
cwbUN_GetSystemHandle
cwbUN_ReleaseSystemHandle
cwbUN_CheckObjectAuthority
cwbUN_CheckSpecialAuthority
cwbUN_CheckAS400Name
cwbUN_GetUserAttribute
cwbUN_ConvertPidlToString
cwbUN_GetDisplayNameFromItemId
cwbUN_GetDisplayNameFromName
cwbUN_GetDisplayPathFromName
cwbUN_GetIndexFromItemId
cwbUN_GetIndexFromName
cwbUN_GetIndexFromPidl
cwbUN_GetListObject
cwbUN_GetParentFolderNameFromName
cwbUN_GetParentFolderPathFromName
cwbUN_GetParentFolderPidl
cwbUN_GetSystemNameFromName
cwbUN_GetSystemNameFromPidl
cwbUN_GetTypeFromName
cwbUN_GetTypeFromPidl
cwbUN_RefreshAll
cwbUN_RefreshList
cwbUN_RefreshListItems
cwbUN_UpdateStatusBar
cwbUN_GetODBCConnection
cwbUN_EndODBCConnections
cwbUN_GetIconIndex
cwbUN_GetSharedImageList
cwbUN_GetAdminValue
cwbUN_GetAdminValueEx
cwbUN_GetAdminCacheState
cwbUN_GetAdminCacheStateEx
cwbUN_IsSubcomponentInstalled
cwbUN_OpenLocalLdapServer
cwbUN_FreeLocalLdapServer
cwbUN_GetLdapSvrPort
cwbUN_GetLdapSvrSuffixCount
cwbUN_GetLdapSvrSuffixName
cwbUN_OpenLdapPublishing
cwbUN_FreeLdapPublishing
cwbUN_GetLdapPublishCount
cwbUN_GetLdapPublishType
cwbUN_GetLdapPublishServer
cwbUN_GetLdapPublishPort
cwbUN_GetLdapPublishParentDn
Return codes unique to iSeries Navigator APIs
Visual Basic reference
iSeries Navigator structure and flow of control for Visual Basic plug-ins
iSeries Navigator Visual Basic interfaces
iSeries Navigator ListManager interface class
iSeries Navigator ActionsManager interface class
iSeries Navigator DropTargetManager interface class
Java reference
iSeries Navigator structure and flow of control for Java plug-ins
Customizing the plug-in registry files
Customizing the C++ registry values
Primary registry key
Data server implementation
Shell plug-in implementation class
Shell plug-in implementation for objects
Shell plug-ins
Global changes for C++ plug-in registry files
Customizing the Visual Basic plug-in registry values
Primary registry key
Visual Basic plug-in implementation class
Parent field values
Example: New folder registry key
Visual Basic plug-in implementation objects
Global changes for Visual Basic plug-in registry files
Sample Java registry file
Property pages for a property sheet handler
Description of QueryContextMenu flags
Example: Constructing Visual Basic property pages for a property sheet handler
Property sheet handling in Java
Example: Java Properties Manager
Secure Sockets Layer registry entry
Operations Console
What's new for V5R4
Printable PDFs
Planning considerations for Operations Console
Planning considerations for your configuration
Console planning considerations
Planning considerations for your backup console
Scenarios: Selecting your configuration
Scenario: A single console directly attached to the system without remote support
Scenario: A single console directly attached to the system with remote support
Scenario: Consoles for multiple systems or partitions
Preparation for your network environment
Security of your Operations Console configuration
Preparation for your Operations Console and iSeries Navigator configuration
Verification of Operations Console requirements
Operations Console hardware requirements
Operations Console software requirements
Operations Console cable requirements
Verification of available communications port
Planning considerations for your Operations Console installation or upgrade
Planning considerations for your control panel
Remote control panel
Virtual control panel
Limitations of the virtual control panel
Installing the virtual control panel
PC preparations for Operations Console
Completing the setup prerequisite checklist
Setting up a local console directly attached to the server
Completing prerequisite checklist for Windows 2000: Local console directly attached to the server
Completing prerequisite checklist for Windows XP: Local console directly attached to the server
Setting up a local console directly attached to the server with remote access allowed
Completing prerequisite checklist for Windows 2000: Local console directly attached to the server with remote access allowed
Completing prerequisite checklist for Windows XP: Local console directly attached to the server with remote access allowed
Setting up a local console on a network
Completing prerequisite checklist for Windows 2000: Local console on a network
Completing prerequisite checklist for Windows XP: Local console on a network
Setting up a remote console through dial-up support
Completing prerequisite checklist for Windows 2000: Remote console through dial-up support
Completing prerequisite checklist for Windows XP: Remote console through dial-up support
Completing required prerequisite tasks
Installing iSeries Access for Windows
Applying iSeries Access for Windows service packs
Installing Operations Console connection modem
Installing Operations Console connection modem for Windows 2000
Installing Operations Console connection modem for Windows XP
Installing PC modem
Installing PC modem for Windows 2000
Installing PC modem for Windows XP
Granting remote access
Granting remote access for Windows 2000
Granting remote access for Windows XP
Creating and configuring incoming connections
Creating and configuring incoming connections for Windows 2000
Creating and configuring incoming connections for Windows XP
Installing an Operations Console cable
Cabling a model 830 or a model 840 Operations Console
Configuring Operations Console on the PC
Completing the setup interview
Managing Operations Console
Managing your console configuration
Changing a console configuration
Deleting a console configuration
Connecting a local console to a system
Connecting a local console on a network to a system
Connecting to another system
Connecting a local console directly attached to the system
Connecting a remote console to a local console by modem
Control tasks between users
Granting or refusing control to a remote console
System i control
Default user (SERVER)
Identifying user in control of a system
Displaying the remote control panel in read-only mode
Requesting and releasing control at the local console
Sending a message to a controlling remote console
Requesting control at the remote console
Releasing control at the remote console
Sending a message to a controlling local console or remote console
Transferring control between users
Using the Properties page
Customizing the Operations Console window
Management of multiple consoles
Multiple local PC consoles on a network
Multiple remote consoles through dial-up support connecting to the same local console directly attached to the system
Switching from one console type to another when a console is currently available
Switching from one console type to another when the current console is not operational
Takeover or recovery of an Operations Console connection
Takeover details
Recovery details
Enabling console takeover
Scenarios: Takeover and recovery
Scenario: LAN connected devices only with takeover enabled
Scenario: A normal IPL and dual-connectivity configurations with take over enabled
Scenario: Recovery of a console requiring a new console type setting
Scenario: How to recover the console during a D-mode IPL with take over enabled
Changing from one console type to another
Changing from a local console directly attached to a local console on a network (LAN)
Changing the console from a local console directly attached to a local console on a network (LAN) in a non-partitioned or primary partitioned system
Changing the console from a local console directly attached to a local console on a network in a logical partition
Configuring the PC to use the new console type when changing from a local console directly attached to a local console on a network
Changing from a local console on a network (LAN) to a local console directly attached
Changing the console from local console on a network (LAN) to a local console directly attached for a non-partitioned system or a primary partition
Changing the console from local console on a network (LAN) to a local console directly attached for a logical partition
Configuring the PC to use the new console type
Changing from a twinaxial console to an Operations Console
Changing the console from a twinaxial console to an Operations Console in a non-partitioned or primary partitioned system
Changing the console from a twinaxial console to an Operations Console in a logical partition
Configuring the PC to use the new console type after changing from a twinaxial console to an Operations Console
Changing from an Operations Console to a twinaxial console
Changing the console from an Operations Console to a twinaxial console in a non-partitioned or primary partitioned system
Changing the console from an Operations Console to a twinaxial console in a logical partition
Performing optional steps on the PC when changing from an Operations Console to a twinaxial console
Managing your local console on a network
Considerations for changing the service tools device ID passwords
Changing the service tools device ID password on the PC and system
Changing the access password
Resynchronizing the PC and service tools device ID password
Resetting the service tools device ID password on the system
Resetting the service tools device ID password on the PC
Creating service tools device IDs on the system
Configuring a service host name (interface name)
Deallocating or moving the LAN adapter card from use by Operations Console
Changing network values for Operations Console (LAN)
Completing the PC changes
Common tasks
Changing keyboard definitions
Starting the system using a manual IPL
Activating the asynchronous communications line on the system
Deactivating the asynchronous communications line on the system
Using the console service functions (65+21)
Using the OPSCONSOLE macro
Using service tools device IDs in system service tools
Troubleshooting Operations Console connection
Troubleshooting status message
Status messages when configuration is running normally
Status messages when you have connection problems
Troubleshooting connection problems
Local console connection problems
Console fails to connect
Network connection errors
Error message: The connection to the system is not a secure connection
Local or remote console status remains Connecting
Console fails to connect and port detection fails
Performance degradation on local console
Unable to make a connection when infrared devices are installed
Unexpected disconnections
Using HyperTerminal to validate connectivity between client and the system
Installing HyperTerminal
Using HyperTerminal
Remote console connection problems
Remote console through dial-up fails to connect to local console
Local console name mismatch when remote console connects to the local console
Troubleshooting authentication problems
Authentication errors
Troubleshooting emulator problems
PC5250 window does not display user data
Troubleshooting system reference code data
System reference code A6nn500x
System reference code A6005001, A6005004, and A6005007
System reference code A6005008
System reference code A9002000
System reference code A6005082
Failure to display D1008065 and D1008066 automatically after calling the function
IPL step C6004031 takes longer than expected
Troubleshooting remote control panel and virtual control panel problems
Remote control panel fails to start
Unable to use the mode function
Authentication problems
Troubleshooting configuration wizard problems
Local console does not detect console cable
Old network data interfering with reconfiguration of network connectivity
Troubleshooting other Operations Console problems
Operations Console remains in QCTL
System requests do not work
Unable to sign on because of a lost or expired password or disabled user ID
Twinaxial console
Hardware Management Console
Thin Console
Database
Printable PDFs
Database overview
What's new for V5R4
Printable PDF
DB2 Universal Database for iSeries
Terminology: SQL versus traditional file access
Getting started with iSeries Navigator
Starting iSeries Navigator
Creating a schema
Editing the list of schemas displayed
Creating a table and defining a column
Defining additional columns on a table
Creating the supplier table
Copying column definitions
Inserting information into a table
Viewing the contents of a table
Changing information in a table
Deleting information from a table
Copying and moving a table
Copying a table
Moving a table
Creating and using a view
Creating a view over a single table
Creating a WHERE clause
Creating a view that combines data from multiple tables
Deleting database objects
iSeries Navigator database tasks
Database objects creation tasks
Database objects operation tasks
Database performance optimization tasks
Mapping your database
Querying your database by running SQL scripts
Stopping SQL scripts
Viewing the job log
Generating SQL for existing objects
Building SQL statements with SQL Assist
Starting iSeries System Debugger
Managing check pending constraints
Importing and exporting data
Getting started with SQL
Creating a schema
Creating and using a table
Using the LABEL ON statement
Inserting information into a table
Getting information from a single table
Getting information from multiple tables
Changing information in a table
Deleting information from a table
Creating and using a view
Creating a view on a single table
Creating a view that combines data from multiple tables
Database information finder
Administration
Printable PDF
Database administration
Altering and managing database objects
Creating database objects
Ensuring data integrity
Importing and exporting data between systems
Managing journals
Working with multiple databases
Working with triggers and constraints
Writing DB2 programs
Database backup and recovery
Backup and recovery
Recovering and restoring your database
Journal management
Distributed database administration
Planning and design
Initial setup
Administration
Security
Data availability and protection
Performance
Troubleshooting
Application development
Queries and reports
V5R3 changes to Query for iSeries
Security
Controlling DDM and DRDA access
Granting object and data authority
Limiting access to specific fields of a database file
Specifying public authority
Using database file capabilities to control I/O operations
Using logical files to secure data
Commitment control
What's new for V5R4
Printable PDF
Commitment control concepts
How commitment control works
How commit and rollback operations work
Commit operation
Rollback operation
Commitment definition
Scope for a commitment definition
Commitment definition names
Example: Jobs and commitment definitions
How commitment control works with objects
Types of committable resources
Local and remote committable resources
Access intent of a committable resource
The commit protocol of a committable resource
Journaled files and commitment control
Sequence of journal entries under commitment control
Commit cycle identifier
Record locking
Commitment control and independent disk pools
Independent disk pool considerations for commitment definitions
Considerations for XA transactions
Considerations and restrictions for commitment control
Commitment control for batch applications
Two-phase commitment control
Roles in commit processing
States of the transaction for two-phase commitment control
Commitment definitions for two-phase commitment control
Commitment definition for two-phase commit: Allow vote read-only
Commitment definition for two-phase commit: Not wait for outcome
Commitment definition for two-phase commit: Indicate OK to leave out
Commitment definition for two-phase commit: Not select a last agent
Vote reliable effect on flow of commit processing
XA transaction support for commitment control
SQL server mode and thread-scoped transactions for commitment control
Starting commitment control
Commit notify object
Commit lock level
Ending commitment control
System-initiated end of commitment control
Commitment control during activation group end
Implicit commit and rollback operations
Commitment control during normal routing step end
Commitment control during abnormal system or job end
Updates to the notify object
Commitment control recovery during initial program load after abnormal end
Managing transactions and commitment control
Displaying commitment control information
Displaying locked objects for a transaction
Displaying jobs associated with a transaction
Displaying resource status of a transaction
Displaying transaction properties
Optimizing performance for commitment control
Minimizing locks
Managing transaction size
Soft commit
Scenarios and examples: Commitment control
Scenario: Commitment control
Practice problem for commitment control
Logic flow for practice problem
Steps associated with the logic flow for the practice program
Example: Using a transaction logging file to start an application
Example: Using a notify object to start an application
Example: Unique notify object for each program
Example: Single notify object for all programs
Example: Using a standard processing program to start an application
Example: Code for a standard processing program
Processing flow
Example: Code for a standard commit processing program
Example: Using a standard processing program to decide whether to restart the application
Troubleshooting transactions and commitment control
Commitment control errors
Error conditions
Nonerror conditions
Error messages to monitor during commitment control
Monitoring for errors after a CALL command
Failure of normal commit or rollback processing
Detecting deadlocks
Recovering transactions after communications failure
When to force commit and rollback operations and when to cancel resynchronization
Ending a long-running rollback
Related information
Performance and query optimization
What's new for V5R4
Printable PDF
Query Engine Overview
SQE and CQE Engines
Query Dispatcher
Statistics Manager
Plan Cache
Data access on DB2 UDB for iSeries: data access paths and methods
Permanent objects and access methods
Table
Table scan
Table probe
Radix index
Radix index scan
Radix index probe
Encoded vector index
Encoded vector index symbol table scan
Encoded vector index probe
Temporary objects and access methods
Temporary hash table
Hash table scan
Hash table probe
Temporary sorted list
Sorted list scan
Sorted list probe
Temporary list
List scan
Temporary row number list
Row number list scan
Row number list probe
Temporary bitmap
Bitmap scan
Bitmap probe
Temporary index
Temporary index scan
Temporary index probe
Temporary buffer
Buffer scan
Queue
Enqueue
Dequeue
Objects processed in parallel
Spreading data automatically
Processing queries: Overview
How the query optimizer makes your queries more efficient
General query optimization tips
Access plan validation
Single table optimization
Join optimization
Nested loop join implementation
Join optimization algorithm
Join order optimization
Cost estimation and index selection for join secondary dials
Predicates generated through transitive closure
Look ahead predicate generation (LPG)
Tips for improving performance when selecting data from more than two tables
Multiple join types for a query
Sources of join query performance problems
Tips for improving the performance of join queries
Distinct optimization
Grouping optimization
Grouping hash implementation
Index grouping implementation
Optimizing grouping by eliminating grouping columns
Optimizing grouping by adding additional grouping columns
Optimizing grouping by using index skip key processing
Optimizing grouping by removing read triggers
Ordering optimization
View implementation
View composite implementation
View materialization implementation
Materialized query table optimization
MQT supported function
Using MQTs during Query optimization
MQT examples
Details on the MQT matching algorithm
Determining unnecessary MQTs
Summary of MQT query recommendations
Recursive query optimization
Recursive query example
Multiple initialization and iterative fullselects
Predicate Pushing
Specifying SEARCH consideration
Specifying CYCLE considerations
SMP and recursive queries
Optimizing query performance using query optimization tools
Verify the performance of SQL applications
Examine query optimizer debug messages in the job log
Gather information about embedded SQL statements with the PRTSQLINF command
Viewing the plan cache with iSeries Navigator
Monitoring your queries using memory-resident database monitor
Memory-resident database monitor external API description
Memory-resident database monitor external table description
Sample SQL queries
Memory-resident database monitor row identification
Using iSeries Navigator with summary monitors
Starting a summary monitor
Analyzing summary monitor information
Importing a monitor
Monitoring your queries using Start Database Monitor (STRDBMON)
Start Database Monitor (STRDBMON) command
End Database Monitor (ENDDBMON) command
Database monitor performance rows
Database monitor examples
Database monitor performance analysis example 1
Database monitor performance analysis example 2
Database monitor performance analysis example 3
Additional database monitor examples
Using iSeries Navigator with detailed monitors
Starting a detailed monitor
Analyze detailed monitor data
Comparing monitor data
Viewing statements in a monitor
Importing a monitor
Query optimizer index advisor
Display index advisor information
Database manager indexes advised system table
Index advisor columns
Querying database monitor view 3020 - Index advised
View the implementation of your queries with Visual Explain
Starting Visual Explain
Overview of information available from Visual Explain
Change the attributes of your queries with the Change Query Attributes (CHGQRYA) command
Control queries dynamically with the query options file QAQQINI
Specifying the QAQQINI file
Creating the QAQQINI query options file
QAQQINI query options file format
Setting the options within the query options file
QAQQINI query options file authority requirements
QAQQINI file system supplied triggers
QAQQINI query options
Set resource limits with the Predictive Query Governor
Using the Query Governor
Canceling a query with the Query Governor
Controlling the default reply to the query governor inquiry message
Testing performance with the query governor
Examples of setting query time limits
Testing temporary storage usage with the query governor
Examples of setting query temporary storage limits
Control parallel processing for queries
Controlling system wide parallel processing for queries
Controlling job level parallel processing for queries
Collecting statistics with the Statistics Manager
Automatic statistics collection
Automatic statistics refresh
Viewing statistics requests
Indexes versus column statistics
Monitoring background statistics collection
Replication of column statistics with CRTDUPOBJ versus CPYF
Determining what column statistics exist
Manually collecting and refreshing statistics
Statistics Manager APIs
Display information with Database Health Center
Show Materialized Query Table columns
Manage Check Pending Constraints columns
Query optimization tools: Comparison table
Creating an index strategy
Binary radix indexes
Specifying PAGESIZE on CRTPF or CRTLF commands
General index maintenance
Encoded vector indexes
How the EVI works
When to create EVIs
EVI maintenance
Recommendations for EVI use
Comparing Binary radix indexes and Encoded vector indexes
Indexes and the optimizer
Instances where an index is not used
Determining unnecessary indexes
Show index for a table
Manage index rebuilds
Indexing strategy
Reactive approach to tuning
Proactive approach to tuning
Coding for effective indexes
Avoid numeric conversions
Avoid arithmetic expressions
Avoid character string padding
Avoid the use of like patterns beginning with % or _
Using indexes with sort sequence
Using indexes and sort sequence with selection, joins, or grouping
Using indexes and sort sequence with ordering
Examples of indexes
Index example: Equals selection with no sort sequence table
Index example: Equals selection with a unique-weight sort sequence table
Index example: Equal selection with a shared-weight sort sequence table
Index example: Greater than selection with a unique-weight sort sequence table
Index example: Join selection with a unique-weight sort sequence table
Index example: Join selection with a shared-weight sort sequence table
Index example: Ordering with no sort sequence table
Index example: Ordering with a unique-weight sort sequence table
Index example: Ordering with a shared-weight sort sequence table
Index example: Ordering with ALWCPYDTA(*OPTIMIZE) and a unique-weight sort sequence table
Index example: Grouping with no sort sequence table
Index example: Grouping with a unique-weight sort sequence table
Index example: Grouping with a shared-weight sort sequence table
Index example: Ordering and grouping on the same columns with a unique-weight sort sequence table
Index example: Ordering and grouping on the same columns with ALWCPYDTA(*OPTIMIZE) and a unique-weight sort sequence table
Index example: Ordering and grouping on the same columns with a shared-weight sort sequence table
Index example: Ordering and grouping on the same columns with ALWCPYDTA(*OPTIMIZE) and a shared-weight sort sequence table
Index example: Ordering and grouping on different columns with a unique-weight sort sequence table
Index example: Ordering and grouping on different columns with ALWCPYDTA(*OPTIMIZE) and a unique-weight sort sequence table
Index example: Ordering and grouping on different columns with ALWCPYDTA(*OPTIMIZE) and a shared-weight sort sequence table
Application design tips for database performance
Use live data
Reduce the number of open operations
Retain cursor positions
Retaining cursor positions for non-ILE program calls
Retaining cursor positions across ILE program calls
General rules for retaining cursor positions for all program calls
Programming techniques for database performance
Use the OPTIMIZE clause
Use FETCH FOR n ROWS
Improve SQL blocking performance when using FETCH FOR n ROWS
Use INSERT n ROWS
Control database manager blocking
Optimize the number of columns that are selected with SELECT statements
Eliminate redundant validation with SQL PREPARE statements
Page interactively displayed data with REFRESH(*FORWARD)
General DB2 UDB for iSeries performance considerations
Effects on database performance when using long object names
Effects of precompile options on database performance
Effects of the ALWCPYDTA parameter on database performance
Tips for using VARCHAR and VARGRAPHIC data types in databases
Database monitor: Formats
Database monitor SQL table format
Optional database monitor SQL view format
Database monitor view 1000 - SQL Information
Database monitor view 3000 - Table Scan
Database monitor view 3001 - Index Used
Database monitor view 3002 - Index Created
Database monitor view 3003 - Query Sort
Database monitor view 3004 - Temp Table
Database monitor view 3005 - Table Locked
Database monitor view 3006 - Access Plan Rebuilt
Database monitor view 3007 - Optimizer Timed Out
Database monitor view 3008 - Subquery Processing
Database monitor view 3010 - HostVar & ODP Implementation
Database monitor view 3014 - Generic QQ Information
Database monitor view 3015 - Statistics Information
Database monitor view 3018 - STRDBMON/ENDDBMON
Database monitor view 3019 - Rows retrieved
Database monitor view 3020 - Index advised (SQE)
Database monitor view 3021 - Bitmap Created
Database monitor view 3022 - Bitmap Merge
Database monitor view 3023 - Temp Hash Table Created
Database monitor view 3025 - Distinct Processing
Database monitor view 3026 - Set operation
Database monitor view 3027 - Subquery Merge
Database monitor view 3028 - Grouping
Database monitor view 3030 - Materialized query tables
Database monitor view 3031 - Recursive common table expressions
Memory Resident Database Monitor: DDS
External table description (QAQQQRYI) - Summary Row for SQL Information
External table description (QAQQTEXT) - Summary Row for SQL Statement
External table description (QAQQ3000) - Arrival sequence
External table description (QAQQ3001) - Using existing index
External table description (QAQQ3002) - Index created
External table description (QAQQ3003) - Query sort
External table description (QAQQ3004) - Temporary table
External table description (QAQQ3007) - Optimizer information
External table description (QAQQ3008) - Subquery processing
External table description (QAQQ3010) - Host variable and ODP implementation
External table description (QAQQ3030) - Materialized query table implementation
Query optimizer messages reference
Query optimization performance information messages
CPI4321 - Access path built for &18 &19
CPI4322 - Access path built from keyed file &1
CPI4323 - The query access plan has been rebuilt
CPI4324 - Temporary file built for file &1
CPI4325 - Temporary result file built for query
CPI4326 - &12 &13 processed in join position &10
CPI4327 - File &12 &13 processed in join position &10
CPI4328 - Access path of file &3 was used by query
CPI4329 - Arrival sequence access was used for &12 &13
CPI432A - Query optimizer timed out for file &1
CPI432B - Subselects processed as join query
CPI432C - All access paths were considered for file &1
CPI432D - Additional access path reason codes were used
CPI432F - Access path suggestion for file &1
CPI4330 - &6 tasks used for parallel &10 scan of file &1
CPI4331 - &6 tasks used for parallel index created over file
CPI4332 - &1 host variables used in query
CPI4333 - Hashing algorithm used to process join
CPI4334 - Query implemented as reusable ODP
CPI4335 - Optimizer debug messages for hash join step &1 follow
CPI4336 - Group processing generated
CPI4337 - Temporary hash table build for hash join step &1
CPI4338 - &1 Access path(s) used for bitmap processing of file &2
CPI433D - Query options used to build the i5/OS query access plan
CPI433F - Multiple join classes used to process join
CPI4340 - Optimizer debug messages for join class step &1 follow
CPI4341 - Performing distributed query
CPI4342 - Performing distributed join for query
CPI4343 - Optimizer debug messages for distributed query step &1 of &2 follow:
CPI4345 - Temporary distributed result file &3 built for query
CPI4346 - Optimizer debug messages for query join step &1 of &2 follow:
CPI4347 - Query being processed in multiple steps
CPI4348 - The ODP associated with the cursor was hard closed
CPI4349 - Fast past refresh of the host variables values is not possible
CPI434C - The query access plan was not rebuilt
CPI4350 - Materialized query tables were considered for optimization
CPI4351 - Additional reason codes for query access plan has been rebuilt.
Query optimization performance information messages and open data paths
SQL7910 - All SQL cursors closed
SQL7911 - ODP reused
SQL7912 - ODP created
SQL7913 - ODP deleted
SQL7914 - ODP not deleted
SQL7915 - Access plan for SQL statement has been built
SQL7916 - Blocking used for query
SQL7917 - Access plan not updated
SQL7918 - Reusable ODP deleted
SQL7919 - Data conversion required on FETCH or embedded SELECT
SQL7939 - Data conversion required on INSERT or UPDATE
PRTSQLINF message reference
SQL400A - Temporary distributed result file &1 was created to contain join result
SQL400B - Temporary distributed result file &1 was created to contain join result
SQL400C - Optimizer debug messages for distributed query step &1 and &2 follow
SQL400D - GROUP BY processing generated
SQL400E - Temporary distributed result file &1 was created while processing distributed subquery
SQL4001 - Temporary result created
SQL4002 - Reusable ODP sort used
SQL4003 - UNION
SQL4004 - SUBQUERY
SQL4005 - Query optimizer timed out for table &1
SQL4006 - All indexes considered for table &1
SQL4007 - Query implementation for join position &1 table &2
SQL4008 - Index &1 used for table &2
SQL4009 - Index created for table &1
SQL401A - Processing grouping criteria for query containing a distributed table
SQL401B - Temporary distributed result table &1 was created while processing grouping criteria
SQL401C - Performing distributed join for query
SQL401D - Temporary distributed result table &1 was created because table &2 was directed
SQL401E - Temporary distributed result table &1 was created because table &2 was broadcast
SQL401F - Table &1 used in distributed join
SQL4010 - Table scan access for table &1
SQL4011 - Index scan-key row positioning used on table &1
SQL4012 - Index created from index &1 for table &2
SQL4013 - Access plan has not been built
SQL4014 - &1 join column pair(s) are used for this join position
SQL4015 - From-column &1.&2, to-column &3.&4, join operator &5, join predicate &6
SQL4016 - Subselects processed as join query
SQL4017 - Host variables implemented as reusable ODP
SQL4018 - Host variables implemented as non-reusable ODP
SQL4019 - Host variables implemented as file management row positioning reusable ODP
SQL402A - Hashing algorithm used to process join
SQL402B - Table &1 used in hash join step &2
SQL402C - Temporary table created for hash join results
SQL402D - Query attributes overridden from query options file &2 in library &1
SQL4020 - Estimated query run time is &1 seconds
SQL4021 - Access plan last saved on &1 at &2
SQL4022 - Access plan was saved with SRVQRY attributes active
SQL4023 - Parallel table prefetch used
SQL4024 - Parallel index preload access method used
SQL4025 - Parallel table preload access method used
SQL4026 - Index only access used on table number &1
SQL4027 - Access plan was saved with DB2 UDB Symmetric Multiprocessing installed on the system
SQL4028 - The query contains a distributed table
SQL4029 - Hashing algorithm used to process the grouping
SQL4030 - &1 tasks specified for parallel scan on table &2.
SQL4031 - &1 tasks specified for parallel index create over table &2
SQL4032 - Index &1 used for bitmap processing of table &2
SQL4033 - &1 tasks specified for parallel bitmap create using &2
SQL4034 - Multiple join classes used to process join
SQL4035 - Table &1 used in join class &2
Programming
Database programming
What's new for V5R4
Printable PDF
Database file concepts
DB2 Universal Database for iSeries
Interfaces to DB2 Universal Database for iSeries
Traditional system interface
SQL
iSeries Navigator
IBM Query for iSeries
Database files
How database files are described
Externally and program-described data
Dictionary-described data
Record format description
Access path description
Naming conventions for a database file
Database data protection and monitoring
Database file sizes
Example: Database file sizes
Setting up database files
Creating and describing database files
Creating a library
Setting up source files
Why source files are used
Creating a source file
Creating a source file using the Create Source Physical File (CRTSRCPF) command
Creating a source file with DDS
Creating a source file without DDS
IBM-supplied source files
Source file attributes
Describing database files
Describing database files using DDS
Example: Describing a physical file using DDS
Example: Describing a logical file using DDS
Additional DDS field definition functions
Using existing field descriptions and field reference files to describe a database file
Using a data dictionary for field reference in a database file
Sharing existing record format descriptions in a database file
Record format relationships between physical and logical files
Record format sharing limitation with physical and logical files
Specifying database file and member attributes
Specifying the file name and member name (FILE and MBR) parameters
Specifying the physical file data members (DTAMBRS) parameter
Specifying the source file and source member (SRCFILE and SRCMBR) parameters
Specifying the file type (FILETYPE) parameter
Specifying the maximum number of members (MAXMBRS) parameter
Specifying the preferred storage unit (UNIT) parameter
Specifying the force write ratio (FRCRATIO) parameter
Specifying the force keyed access path (FRCACCPTH) parameter
Specifying the record format level check (LVLCHK) parameter
Specifying the access path maintenance (MAINT) parameter
MAINT parameter comparison
MAINT parameter tips
Specifying the access path recovery (RECOVER) parameter
Specifying the share open data path (SHARE) parameter
Specifying the maximum file and record wait time (WAITFILE and WAITRCD) parameters
Specifying the authority (AUT) parameter
Specifying the system (SYSTEM) parameter
Specifying the text description (TEXT) parameter
Specifying the coded character set identifier (CCSID) parameter
Specifying the sort sequence (SRTSEQ) parameter
Specifying the language identifier (LANGID) parameter
Setting up physical files
Creating a physical file
Specifying physical file and member attributes
Expiration date
Size of a physical file member
Storage allocation
Method of allocating storage
Record length
Deleted records
Physical file capabilities
Source type
Implicit physical file journaling
Setting up logical files
Creating a logical file
Creating a logical file with more than one record format
Controlling how records are retrieved in a logical file with multiple formats
Controlling how records are added to a logical file with multiple formats
Defining logical file members
Describing logical file record formats
Describing field use for logical files
Describing field use for logical files: Both
Describing field use for logical files: Input only
Describing field use for logical files: Neither
Deriving new fields from existing fields
Concatenated fields
Substring fields
Renamed fields
Translated fields
Describing floating-point fields in logical files
Describing access paths for logical files
Selecting and omitting records for logical files
Access path select/omit
Dynamic select/omit
Selecting and omitting logical file records using the Open Query File (OPNQRYF) command
Sharing existing access paths between logical files
Example: Implicitly shared access paths
Setting up a join logical file
Example 1: Basic concepts of joining two physical files
Reading a join logical file
Case 1: Matching records in primary and secondary files
Case 2A: A record missing in the secondary file (JDFTVAL keyword not specified)
Case 2B: A record missing in the secondary file (JDFTVAL keyword specified)
Case 3: Secondary file has more than one match for a record in the primary file
Case 4: An extra record in the secondary file
Case 5: Random access
Setting up a join logical file
Example 2: Using more than one field to join files
Example 3: Reading duplicate records in the secondary file
Example 4: Using join fields whose attributes are different
Example 5: Describing fields that never appear in the record format
Example 6: Specifying key fields in a join logical file
Specifying select/omit statements in a join logical file
Example 7: Joining three or more physical files
Example 8: Joining a physical file to itself
Example 9: Using defaults for missing records from secondary files
Example 10: A complex join logical file
Join logical file considerations
Performance considerations
Data integrity considerations
Summary of rules
Requirements
Join fields
Fields in join logical files
Miscellaneous rules
Describing access paths for database files
Using arrival sequence access paths for database files
Using keyed sequence access paths for database files
Arranging key fields in an alternative collating sequence
Arranging key fields with the SRTSEQ parameter
Arranging key fields in ascending or descending sequence
Using more than one key field
Preventing duplicate key values
Arranging duplicate keys
Using existing access path specifications
Using floating-point fields in database file access paths
Securing database files
Granting file and data authority
Authorizing a user or group using iSeries Navigator
Types of object authority
Types of data authority
Specifying public authority
Defining public authority using iSeries Navigator
Setting a default public authority using iSeries Navigator
Using database file capabilities to control I/O operations
Limiting access to specific fields in a database file
Using logical files to secure data
Processing database files
Database file processing: Runtime considerations
File and member name
File processing options
Specifying the type of processing
Specifying the initial file position
Reusing deleted records
Ignoring the keyed sequence access path
Delaying end-of-file processing
Specifying the record length
Ignoring record formats
Determining whether duplicate keys exist
Data recovery and integrity
Protecting your files with journaling and commitment control
Writing data and access paths to auxiliary storage
Checking changes to the record format description
Checking the expiration date of a physical file member
Preventing the job from changing data in a file
Locking shared data
Locking records
Locking files
Locking members
Locking record format data
Database lock considerations
Displaying locked rows using iSeries Navigator
Displaying locked records using the Display Record Locks (DSPRCDLCK) command
Sharing database files in the same job or activation group
Open considerations for files shared in a job or an activation group
Input/output considerations for files shared in a job or an activation group
Close considerations for files shared in a job or an activation group
Example 1: A single set of files with similar processing options
Example 2: Multiple sets of files with similar processing options
Example 3: A single set of files with different processing options
Sequential-only processing of database files
Open considerations for sequential-only processing
Input/output considerations for sequential-only processing
Close considerations for sequential-only processing
Summary of runtime considerations for processing database files
Storage pool paging option effect on database performance
Opening a database file
Opening a database file member
Using Open Database File (OPNDBF) command
Using Open Query File (OPNQRYF) command
Creating a query with the Open Query File (OPNQRYF) command
Using an existing record format in the file
Using a file with a different record format
CL program coding with the Open Query File (OPNQRYF) command
The zero-length literal and the contains (*CT) function
Usage notes for the Open Query File (OPNQRYF) examples
Selecting records without using DDS
Selecting records using the Open Query File (OPNQRYF) command
Example 1: Selecting records using the Open Query File (OPNQRYF) command
Example 2: Selecting records using the Open Query File (OPNQRYF) command
Example 3: Selecting records using the Open Query File (OPNQRYF) command
Example 4: Selecting records using the Open Query File (OPNQRYF) command
Example 5: Selecting records using the Open Query File (OPNQRYF) command
Example 6: Selecting records using the Open Query File (OPNQRYF) command
Example 7: Selecting records using the Open Query File (OPNQRYF) command
Example 8: Selecting records using the Open Query File (OPNQRYF) command
Example 9: Selecting records using the Open Query File (OPNQRYF) command
Example 10: Selecting records using the Open Query File (OPNQRYF) command
Example 11: Selecting records using the Open Query File (OPNQRYF) command
Specifying a keyed sequence access path without using DDS
Example 1: Specifying a keyed sequence access path without using DDS
Example 2: Specifying a keyed sequence access path without using DDS
Example 3: Specifying a keyed sequence access path without using DDS
Example 4: Specifying a keyed sequence access path without using DDS
Specifying key fields from different files
Dynamically joining database files without DDS
Example 1: Dynamically joining database files without DDS
Example 2: Dynamically joining database files without DDS
Example 3: Dynamically joining database files without DDS
Handling missing records in secondary join files
Unique-key processing
Example 1: Unique-key processing
Example 2: Unique-key processing
Defining fields derived from existing field definitions
Example 1: Defining fields derived from existing field definitions
Example 2: Defining fields derived from existing field definitions
Example 3: Defining fields derived from existing field definitions
Handling divide-by-zero errors
Summarizing data from database file records (grouping)
Example: Summarizing data from database file records (grouping)
Final total-only processing
Example 1: Final total-only processing
Example 2: Final total-only processing
Example 3: Final total-only processing
Controlling how the system runs the Open Query File (OPNQRYF) command
Example 1: Controlling how the system runs the Open Query File (OPNQRYF) command
Example 2: Controlling how the system runs the Open Query File command
Considerations for using the FORMAT parameter
Considerations for arranging records
Considerations for DDM files
Considerations for writing a high-level language program
Messages sent when the Open Query File (OPNQRYF) command is run
Using the Open Query File (OPNQRYF) command for more than just input
Comparing date, time, and timestamp using the Open Query File (OPNQRYF) command
Performing date, time, and timestamp arithmetic using the Open Query File (OPNQRYF) command
Durations
Rules for date, time, and timestamp arithmetic
Subtracting dates
Incrementing and decrementing dates
Subtracting times
Incrementing and decrementing times
Subtracting timestamps
Incrementing and decrementing timestamps
Using the Open Query File (OPNQRYF) command for random processing
Open Query File (OPNQRYF) command: Performance considerations
Open Query File (OPNQRYF) command: Performance considerations for sort sequence tables
Grouping, joining, and selection: Open Query File (OPNQRYF) command performance
Ordering: Open Query File (OPNQRYF) command performance
Performance comparisons with other database functions
Field use
Files shared in a job
Checking if the record format description changed
Other runtime considerations for the Open Query File (OPNQRYF) command
Overrides and the Open Query File (OPNQRYF) command
Copying from an open query file
Example 1: Copying from an open query file
Example 2: Copying from an open query file
Example 3: Copying from an open query file
Example 4: Copying from an open query file
Typical errors when using the Open Query File (OPNQRYF) command
Open data path considerations
Field names
Expressions
Built-in functions
Restricted built-in functions
Basic database file operations in programs
Setting a position in the file
Reading database records
Reading database records using an arrival sequence access path
Reading next operation
Reading previous operation
Reading first operation
Reading last operation
Reading same operation
Reading by relative record number operation
Reading database records using a keyed sequence access path
Reading next operation
Reading previous operation
Reading first operation
Reading last operation
Reading same operation
Reading by key operation
Reading by relative record number operation
Reading when logical file shares an access path with more keys operation
Waiting for more records when end of file is reached
Releasing locked records
Updating database records
Adding database records
Identifying which record format to add in a file with multiple formats
Using the force-end-of-data operation
Deleting database records
Closing a database file
Monitoring database file errors in a program
System handling of error messages
Effect of error messages on file positioning
Determining which messages you want to monitor
Managing database files
Basic operations for managing database files
Copying a file
Moving a file
Managing database members
Member operations common to all database files
Adding members
Changing member attributes
Renaming members
Removing members
Physical file member operations
Initializing data in a physical file member
Clearing data from a physical file member
Reorganizing a physical file member
Reorganizing a table using iSeries Navigator
Reorganizing a physical file member using the Reorganize Physical File Member (RGZPFM) command
Example: Reorganizing a physical file member
Usage notes: Reorganizing a physical file member
Reorganization options
Suspending or canceling a reorganize operation
Displaying records in a physical file member
Using database attribute and cross-reference information
Displaying information about database files
Displaying attributes of a file using iSeries Navigator
Displaying attributes of a file using the Display File Description (DSPFD) command
Displaying the description of the fields in a file
Displaying the relationships between files on the system
Displaying the files used by programs
Displaying the system cross-reference files
Writing the output from a command directly to a database file
Example: A command output file
Output files for the Display File Description (DSPFD) command
Output files for the Display Journal (DSPJRN) command
Output files for the Display Problems (DSPPRB) command
Changing database file descriptions and attributes
Effects of changing fields in a file description
Changing a physical file description and attributes
Example 1: Changing a physical file description and attributes
Example 2: Changing a physical file description and attributes
Changing a logical file description and attributes
Recovering and restoring your database
Recovering data in a database file
Managing journals
Journals
Working with journals
Creating a journal using iSeries Navigator
Creating a journal receiver using iSeries Navigator
Values for new journals and journal receivers
Adding a remote journal using iSeries Navigator
Removing a remote journal using iSeries Navigator
Activating a remote journal using iSeries Navigator
Deactivating a remote journal using iSeries Navigator
Displaying journal information for a table using iSeries Navigator
Swapping journal receivers using iSeries Navigator
Starting or stopping a journal for a table (file) using iSeries Navigator
Ensuring data integrity with commitment control
Transactions
Benefits of using commitment control
Usage notes: Commitment control
Reducing time in access path recovery
Saving access paths
Restoring access paths
Journaling access paths
System-managed access-path protection
Rebuilding access paths
Controlling when access paths are rebuilt
Designing files to reduce access path rebuilding time
Other methods to avoid rebuilding access paths
Database recovery process after an abnormal system end
Database file recovery during the IPL
Database file recovery after the IPL
Effects of the storage pool paging option on database recovery
Database file recovery options table
Database save and restore
Database considerations for save and restore
Using source files
Working with source files
Using the source entry utility
Using device source files
Copying source file data
Copying to and from source files using the Copy Source File (CPYSRCF) command
Copying to and from source files using the Copy File (CPYF) command
Source sequence numbers used in copies
Loading and unloading data from systems other than System i
Using source files in a program
Creating an object using a source file
Creating an object from source statements in a batch job
Determining which source file member was used to create an object
Managing a source file
Changing source file attributes
Reorganizing source file member data
Determining when a source statement was changed
Using source files for documentation
Controlling the integrity of your database with constraints
Setting up constraints for your database
Removing unique, primary key, or check constraints
Working with a group of constraints
Details: Working with a group of constraints
Working with constraints that are in check pending status
Displaying records that put a constraint in check pending status
Processing constraints that are in check pending status
Unique constraints
Primary key constraints
Check constraints
Ensuring data integrity with referential constraints
Adding referential constraints
Before you add referential constraints
Defining the parent file in a referential constraint
Defining the dependent file in a referential constraint
Specifying referential constraint rules
Details: Specifying referential constraint delete rules
Details: Specifying referential constraint update rules
Details: Specifying referential constraint rules—journaling requirements
Details: Adding referential constraints
Details: Avoiding constraint cycles
Verifying referential constraints
Enabling or disabling referential constraints
Removing referential constraints
Details: Removing a constraint with the CST parameter
Details: Removing a constraint with the TYPE parameter
Details: Ensuring data integrity with referential constraints
Example: Ensuring data integrity with referential constraints
Referential integrity terms
Referential integrity enforcement
Foreign key enforcement
Parent key enforcement
Enforcement of delete rules
Enforcement of update rules
Constraint states
Check pending status in referential constraints
Dependent file restrictions in check pending
Parent file restrictions in check pending
Referential integrity and CL commands
Triggering automatic events in your database
Uses for triggers
Benefits of using triggers in your business
Creating trigger programs
Adding triggers using iSeries Navigator
How trigger programs work
Other important information about working with trigger programs
Recommendations for trigger programs
Precautions to take when coding trigger programs
Functions to use with care in trigger programs
Commands, statements, and operations that you cannot use in trigger programs
Monitoring the use of trigger programs
Trigger and application programs that are under commitment control
Trigger and application programs that are not under commitment control
Trigger program error messages
Examples: Trigger programs
Example: Insert trigger written in RPG/400
Example: Update trigger written in ILE COBOL
Example: Delete trigger written in ILE C
Data structures for the example database files
Trigger buffer sections
Trigger buffer field descriptions
Adding triggers
Displaying triggers
Removing triggers
Enabling or disabling physical file triggers
Triggers and their relationship to CL commands
Triggers and their relationship to referential integrity
Database distribution
Double-byte character set considerations
DBCS field data types
DBCS field mapping considerations
DBCS field concatenation
DBCS field substring operations
Comparing DBCS fields in a logical file
Using DBCS fields in the Open Query File (OPNQRYF) command
Using the wildcard function with DBCS fields
Comparing DBCS fields through the Open Query File (OPNQRYF) command
Using concatenation with DBCS fields
Using sort sequence with DBCS fields
Related information
Distributed database programming
What's new for V5R4
Printable PDF
Introduction to distributed database programming
Distributed relational database processing
Remote unit of work
Distributed unit of work
Other distributed relational database terms and concepts
Distributed Relational Database Architecture support
DRDA and CDRA support
Application requester driver programs
Distributed relational database on i5/OS
Managing an i5/OS distributed relational database
Example: Spiffy Corporation distributed relational database
Spiffy organization and system profile
Business processes of the Spiffy Corporation Automobile Service
Distributed relational database administration for the Spiffy Corporation
Planning and design
Identifying your needs and expectations for a distributed relational database
Data needs for distributed relational databases
Distributed relational database capabilities
Goals and directions for a distributed relational database
Designing the application, network, and data for a distributed relational database
Tips: Designing distributed relational database applications
Network considerations for a distributed relational database
Data considerations for a distributed relational database
Developing a management strategy for a distributed relational database
General operations for a distributed relational database
Security considerations for a distributed relational database
Accounting for a distributed relational database
Problem analysis for a distributed relational database
Backup and recovery for a distributed relational database
Initial setup
i5/OS work management
Setting up your work management environment for DRDA
APPC subsystems
TCP/IP subsystems
User databases on independent auxiliary storage pools
Using the relational database directory
Working with the relational database directory
Adding an entry for SNA usage
Adding an entry for TCP/IP usage
Specifying a relational database alias name
Adding an entry for an application requester driver
Using the WRKRDBDIRE command
The *LOCAL directory entry
Directory entries for user databases on independent auxiliary storage pools
Example: Setting up a relational database directory
Setting up DRDA security
Setting up the TCP/IP server for DRDA
Setting up SQL packages for interactive SQL
Setting up DDM files
Loading data into tables in a distributed relational database
Loading new data into the tables of a distributed relational database
Loading data into a table using SQL
Manipulating data in tables and files using the i5/OS query management function
Entering data, update tables, and make inquiries using data file utility
Moving data from one system to another
Creating a user-written application program
Querying a database using interactive SQL
Querying remote systems using DB2 UDB for iSeries query management function
Copying files to and from tape
Moving data between systems using copy file commands
Transferring data over network using network file commands
Moving a table using object save and restore commands
Moving a database to i5/OS from a system other than i5/OS
Moving data from another IBM system
Moving data from a non-IBM system
Security
Elements of distributed relational database security
Elements of security in an APPC network
APPN configuration lists
Conversation level security
DRDA application server security in an APPC network
Elements of security in a TCP/IP network
Application requester security in a TCP/IP network
Application server security in a TCP/IP network
Connection security protocols for DDM and DRDA
Secure Sockets Layer for DDM and DRDA
Required programs
i5/OS requirements
Internet Protocol Security Architecture for DDM and DRDA
Considerations for certain passwords being sent as clear text
Ports and port restrictions for DDM and DRDA
DRDA server access control exit programs
Example: DRDA server access control exit program
Object-related security for DRDA
Authority to distributed relational database objects
Programs that run under adopted authority for a distributed relational database
Protection strategies in a distributed relational database
Application development
Programming considerations for a distributed relational database application
Naming of distributed relational database objects
System (*SYS) naming convention
SQL (*SQL) naming convention
Default collection name
Connecting to a distributed relational database
Remote unit of work
Activation group states
Connectable and connected state
Unconnectable and connected state
Connectable and unconnected state
Distributed unit of work
Activation group states