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