IBM i 6.1 Information Center
  About i5/OS information
    Overview and what's new
    PDF files and manuals
    Information FAQ
    Information updates
    Site map
    Memo to users
    Notices
      Hardware topics
      Software topics
    Accessibility features for System i
  Availability
    Availability roadmap
      What's new for V6R1
      PDF file for Availability roadmap
      Availability concepts
      Estimating the value of availability
      Deciding what level of availability you need
      Preventing unplanned outages
        Preparing for disk failures
        Preparing for power loss
        Using effective systems management practices
        Preparing the space for your system
      Shortening unplanned outages
        Reducing the time to restart your system
        Recovering recent changes after an unplanned outage
        Recovering lost data after an unplanned outage
        Reducing the time to vary on independent disk pools
      Shortening planned outages
        Shortening backup windows
          Performing online backups
          Backup from a second copy
          Backing up less data
        Shortening software maintenance and upgrading windows
        Shortening hardware maintenance and upgrade windows
      High availability
      Related information for Availability roadmap
    Single-system availability
    High availability
      High availability overview
        What's new for V6R1
        PDF file for High availability overview
        Benefits of high availability
          Planned outages
          Unplanned outages
          Disaster recovery
          Backup window reduction
          Load balancing
        Components of high availability
          Application resilience
          Data resilience
          Environment resilience
          Simplicity
        High availability criteria
          Budget
          Uptime requirements
          Outage coverage
          Recovery time objective (RTO)
          Recovery point objective (RPO)
          Resilience requirements
          Automated failover and switchover
          Distance requirements
          Number of backup systems
          Access to a secondary copy of the data
          System performance
          Data resilience method comparison
        Choosing a System i high availability solution
          Levels of application resiliency
          Comparison of data resiliency technologies
            Logical replication characteristics
            Switched disk characteristics
            Geographic mirroring characteristics
            Metro mirror characteristics
            Global mirror characteristics
          High availability management
            IBM System i High Availability Solutions Manager
              High Availability Solutions Manager graphical interface
              Cluster Resource Services graphical interface
              IBM System i High Availability Solutions Manager commands
              IBM System i High Availability Solutions Manager (iHASM) APIs
            Option 41 (HA Switchable Resources)
            High availability function in the base operating system
            Cluster middleware IBM Business Partners and available clustering products
        Related information for High availability overview
      High availability technologies
        What's new for V6R1
        PDF file for High availability technologies
        i5/OS Clusters technology
          Cluster concepts
            Cluster node
            Cluster resource group (CRG)
              Application CRG
              Data CRG
              Device CRG
              Peer CRG
              Recovery domain
              Cluster resource group exit programs
            Cluster version
            Device domain
            Cluster jobs
          Base cluster functions
            Heartbeat monitoring
            Reliable message function
          Cluster events
            Switchover
            Failover
              Cluster message queue
              Failover message queue
            Cluster partition
            Merge
              Example: Merge
            Rejoin
              Example: Rejoin
        Cluster administrative domain
        Switched disks
        Switchable devices
        Cross-site mirroring
          Geographic mirroring
          Metro mirror
          Global mirror
        FlashCopy
        High availability management
          IBM System i High Availability Solutions Manager
            High Availability Solutions Manager graphical interface
            Cluster Resource Services graphical interface
            IBM System i High Availability Solutions Manager commands
            IBM System i High Availability Solutions Manager (iHASM) APIs
          Option 41 (HA Switchable Resources)
          High availability function in the base operating system
          Cluster middleware IBM Business Partners and available clustering products
        Related information for High availability technologies
      Implementing high availability
        What's new for V6R1
        PDF file for Implementing high availability
        Installing IBM System i High Availability Solutions Manager (iHASM) licensed program
        Uninstalling IBM System i High Availability Solutions Manager (iHASM) licensed program
        Implementing high availability with the solution-based approach
          Selecting a high availability solution
            Overview: Switched disk between logical partitions
            Overview: Switched disk between systems
            Overview: Switched disk with geographic mirroring
            Overview: Cross-site mirroring with geographic mirroring
          Verifying requirements for your high availability solution
          Setting up a high availability solution
            Placing high availability systems in dedicated state
            Changing backup procedures for a high-availability solution
            Verifying applications after each setup step
          Managing a high availability solution
            Working with high availability status messages
            Working with high availability solution tasks
              Shutting down a high availability solution with data available
              Shutting down a high availability solution with data unavailable
              Resuming a high availability solution
              Performing switchovers
              Recovering from partition state
              Collecting service information
            Managing high availability resources
              Managing nodes
                Starting nodes
                Stopping nodes
                Working with all nodes
                Displaying node properties
              Managing cluster resource groups (CRG)
                Starting a CRG
                Stopping a CRG
                Deleting a CRG
                Working with all CRGs
                Displaying CRG properties
              Managing monitored resources
                Working with all monitored resources
                Displaying monitored resource properties
              Managing independent disk pools
                Starting mirroring
                Stopping mirroring
                Working with all independent disk pools
                Displaying independent disk pool properties
              Managing TCP/IP interfaces
                Starting TCP/IP interfaces
                Stopping TCP/IP interfaces
                Working with all TCP/IP interfaces
                Displaying properties for TCP/IP interfaces
              Managing policies
            Working with high availability event log
          Working with messages
          Reference: Panel help for the solution-based interface
            High Availability Solutions Manager welcome
            Select your high availability solution
            Customized shopping list
            Executive summary
            Save or print high availability solution information
            Verify requirements list
            Set up your high availability solution
            Display high availability log
            Set up high availability policies
            Set up high availability environment
            Verify administrative switchover
            Migrate user profiles
            Migrate libraries
            Migrate directories
            Finish set up and clean up files
            Manage your high availability solution - Nodes
            Manage high availability solution - Cluster Resource Groups
            Manage high-availability solution - Monitored resources
            Manage high-availability solution - Independent disk pools
            Manage high-availability solution - TCP/IP interfaces
            Manage high availability solution - Policies
            Collect service information
            Verify administrative switchover
            Recover from partition state
            Shut down high availability solution - keep data available
            Shut down high availability solution - make data not available
            Resume high availability solution
            No help is available
        Implementing high availability with a task-based approach
          Planning your high availability solution
            Cluster applications
              Identifying resilient applications
              i5/OS architecture for cluster-enabled applications
              Writing a highly available cluster application
                Making application programs resilient
                Restarting highly available cluster applications
                Calling a cluster resource group exit program
              Application CRG considerations
                Managing application CRG takeover of IP addresses
                  Enabling application switchover across subnets
                Example: Application cluster resource group failover actions
                Example: Application exit program
            Planning data resiliency
              Determine which data should be made resilient
              Planning switched disks
                Hardware requirements for switched disks
                Software requirements for switched disks
                Communications requirements for switched disks
              Planning cross-site mirroring
                Planning geographic mirroring
                  Hardware requirements for geographic mirroring
                  Software requirements for geographic mirroring
                  Communications requirements for geographic mirroring
                  Journal planning for geographic mirroring
                  Backup planning for geographic mirroring
                  Performance planning for geographic mirroring
                Planning metro mirror
                  Hardware requirements for metro mirror
                  Software requirements for metro mirror
                  Communications requirement for metro mirror
                  Journal planning for metro mirror
                  Backup planning for metro mirror
                  Performance planning for metro mirror
                Planning global mirror
                  Hardware requirements for global mirror
                  Software requirements for global mirror
                  Communications requirement for global mirror
                  Journal planning for global mirror
                  Backup planning for global mirror
                  Performance planning for global mirror
              Planning for logical replication
                Determine which systems to use for logical replication
                Cluster middleware IBM Business Partners and available clustering products
                Journal planning for logical replication
                Backup planning for logical replication
                Performance planning for logical replication
            Planning environment resiliency
              Planning for a cluster administrative domain
              Planning monitored resources entries (MRE)
            Planning clusters
              Hardware requirements for clusters
              Software requirements for clusters
              Communications requirements for clusters
                Dedicate a network for clusters
                Tips: Cluster communications
                Performance planning for clusters
                  Tunable cluster communications parameters
                  Changing cluster resource services settings
                Planning multiple-release clusters
              Performance planning for clusters
              Planning checklist for clusters
            Planning the FlashCopy feature
              Hardware requirements for the FlashCopy feature
              Software requirements for the FlashCopy feature
              Communications requirements for the FlashCopy feature
            Security planning for high availability
              Distributing cluster-wide information
              Considerations for using clusters with firewalls
              Maintaining user profiles on all nodes
          Configuring high availability
            Scenarios: Configuring high availability
              Scenario: Switched disk between logical partitions
              Scenario: Switched disk between systems
              Scenario: Switched disk with geographic mirroring
              Scenario: Cross-site mirroring with geographic mirroring
              Scenario: Cross-site mirroring with metro mirror
              Scenario: Cross-site mirroring with global mirror
            Setting up TCP/IP for high availability
              Setting TCP/IP configuration attributes
              Starting the INETD server
            Configuring clusters
              Creating a cluster
                Enabling nodes to be added to a cluster
                Adding nodes
                Starting nodes
                Adding a node to a device domain
                Creating cluster resource groups (CRGs)
                  Creating application CRGs
                  Creating data CRGs
                  Creating device CRGs
                  Creating peer CRGs
                Starting a CRG
              Specifying message queues
              Performing switchovers
              Configuring nodes
                Starting nodes
                Enabling nodes to be added to a cluster
                Adding nodes
                Adding a node to a device domain
              Configuring CRGs
                Starting a CRG
                Creating cluster resource groups (CRGs)
                  Creating application CRGs
                  Creating data CRGs
                  Creating device CRGs
                  Creating peer CRGs
              Configuring cluster administrative domains
                Creating a cluster administrative domain
                Adding a node to the cluster administrative domain
                Starting a cluster administrative domain
                Synchronization of monitored resource
                Adding monitored resource entries
            Configuring switched disks
              Creating an independent disk pool
              Starting mirrored protection
              Stopping mirrored protection
              Adding a disk unit or disk pool
              Evaluating the current configuration
              Making a disk pool available
            Configuring cross-site mirroring
              Configuring geographic mirroring
              Configuring metro mirror session
              Configuring global mirror session
          Managing high availability
            Scenarios: Managing high availability solutions
              Scenarios: Performing backups in a high-availability environment
                Scenario: Performing backups in geographic mirroring environment
                Scenario: Performing a FlashCopy function
              Scenario: Upgrading operating system in an high-availability environment
                Example: Upgrading operating system
              Scenario: Making a device highly available
            Managing clusters
              Adjusting the cluster version of a cluster
              Deleting a cluster
              Displaying cluster configuration
              Saving and restoring cluster configuration
              Monitoring cluster status
              Specifying message queues
              Cluster deconfiguration checklist
              Managing nodes
                Displaying node properties
                Stopping nodes
                Removing nodes
                Removing a node from a device domain
              Managing cluster resource groups (CRGs)
                Displaying CRG status
                Stopping a CRG
                Deleting a CRG
                Creating switchable devices
                Changing the recovery domain for a CRG
                  Creating site names and data port IP addresses
              Managing failover outage events
              Managing cluster administrative domains
                Stopping a cluster administrative domain
                Deleting a cluster administrative domain
                Changing the properties of a cluster administrative domain
                Managing monitored resource entries
                  Working with monitored resource entry status
                  Removing monitored resource entries
                  Listing monitored resource types
                  Listing monitored resource entries
                  Selecting attributes to monitor
                    Attributes that can be monitored
                  Displaying monitored resource entry messages
            Managing switched disks
              Making a disk pool unavailable
              Making your hardware switchable
              Quiescing an independent disk pool
              Resuming an independent disk pool
            Managing cross-site mirroring
              Managing geographic mirroring
                Suspending geographic mirroring
                Resuming geographic mirroring
                Detaching mirror copy
                Reattaching mirror copy
                Deconfiguring geographic mirroring
                Changing geographic mirroring properties
              Managing metro mirror sessions
                Suspending metro mirror sessions
                Resuming metro mirror sessions
                Deleting metro mirror session
                Displaying metro mirror properties
              Managing global mirror
                Suspending global mirror sessions
                Resuming global mirror sessions
                Deleting global mirror sessions
                Changing global mirror session properties
            Managing the FlashCopy technology
              Configuring a FlashCopy session
              Updating a FlashCopy session
              Reattaching a FlashCopy session
              Detaching a FlashCopy session
              Deleting a FlashCopy session
              Restoring data from a FlashCopy session
              Changing FlashCopy properties
          Troubleshooting your high availability solution
            Troubleshooting clusters
              Determine if a cluster problem exists
              Gathering recovery information for a cluster
              Common cluster problems
              Partition errors
                Determining primary and secondary cluster partitions
                Changing partitioned nodes to failed
                Partitioned cluster administrative domains
                Tips: Cluster partitions
              Cluster recovery
                Recovering from cluster job failures
                Recovering a damaged cluster object
                Recovering a cluster after a complete system loss
                Recovering a cluster after a disaster
                Restoring a cluster from backup tapes
            Troubleshooting cross-site mirroring
              Geographic mirroring messages
        Related information for Implementing high availability
    Maximum capacities
      What's new for V6R1
      PDF file for Maximum capacities
      Cluster limits
      Communications limits
      Database and SQL limits
      File system limits
      Journal limits
      Save and restore limits
      Security limits
      Work management limits
      Miscellaneous limits
      Related information for Maximum capacities
  Basic system operations
    What's new for V6R1
    PDF file for Basic system operations
    Overview of basic system operations
      Using system interfaces
      Working with devices
      Working with printer output
        Managing printer output
        Starting printers
        Starting a printer from System i Navigator
      Working with storage
      Working with the control panel
        Control panel concepts
          Types of control panels
            Physical control panel
            Remote control panel
            Virtual control panel
          Control panel functions
          Control panel buttons, lights, and indicators
        Setting up your control panel
        Accessing control panel functions
        Instructions and descriptions for control panel functions
          Normal control panel functions
          Extended control panel functions
          Low-level debug panel functions 57 through 70
        Using remote control panel APIs
          System power and test APIs
            Turning on the system
            Performing panel lamp test
            Clearing panel lamp test
            Powering off the system
          IPL-related APIs
            Setting IPL mode to Manual
            Setting IPL mode to Normal
            Setting IPL mode to Auto
            Setting IPL mode to Secure
            Setting IPL type to A
            Setting IPL type to B
            Setting IPL type to C
            Setting IPL type to D
            Starting an IPL
            Setting IPL speed to Fast
            Setting IPL speed to Slow
            Setting IPL speed to system default
          Other system function APIs
            Starting dedicated service tools on the primary or alternate console
            Starting a main storage dump
            Disabling continuously powered main storage
          APIs that check the system status
            Is CPM present?
            Is CPM enabled?
            Is the key inserted?
            Is the system turned on?
            Is the attention light lit?
            Is SPCN present?
            Getting the IPL mode
            Getting the IPL type
            Getting the IPL speed
            Getting type and model information
            Getting the SPCN system reference code
            Getting all system reference codes 1 - 9
    Starting and stopping the system
      Starting the system
        Starting the system without making configuration changes (unattended IPL)
        Changing the system during IPL (attended IPL)
          Attended IPL displays
            Setting major system options
            Defining or changing the system at IPL
            Editing access paths during attended IPL
            Editing check pending constraints during attended IPL
        Changing your system IPL from the control panel
          IPL type
          Operating mode of an IPL
          Changing operating modes and IPL types
          Changing system values during IPL
        Changing the IPL startup program
          Source for CL startup program
          Startup program to set the (QSTRUPPGM) system value
        Scheduling a system shutdown and restart
          Displaying the power-on and power-off schedule
          Changing power-on and power-off schedule defaults
          Changing the power-on and power-off schedule for a single event
          Solving problems with the automatic power schedule
        Causes of abnormal IPLs
      Signing on to the system
        Signing on to the system using System i Navigator
        Signing on to the system using the character-based interface
        Changing your password
          Changing the system password
          Bypassing the system password
      Stopping the system
        Turning off the system immediately
        Using the Power button
      System values that control IPL
    i5/OS concepts
      Messages
      i5/OS commands
      Security and user authority
        Authority to access objects
        Security levels
        User profiles
        Authorization lists
      Files and file systems
      i5/OS restricted state
      Jobs
      Subsystems, job queues, and memory pools
      Objects
      Logs and journals
      Software fixes
    Printing the system configuration list
    Analyzing and reporting system problems
    Related information for basic system operations
  Connecting to System i
    Choose your connection
      Connecting to System i: Web clients
      Connecting to System i: Windows clients
      Connecting to System i: Linux clients
      Connecting to System i: Wireless clients
      Connecting to System i: Interfaces
      Connecting to System i: Consoles
    System i Access
      System i Access for Web
        What's new for V6R1
        PDF file for System i Access for Web
        License information
        Planning
          System i Access for Web offerings
            Web application
            Portal application (Standard)
            Portal application (IBM)
          Security considerations
            Single sign-on considerations
          Checklist: Planning, installing, and configuring
          Prerequisites for installing System i Access for Web
            Hardware requirements
              Tune performance
            i5/OS software requirements
              PTF requirements
            Web browser requirements
              Browser considerations
            Upgrade considerations
        Installing System i Access for Web
        Installing System i Access for Web PTFs
        System i Access for Web in a Web application server environment
          Configuring System i Access for Web
            Examples for configuring a new Web application server environment
              WebSphere Application Server V6.1 for i5/OS
              WebSphere Application Server V6.1 for i5/OS with Single sign-on
              WebSphere Application Server - Express V6.1 for i5/OS
              WebSphere Application Server Network Deployment 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
            Examples for configuring an existing Web application server environment
              i5/OS integrated Web application server
              WebSphere Application Server V6.1 for i5/OS
              WebSphere Application Server - Express V6.1 for i5/OS
              WebSphere Application Server Network Deployment V6.1 for i5/OS
              WebSphere Application Server V6.0 for OS/400
              WebSphere Application Server Network Deployment V6.0 for OS/400
            New Web application server considerations
          Customizing System i 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
          System i Access for Web functions
            5250
            Command
            Customize
            Database
              Database considerations
              Database restrictions
            Download
            File
              File considerations
              File restrictions
            Jobs
            Mail
            Messages
            My folder
            My home page
            Other
            Print
              Print considerations
              Print restrictions
          URL interfaces
          Automating tasks
          NLS considerations
          Saving and restoring System i Access for Web
        System i Access for Web in a portal environment
          Portal application (Standard)
            Portal concepts
              Cross-site scripting
            Configuring System i Access for Web
            Customizing System i Access for Web
              Creating pages
              Customizing portlets
              Portal roles
            System i Access for Web functions
              5250
              Command
              Database
                Database considerations
                Database restrictions
              Files
                File considerations
                File restrictions
              Other
              Print
            NLS considerations
            Saving and restoring System i Access for Web
          Portal application (IBM)
            Portal concepts
              Cooperative portlets
              Cross-site scripting
            Configuring System i Access for Web
              Examples for configuring a new portal environment
                IBM WebSphere Portal V6.0
                IBM WebSphere Portal V5.1
              Examples for configuring an existing portal environment
                IBM WebSphere Portal V6.0
                IBM WebSphere Portal V5.1
            Customizing System i Access for Web
              Creating pages
              Customizing portlets
              Portal roles
            System i Access for Web functions
              5250
              Command
              Database
                Database considerations
                Database restrictions
              Files
                File considerations
                File restrictions
              IFrame
              Other
              Print
            NLS considerations
            Saving and restoring System i Access for Web in a portal environment
        Deleting System i Access for Web
        Removing System i Access for Web from an unsupported environment
        Related information
      System i Access for Windows
        Introduction
          Installation and setup
            What's new for V6R1
            PDF file for System i Access for Windows: Installation and setup
            License information
            Setting up the System i platform
              Prerequisites to install System i Access for Windows on i5/OS
                i5/OS release requirements
                i5/OS storage requirements
                Required and optional programs to install
              Installing System i Access for Windows on the i5/OS operating system
              Obtaining and installing PTFs
              Configuring TCP/IP on the System i platform
              Configuring i5/OS NetServer on i5/OS
              Removing System i 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
                Verifying the TCP/IP configuration
              Configuring the PC for i5/OS NetServer
              Installation considerations
              SSL considerations
              Preparing an installation image to install on multiple PCs
                Deploying from i5/OS NetServer
                Administrative installation image
                  Creating an administrative installation image
                  Patching an administrative installation image
                Deploying from a network drive
                Using batch programs
                Using remote scheduled tasks
                Active Directory
                  Deploying on Active Directory using Group Policy
                  Setting Windows Installer policies on Active Directory
                Deploying using SMS
                Finding the installation image to be tailored
                Methods to tailor an installation package
                  Tools available for creating transforms
                  Creating transforms with Orca
                    Restricting the set of features that users can install
                      Feature Tree
                    Setting public properties using transforms
                  Changing the default options for the log files
                  Public properties
                  Defining the level of user interface throughout the installation
                  Modifying the installation by using setup.ini
                Telling your users how to install
                Windows Installer Policies
                  Using Windows Installer policies
              Installing System i Access for Windows on the PC
                Finding your installation image
                  Using Licensed Program 5761-XE1 as the installation source
                  Using the System i Access for Windows DVD as the installation source
                    Creating a DVD
                  Using an installation image that has been prepared to install on multiple PCs as the installation source
                Using command line parameters to change the installation behavior
              Preparing to install service packs on multiple PCs
                Obtaining and installing PTFs
                  Check Service Level function
                    Setting Check Service Level properties
                    Scheduling Check Service Level
                    Controlling service pack and release upgrades
                Service packs from download sites
                  Site for downloading service packs
                  Patching an administrative installation image
                  Distributing service packs on Active Directory
                  Distributing service packs on SMS
                    Reinstalling clients from an updated full image
                    Distributing a patch to clients
                  Making individual patches available to your users
              Installing service packs on the PC
                Install a service pack using Check Service Level
                Installing a service pack from an updated full installation image
                Installing a service pack by applying a patch
              Integrating System i Navigator plug-ins
              Installing or removing individual features
              Installing other language versions
              Upgrading System i Access for Windows
              Uninstalling System i Access for Windows from the PC
              Troubleshooting
            Related information
          Using
        Administration
          What's new for V6R1
          Printable PDF
          System i Access for Windows network environments
            Microsoft Windows Terminal Server
            Use System i Access for Windows in a three-tier environment
              Using distributed transaction support
              Access System i 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 System i Access ODBC driver
            Set up your system for the System i Access ODBC driver
              Adding the local system to the RDB directory
              Specify the ODBC data source
              Use independent ASPs through ODBC
            System i 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)
              System i Access ODBC error messages
              Troubleshoot the System i 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 for i5/OS 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
              System i Subsystems
                Subsystems used for server Jobs
                Use of autostart jobs
                Use of prestart jobs
              System i system values
              Identify and display System i server jobs
                Use System i Navigator to identify server jobs
                Use the System i character-based interface to display server job
                  System i job names
                  Display using WRKACTJOB
                  Display using the history log
                  Display server job for a user
            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
                Examples: Create QIBM_QZDA_INIT exit programs with CL commands
                Examples: Create QIBM_QZDA_INIT exit programs with ILE C
          System i NetServer administration
          Restrict users with policies and application administration
            Overview of System i Access for Windows policies
            Set up your system to use policies
              Configure a system for using System i Access for Windows policies
              Configure client PCs for policies
              Create policy files
                Microsoft System Policy Editor
                Create System i Access for Windows policy templates
                Create and update policy files
            System i 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 System i file creation
                    Data Transfer policy: Prevent host file creation
                      Data Transfer policy: Prevent Wizard System i file creation
                      Data Transfer policy: Prevent non-Wizard System i 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
                Installation policy: Prevent check service pack level
                Policies by function: License management
                  License policy: Time to delay before releasing System i 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: System i Navigator
                  System i Navigator policy: Prevent usage of System i Navigator
                Policies by function: Passwords
                  Password policy: Warn user before System i password expires
                  Password policy: Prevent System i 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: System i Access for Windows Runtime Restrictions
                Config.adm: System i Access for Windows mandated connections
                Installation policy: Prevent check service pack level
                SYSNAME.adm: Per-system policies
          Secure Sockets Layer (SSL) administration
          Code license and disclaimer information
        Programming
          What's new for V6R1
          Printable PDFs
          System i Access for Windows C/C++ APIs
            System i 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
              System i name formats for connection APIs
              OEM, ANSI, and Unicode considerations
                Use a single System i Access for Windows API type
                Use mixed System i Access for Windows API types
                Write a generic System i Access for Windows application
              Obsolete System i 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
                System i Access for Windows return codes that correspond to operating system errors
                System i Access for Windows return codes
                  Global System i Access for Windows return codes
                  System i 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
                System i 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
                  System 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
            System i Access for Windows Administration APIs
              Administration APIs list
                cwbAD_GetClientVersion
                cwbAD_GetProductFixLevel
                cwbAD_IsComponentInstalled
                cwbAD_IsOpNavPluginInstalled
              Example: Administration APIs
            System i 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 System i Access for Windows communications APIs
            System i 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
            System i Access for Windows Data Transformation and National Language Support (NLS) APIs
              System i Access for Windows data transformation APIs
                System i 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
              System i Access for Windows National Language Support (NLS) APIs
                Coded character sets
                System i Access for Windows general NLS APIs list
                  cwbNL_FindFirstLang
                  cwbNL_FindNextLang
                  cwbNL_GetLang
                  cwbNL_GetLangName
                  cwbNL_GetLangPath
                  cwbNL_SaveLang
                System i 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
                System i 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: System i Access for Windows NLS APIs
            System i Access for Windows Directory Update APIs
              Typical use of System i 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
            System i Access for Windows PC5250 emulation APIs
            System Objects APIs for System i Access for Windows
              System 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 System i Access for Windows
                cwbOBJ_CloseList
                cwbOBJ_CreateListHandle
                cwbOBJ_DeleteListHandle
                cwbOBJ_GetListSize
                cwbOBJ_OpenList
                cwbOBJ_ResetListAttrsToRetrieve
                cwbOBJ_ResetListFilter
                cwbOBJ_SetListAttrsToRetrieve
                cwbOBJ_SetListFilter
                cwbOBJ_SetListFilterWithSplF
              System i Access for Windows Object APIs
                cwbOBJ_CopyObjHandle
                cwbOBJ_DeleteObjHandle
                cwbOBJ_GetObjAttr
                cwbOBJ_GetObjAttrs
                cwbOBJ_GetObjHandle
                cwbOBJ_GetObjHandleFromID
                cwbOBJ_GetObjID
                cwbOBJ_RefreshObj
                cwbOBJ_SetObjAttrs
              System i Access for Windows Parameter object APIs
                cwbOBJ_CopyParmObjHandle
                cwbOBJ_CreateParmObjHandle
                cwbOBJ_DeleteParmObjHandle
                cwbOBJ_GetParameter
                cwbOBJ_SetParameter
              System i Access for Windows Writer job APIs
                cwbOBJ_EndWriter
                cwbOBJ_StartWriter
              System i Access for Windows output queues APIs
                cwbOBJ_HoldOutputQueue
                cwbOBJ_PurgeOutputQueue
                cwbOBJ_ReleaseOutputQueue
              System i Access for Windows AFP resource APIs
                cwbOBJ_CloseResource
                cwbOBJ_CreateResourceHandle
                cwbOBJ_DisplayResource
                cwbOBJ_OpenResource
                cwbOBJ_OpenResourceForSplF
                cwbOBJ_ReadResource
                cwbOBJ_SeekResource
              System i Access for Windows APIs for new spooled files
                cwbOBJ_CloseNewSplF
                cwbOBJ_CloseNewSplFAndGetHandle
                cwbOBJ_CreateNewSplF
                cwbOBJ_GetSplFHandleFromNewSplF
                cwbOBJ_WriteNewSplF
              APIs for reading spooled files for System i Access for Windows
                cwbOBJ_CloseSplF
                cwbOBJ_OpenSplF
                cwbOBJ_ReadSplF
                cwbOBJ_SeekSplF
              APIs for manipulating spooled files for System i 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 System i Access for Windows
                cwbOBJ_AnswerSplFMsg
                cwbOBJ_GetSplFMsgAttr
              APIs for analyzing spooled file data for System i Access for Windows
                cwbOBJ_AnalyzeSplFData
              Server program APIs for System i Access for Windows
                cwbOBJ_DropConnections
                cwbOBJ_GetNPServerAttr
                cwbOBJ_SetConnectionsToKeep
              Example: Using system objects APIs for System i Access for Windows
            System i Access for Windows Remote Command/Distributed Program Call APIs
              Typical use of System i Access for Windows Remote Command/Distributed Program Call APIs
              Remote Command/Distributed Program Call: Access remote command APIs list for System i Access for Windows
                cwbRC_GetClientCCSID
                cwbRC_GetHostCCSID
                cwbRC_StartSysEx
                cwbRC_StopSys
              Remote Command/Distributed Program Call: Run APIs list for System i Access for Windows
                cwbRC_RunCmd
              Remote Command/Distributed Program Call: Access programs APIs list for System i 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 System i Access for Windows Command/Distributed Program Call APIs
            System i 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 System i Access for Windows Serviceability APIs
            System i Access for Windows System Object Access (SOA) APIs
              SOA objects
              System object views
              Typical use of System Object Access APIs for System i Access for Windows
                Displaying a customized list of system objects
                  Sample program: Displaying a customized list of system objects
                Displaying the Properties view for a system object
                  Sample program: Displaying the Properties view of an object
                Accessing and updating data for system objects
                  Sample program: Accessing and updating data for system objects
              System i Access for Windows System Object Access programming considerations
                About System Object Access errors
                System Object Access application profiles
                Managing System i communications sessions for application programs
              System Object Access APIs for System i 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
          System i Access for Windows: Database programming
            System i Access for Windows .NET provider
            System i Access for Windows OLE DB provider
            System i 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
                  SQLPrepare
                  SQLBindParameter
                  SQLExecute
                  SQLParamData and SQLPutData
                  Convert strings and arrays of byte
                  Performance architecture of the System i Access for Windows ODBC driver
                ODBC API return codes
                End ODBC functions
              Implementation issues of ODBC APIs
                ODBC 3.x API notes
                  SQL Statement Considerations
                Connection string keywords
                  Connection string keywords - General properties
                  Connection string keywords - Server properties
                  Connection string keywords - Data types
                  Connection string keywords - Package properties
                  Connection string keywords - Performance properties
                  Connection string keywords - Language properties
                  Connection string keywords - Catalog properties
                  Connection string keywords - Conversion 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 for i5/OS 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 System i Access for Windows ODBC Driver
                SQLTables Description
                Handle long-running queries
                Commitment control considerations
              System i Access for Windows ODBC performance
                Performance-tuning System i Access for Windows ODBC
                  Introduction to server performance
                  Introduction to client/server performance
                  Performance architecture of the System i 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 a System i stored procedure by using Visual Basic
                    Example: Call CL command stored procedures
                    Tips: Run and call System i 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
            IBM Toolbox for Java JDBC Driver
            System i Access database APIs
          Java programming
            IBM Toolbox for Java
          ActiveX programming
        Operations Console
          What's new for V6R1
          PDF file for Operations Console
          Planning considerations for Operations Console
            Planning considerations for your configuration
              Console planning considerations
                Planning considerations for your backup console
              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
              Preparation for your network environment
              Security of your Operations Console configuration
              Preparation for your Operations Console and System i Navigator configuration
              Scenarios: Selecting your configuration
                Scenario: A single console directly attached to the system without remote support
                Scenario: Consoles for multiple systems or partitions
            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 system
                Completing prerequisite checklist for Windows 2000: Local console directly attached to the system
                Completing prerequisite checklist for Windows XP: Local console directly attached to the system
              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
                Completing prerequisite checklist for Windows Vista: Local console on a network
            Completing required prerequisite tasks
              Installing System i Access for Windows
                Applying System i 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 an Operations Console cable
              Configuring Operations Console on the PC
                Configuring a local console on a network (LAN)
                  Connecting a local console on a network to a system
                Configuring a local console directly attached to the system
                  Connecting a local console directly attached to the system
                  Activating the asynchronous communications line on the system
                  Deactivating the asynchronous communications line on the system
            Creating a customized setup checklist for Operations Console
          Managing Operations Console
            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
            Managing your console configuration
              Connecting a local console to a system
                Connecting to another system
              Changing a console configuration
              Deleting a console configuration
              Changing the value of the autocreate device ID option
              Using the Properties page
              Customizing the Operations Console window
            Management of multiple consoles
              Multiple local PC consoles on a network
              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
            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 nonpartitioned 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 nonpartitioned 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 nonpartitioned 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 nonpartitioned 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
              Operations Console simplification
              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
              Using the console service functions (65+21)
              Using the OPSCONSOLE macro
              Unlocking service tools device IDs in SST
              Changing the mode of the emulator between 3179 and 3477
          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 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
            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 A6005082
              System reference code A9002000
              System reference code D1008065
              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
              The user cannot perform the option selected
          Related information for Operations Console
      System i Access for Wireless
        System i Navigator for Wireless
          What's new for V6R1
          PDF file for System i Navigator for Wireless
          Setting up System i 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 firewall
              Configuring Management Central
              Selecting a language
            Connecting to your central system
            Customizing your connection
          Starting and stopping System i Navigator for Wireless
          Managing your systems with System i Navigator for Wireless
            Working with System i models
            Working with integrated 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 System i Navigator for Wireless
        IBM Toolbox for Java 2 Micro Edition
      System i Access for Linux
        What's new
        Printable PDFs
        IBM System i Access for Linux license information
        Prerequisites for using the System i Access for Linux product
        Install System i Access for Linux
        Update the System i Access for Linux product
        Uninstall the System i Access for Linux product
        System i Access for Linux security
        System i Access for Linux 5250 emulation
          Prerequisites for using 5250 emulation
          Configure 5250 emulation
            Command line emulator options
            X resources for the System i 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 Ideographic (DBCS) configuration
              IBM 5250 DBCS settings, values, and fonts
              X Input Method (XIM) and Input Method Editors (IME) and encodings
              Use alternate X Input Method (XIME) with System i Access for Linux
              Example: Change X Input Method (XIME) for the Japanese language version
              Troubleshooting the X Input Method (XIME)
            Emulator resources
          Troubleshoot 5250 emulation
            5250 problem isolation
            Font problems
          System i Access for Linux 5250 emulation FAQs
        System i 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 the System i Access for Linux product
          Configure an ODBC data source
            Use GUI to configure an ODBC data source
            Manually configure an ODBC data source
            Connection string keywords and values
              Diagnostic properties
              Format properties
              General properties
              Other properties
              Package properties
              Performance properties
              Server properties
              Sort properties
              Translation properties
              Unsupported connection string keywords and values
          ODBC examples
          Troubleshoot an System i Access for Linux ODBC
            ODBC problem isolation
            Error messages
          ODBC FAQs
        System i 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 System i Access for Linux
          RMTCMD - Run a System i batch/CL command
          RMTODBC - Run a System i batch/CL command using the ODBC driver
    System i Navigator
      Getting to know System i Navigator
        What's new for V6R1
        PDF file for Getting to know System i Navigator
        System i Navigator functions by release
        Requirements for installing System i Navigator
        Installing System i Navigator
        Adding system connections to System i Navigator
        Working with System i Navigator
        Related information for System i Navigator
      System i Navigator for Wireless
        What's new for V6R1
        PDF file for System i Navigator for Wireless
        Setting up System i 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 firewall
            Configuring Management Central
            Selecting a language
          Connecting to your central system
          Customizing your connection
        Starting and stopping System i Navigator for Wireless
        Managing your systems with System i Navigator for Wireless
          Working with System i models
          Working with integrated 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 System i Navigator for Wireless
      System i Navigator tasks on the Web
        What's new for V6R1
        PDF file for System i Navigator tasks on the Web
        Setting up System i Navigator tasks on the Web
          Prerequisites for setting up System i Navigator tasks on the Web
          Configuring security for System i Navigator tasks on the Web
            Configuring Web browser connections to System i Navigator tasks on the Web
            Configuring data-retrieval connections to the local system and managed secondary systems
          Configuring Application Administration
        Working with System i Navigator tasks on the Web
        System i Navigator tasks on the Web reference information
          System i Navigator URL parameters and available Web tasks
          Working with System i Navigator lists on the Web
      IBM Systems Director Navigator for i5/OS
        What's new for V6R1
        PDF file for IBM Systems Director Navigator for i5/OS
        Working with IBM Systems Director Navigator for i5/OS
        Related information for IBM Systems Director Navigator for i5/OS
      Application Administration
        What's new for V6R1
        PDF file for Application Administration
        Application Administration concepts
          Application registration
            Application registration on Local Settings
            Application registration on Central Settings
          System i 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 V6R1
        PDF files for Management Central
        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
          Troubleshooting Management Central connections
        Working with Management Central monitors
          Management collection objects
          Job monitors and Collection Services
            The QYRMJOBSEL job
            QZRCSRVS jobs and their affect 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
          Resetting triggered threshold for a 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
          Working with systems with partitions
          Running commands with Management Central
          Packaging and sending objects with Management Central
          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
              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
                  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 System i Navigator plug-ins
        What's new for V6R1
        PDF file for Developing System i Navigator plug-ins
        Plug-in support in System i 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 program section of setup.ini
            MRI setup file
          Identifying plug-ins to System i 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
            System i Navigator structure and flow of control for C++ plug-ins
            System i 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
            System i Navigator APIs
              System i 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 System i Navigator APIs
          Visual Basic reference
            System i Navigator structure and flow of control for Visual Basic plug-ins
            System i Navigator Visual Basic interfaces
              System i Navigator ListManager interface class
              System i Navigator ActionsManager interface class
              System i Navigator DropTargetManager interface class
          Java reference
            System i 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
  Database
    PDF files for Database
    Database overview
      What's new for V6R1
      PDF file for Database overview
      DB2 for i5/OS
      Terminology: SQL versus traditional file access
      Getting started with System i Navigator
        Starting System i Navigator
        Creating a schema
        Editing the list of schemas displayed
        Creating and using a table
          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
      System i 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 System i5 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
      What's new for V6R1
      PDF file for Database administration
      Database administration
        Accessing data through client interfaces
          Accessing data with Java
          Accessing data with Domino
          Accessing data with ODBC
          Accessing data with i5/OS PASE
          Accessing data with System i Access for Windows OLE DB Provider
          Accessing data with Net.Data
          Accessing data through a Linux partition
          Accessing data using Distributed Relational Database Architecture (DRDA)
        Altering and managing database objects
        Creating database objects
        Ensuring data integrity
        Importing and exporting data between systems
        Working with multiple databases
        Working with triggers and constraints
        Writing DB2 programs
      Database backup and recovery
      Distributed database administration
      Queries and reports
        BINARY, VARBINARY, HEX, and LENGTH functions for Query
      Security
    Commitment control
      What's new for V6R1
      PDF file for Commitment control
      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
    Database performance and query optimization
      What's new for V6R1
      PDF file for Database performance and query optimization
      Query engine overview
        SQE and CQE engines
        Query dispatcher
        Statistics manager
        Plan cache
      Data access on DB2 for i5/OS: 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 distinct sorted list
            Sorted list scan
          Temporary list
            List scan
          Temporary values list
            Values 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
          Full outer join
          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
          Grouping set optimization
        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
        Displaying information with database health center
        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 System i Navigator with detailed monitors
          Starting a detailed monitor
          Analyzing 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
          Condensing advised index
        View the implementation of your queries with Visual Explain
          Starting Visual Explain
          Overview of information available from Visual Explain
        Optimizing performance using the Plan Cache
          SQL plan cache - show statements
          SQL plan cache columns
          SQL plan cache properties
          SQL plan cache snapshot
          SQL plan cache event monitor
          Accessing the SQL plan cache with SQL stored procedures
        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 System i Navigator with summary monitors
          Starting a summary monitor
          Analyzing summary monitor information
          Importing a monitor
        Verifying the performance of SQL applications
        Examining query optimizer debug messages in the job log
        Gathering information about embedded SQL statements
        Query optimization tools: Comparison table
        Changing the attributes of your queries
          Controlling queries dynamically with the query options file QAQQINI
            Specifying the QAQQINI file
            Creating the QAQQINI query options file
            QAQQINI file override support
            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
          Setting 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
          Controlling 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
        Displaying materialized query table columns
        Managing check pending constraints columns
      Creating an index strategy
        Binary radix indexes
          Derived key index
          Specifying PAGESIZE on index creates
          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
          Displaying indexes for a table
          Determining unnecessary indexes
          Resetting usage counts
          Managing index rebuilds
        Indexing strategy
          Reactive approach to tuning
          Proactive approach to tuning
        Coding for effective indexes
          Avoiding numeric conversions
          Avoiding arithmetic expressions
          Avoiding character string padding
          Avoiding the use of like patterns beginning with % or _
          Using derived indexes
        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
        Using live data
        Reducing the number of open operations
        Retaining 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 for i5/OS 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
        Query optimization performance information messages and open data paths
        PRTSQLINF message reference
    Programming
      Database programming
        What's new for V6R1
        PDF file for Database programming
        Database file concepts
          DB2 for i5/OS
          Interfaces to DB2 for i5/OS
            Traditional system interface
            SQL
            System i Navigator
            IBM Query for i5/OS
          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: 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
              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
              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
          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 binary floating-point fields in database file access paths
          Securing database files
            Granting file and data authority
              Authorizing a user or group using System i Navigator
              Types of object authority
              Types of data authority
            Specifying public authority
              Defining public authority using System i Navigator
              Setting a default public authority using System i 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 System i 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 queries
                Creating an open query file using an existing record format
                Creating an open query file using a different record format
              Dynamically selecting records
                Example 1: Dynamically selecting records
                Example 2: Dynamically selecting records
                Example 3: Dynamically selecting records
                Example 4: Dynamically selecting records
                Example 5: Dynamically selecting records
                Example 6: Dynamically selecting records
                Example 7: Dynamically selecting records
                Example 8: Dynamically selecting records
                Example 9: Dynamically selecting records
                Example 10: Dynamically selecting records
                Example 11: Dynamically selecting records
              Arranging records
                Specifying dynamic keyed sequence access paths
                  Example 1: Specifying dynamic keyed sequence access paths
                  Example 2: Specifying dynamic keyed sequence access paths
                  Example 3: Specifying dynamic keyed sequence access paths
                  Example 4: Specifying dynamic keyed sequence access paths
                Specifying key fields from different physical files
                Unique-key processing
                  Example 1: Unique-key processing
                  Example 2: Unique-key processing
                Random processing
                Considerations for arranging records
              Formatting records
                Defining fields mapped from existing fields
                  Example 1: Defining fields mapped from existing fields
                  Example 2: Defining fields mapped from existing fields
                  Example 3: Defining fields mapped from existing fields
                Considerations for specifying record formats
              Grouping records
                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
                Grouping field references
              Joining records
                Dynamically joining database files
                  Example 1: Dynamically joining database files
                  Example 2: Dynamically joining database files
                  Example 3: Dynamically joining database files
                Handling missing records in secondary join files
              Optimizing performance
                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 (OPNQRYF) command
                Runtime messages for the Open Query File (OPNQRYF) command
                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
              Handling errors
                Typical errors when using the Open Query File (OPNQRYF) command
                Handling divide-by-zero errors
              Usage notes for the Open Query File (OPNQRYF) command
                Command elements
                  Field names
                  Expressions
                  Built-in functions
                  Restricted built-in functions
                Data type considerations
                  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
                  BLOB, CLOB, and DBCLOB considerations
                  DATALINK considerations
                DDM file considerations
                Input and output considerations
                  Using the Open Query File (OPNQRYF) command for more than just input
                  Field usage attribute
                Open data path considerations
                  Files shared in a job
                  Checking if the record format description changed
                  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
                Override considerations
                Program considerations
                  Considerations for writing a high-level language program
                  CL program coding with the Open Query File (OPNQRYF) command
          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