IBM i 7.1 Information Center
  About IBM i information
    Overview and what's new
    PDF files and manuals
    Information FAQ
    Information updates
    Site map
    Memo to users
    Notices
    Accessibility features for this product
  Availability
    Availability roadmap
      What's new for IBM i 7.1
      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 IBM i 7.1
        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 IBM i high availability solution
          Levels of application resiliency
          Comparison of data resiliency technologies
            Logical replication characteristics
            Switched disk characteristics
            Switched logical unit characteristics
            Geographic mirroring characteristics
            Metro Mirror characteristics
            Global Mirror characteristics
          High availability management
            IBM PowerHA for i interfaces
              High Availability Solutions Manager graphical interface
              Cluster Resource Services graphical interface
              IBM PowerHA for i commands
              IBM PowerHA for i APIs
            Option 41 (HA Switchable Resources)
            Advanced node failure detection
            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 IBM i 7.1
        PDF file for High availability technologies
        IBM i Cluster 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
        Advanced node failure detection
        Cluster administrative domain
        Switched disks
        Switched logical units
        Switchable devices
        Cross-site mirroring
          Geographic mirroring
          Metro mirror
          Global mirror
        FlashCopy
        High availability management
          IBM PowerHA for i interfaces
            High Availability Solutions Manager graphical interface
            Cluster Resource Services graphical interface
            IBM PowerHA for i commands
            IBM PowerHA for i APIs
          IBM PowerHA for iversion support
          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
        Resource Monitoring and Control (RMC)
      Implementing high availability
        What's new for IBM i 7.1
        PDF file for Implementing high availability
        Installing IBM PowerHA for i licensed program
        Uninstalling IBM PowerHA for i 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 with IPv4
                  Enabling application switchover across subnets with IPv6
                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 switched logical units (LUNs)
              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 advanced node failure detection
                Hardware requirements for the advanced node failure detection
                Software requirements for the advanced node failure detection
              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 advanced node failure detection
              Configuring hardware management console (HMC)
              Configuring virtual I/O server (VIOS)
            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 switched logical units (LUNs)
          Configuring cross-site mirroring
            Configuring geographic mirroring
            Configuring metro mirror session
            Configuring global mirror session
            Configuring switched logical units (LUNs)
        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 a high-availability environment
              Example: Upgrading operating system
            Scenario: Making a device highly available
          Managing clusters
            Adjusting the PowerHA version
            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
            Add a cluster monitor to a node
            Removing a cluster monitor
            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 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 or changing Metro Mirror properties
            Managing global mirror
              Suspending global mirror sessions
              Resuming Global Mirror sessions
              Deleting global mirror sessions
              Changing Global Mirror session properties
            Managing switched logical units (LUNs)
              Making switched logical units (LUNs) available and unavailable
              Quiescing an independent disk pool
              Resuming an independent disk pool
          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
          Installing IBM PowerHA for i licensed program
      Related information for Implementing high availability
    Maximum capacities
      What's new for IBM i 7.1
      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
    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
  Blade and System x
    What's new for IBM i 7.1
    PDF file
    Concepts for integrated servers
      Overview
      Capabilities
      Attaching servers to IBM i using iSCSI
        Typical server installation
        Single-server environment
        Multiple-server environment
        Initiator system and service processor connection
        Booting over the iSCSI network
      Server management
        Integrated Windows servers
        Integrated VMware ESX servers
        Integrated server console
        Software updates
      Storage management
        Virtual storage
        IBM i storage management
        Predefined virtual storage
        Virtual storage linking
      Shared tape and optical devices
        Tested IBM i tape devices
      Networking
        Service processor connection
        Service processor functions and support
        Service processor connection methods
        iSCSI network
        Integrated DHCP server
        Networking between IBM i and integrated servers
        Virtual Ethernet networks
        Physical networks
        Network security
      Performance concepts
        Storage performance
        Virtual Ethernet performance
        MTU considerations
      IBM i configuration objects
      High availability concepts
        Multipath I/O
        Hot spare support
        IBM i clustering
      User and group enrollment concepts
        Enrolled user account options
        User enrollment templates
        Password considerations
        QAS400NT user
      IBM i NetServer
      IBM i Access for Windows
    Installation road map
      Prerequisites
        Documentation for installing
        IBM i software requirements
        Installing IBM i licensed programs
      Preparing for the hardware installation
        BladeCenter hardware requirements
        System x hardware requirements
        Downloading updates and drivers
          Updates for BladeCenter
          Updates for blade
          Updates for System x
          Updates for iSCSI initiator
          Windows Ethernet NIC driver
          Windows Server 2008 iSCSI HBA driver
        Obtaining the operating system
      iSCSI Network Planning Guide
        Planning guide overview
        Configuration objects
        Recording the configuration information
          Planning network addresses
          Planning for the service processor connection
            Identifying the service processor type
            Selecting a connection method
            Recording the system serial number
            Selecting a name
            Selecting a login ID
            Considerations for multiple connections to a BladeCenter AMM
          Planning for the remote system configuration
            Recording the blade serial number
            Selecting a name
            Selecting a boot parameter delivery method
            Selecting CHAP settings
            Selecting the MTU for the iSCSI network
            Recording iSCSI initiator MAC addresses
            Selecting IP addresses for the iSCSI initiator
            Selecting the initiator IQN
            Selecting the target IQN
          Planning for the NWSH object
            Selecting a name
            Selecting a hardware resource name
            Selecting a connection type
            Selecting IP addresses for the iSCSI target
            Selecting LIND values
          Planning for the connection security configuration
          Planning for the integrated server installation
            Selecting the operating system
            Choosing the system drive capacity
            Selecting a memory pool
            Selecting a name
            Selecting a language version
            Selecting IBM i devices to restrict
            Selecting point-to-point virtual Ethernet IP addresses
            Selecting additional INSWNTSVR parameters
          Planning for post-installation tasks
            Planning for the ESX management connection
        Advanced planning topics
          Expanding on the iSCSI network addressing scheme
          Considerations for connecting service processors to IBM i
        Planning work sheets
          IBM i service processor configuration work sheet
          BladeCenter or System x service processor work sheet
          IBM i remote system configuration work sheet
          iSCSI initiator work sheet
          IBM i network server host adapter work sheet
          IBM i TCP/IP interface work sheet
          IBM i line description work sheet
          Integrated server installation work sheet
          VMware ESX post-installation work sheet
      Installing the hardware
        Installing the iSCSI target
        Installing the server hardware and iSCSI initiators
          Updating and configuring the BladeCenter chassis
            Updating the BladeCenter management module firmware
            Configuring the management module
            Updating and configuring the BladeCenter I/O module
          Updating and configuring the blade
            Updating the blade server UEFI firmware
            Updating the blade server BIOS firmware
            Updating the blade server IMM firmware
            Updating the blade server BMC firmware
            Verifying blade information
            Updating iSCSI initiator firmware
            Setting the blade start options
          Updating and configuring the System x
            Updating the System x UEFI firmware
            Updating the System x BIOS firmware
            Updating firmware and configuring System x IMM
              (Optional) Updating IMM network configuration to defaults
              Updating IMM firmware
              Configuring the IMM
            Updating firmware and configuring System x BMC
              Updating System x BMC firmware
              Configuring the BMC
            Updating firmware and configuring System x RSA II
              (Optional) Updating RSA II network configuration to defaults
              Updating RSA II firmware
              Configuring the RSA II
            Updating iSCSI initiator firmware
            Setting the System x start options
          Configuring the iSCSI initiator
          Cabling the iSCSI network
      Preparing IBM i for the installation
        Creating an NWSH
        Starting the NWSH
        Creating a service processor configuration
        Creating a remote system configuration
        Verifying the remote system is powered off
        Creating a connection security configuration for INSWNTSVR
        Preparing for IBM i memory requirements
        Configuring QRETSVRSEC system value
        Configuring IBM i TCP/IP for Windows Server 2003
      Installing the integrated server
        Starting the installation from IBM i
        Continuing the operating system installation
          Windows Server 2008
          Windows Server 2003
          VMware ESX
        Completing the integrated server installation
          Windows Server 2008
            Full installation
            Core installation
          Windows Server 2003
          VMware ESX or ESXi
    Managing integrated server environments
      Managing integrated servers
        Starting and stopping integrated servers
          Starting integrated servers
          Starting an integrated server when IBM i TCP/IP starts
          Stopping integrated servers
          Shutting down your IBM i system when integrated servers are present
        Viewing or changing configuration information
        Configuring service processor connection
          Configuring service processor connection using IP address for integrated servers
          Configuring service processor connection using host name for integrated servers
          Configuring the service processor with the Web interface
        Configuring security between IBM i and integrated servers
          Configuring CHAP for integrated servers
          Changing a service processor password
          Configuring a firewall
        Configuring multipath I/O
          Configuring IBM i for multipath I/O
          Configuring Windows for multipath I/O
            Windows Server 2008
            Windows Server 2003
          Configuring VMware ESX for multipath I/O
        Using hot spare hardware
          Using hot spare integrated server hardware
          Using hot spare iSCSI hardware target adapters
          Using hot spare iSCSI software target adapters
        Configuring high availability
          Configuring an integrated server as an IBM i switchable device
        Viewing integrated server messages
        Launching the Web console
      Managing integrated Windows servers
        Updating the integration software
          Integrated Windows server console
          Web GUI
          Remote command
        Managing virtual Ethernet and external networks
          Displaying information about virtual Ethernet adapters
          Configuring IP address, gateway, and MTU
            Configuring virtual Ethernet for applications that support frame sizes larger that 1500 bytes
            Configuring virtual Ethernet for iSCSI networks that have a maximum frame size that is less than 1500 bytes
            Configuring virtual Ethernet to support non-TCP applications that do not negotiate MTU
          Configuring virtual Ethernet networks between integrated Windows servers
          Configuring inter-partition virtual Ethernet networks
          Managing point-to-point virtual Ethernet networks
        Sharing tape and optical devices with Windows servers
          Using IBM i tape devices
            Installing tape device drivers
            Formatting an IBM i tape
            Transferring a tape device to Windows
            Transferring a tape device to IBM i
            Identifying IBM i tape devices to Windows applications
          Using IBM i optical devices
          Transferring IBM i devices between Windows servers
          Restricting IBM i tape and optical devices
        Printing to IBM i printers
        Running Windows commands remotely
          Guidelines for running remote Windows commands
            SBMNWSCMD and file level backup support for Kerberos V5 and EIM
        Configuring time synchronization
        Enabling QNTC access to Windows Server 2003
      Managing integrated VMware ESX servers
        Updating the integration software
        Configuring the QVMWINT user
        Managing connections for ESX servers
          Adding connection information
          Listing connection information
          Verifying connection information
          Changing connection information
          Overriding management of a connection
          Deleting connection information
        Migrating VMware ESX servers
      Managing storage
        Displaying information about virtual storage
        Adding virtual storage
          Creating virtual storage
          Linking virtual storage
          Formatting virtual storage
        Copying virtual storage
        Expanding virtual storage
        Expanding a system disk
        Unlinking virtual storage
        Deleting virtual storage
        Accessing IBM i IFS from an integrated server
      Administering Windows users from IBM i
        Enrolling IBM i users to Windows
        Enrolling IBM i groups to Windows
        Configuring the QAS400NT user
        Creating user enrollment templates
        Specifying a home directory in a user template
        Changing the local password management attribute
        Configuring EIM for integrated Windows servers
        Ending user enrollment
        Ending group enrollment
        Preventing enrollment to a Windows server
      Managing network server host adapters
        Creating a network server host adapter
          Determining the hardware resource name
        Creating an NWSH based on another one
        Displaying network server host adapter properties
        Changing network server host adapter properties
        Starting a network server host adapter
        Stopping a network server host adapter
        Deleting a network server host adapter
          Deleting a TCP/IP interface
          Deleting a line description
      Managing remote system configurations
        Creating a remote system configuration
        Creating a remote system configuration based on another one
        Displaying remote system configuration properties
        Changing remote system configuration properties
        Displaying remote system status
        Deleting a remote system configuration
        Launching the Web console
      Managing service processor configurations
        Creating a service processor configuration
        Creating a service processor configuration based on another one
        Displaying service processor configuration properties
        Changing service processor configuration properties
        Initializing a service processor
        Deleting a service processor configuration
        Launching the Web console
        Converting pre-IBM i 7.1 service processor configurations to use an IP address or host name
      Managing connection security configurations
        Creating a connection security configuration
        Creating a connection security configuration based on another one
        Displaying connection security configuration properties
        Changing connection security configuration properties
        Deleting a connection security configuration
      Managing iSCSI adapters
        Managing iSCSI initiator hardware
          Removing or replacing an iSCSI initiator adapter
            Stopping the integrated server
            Removing the iSCSI initiator
            Replacing an iSCSI initiator
            Configuring the replacement iSCSI initiator
              Updating remote system configuration information
              Configuring the iSCSI initiator
        Managing iSCSI target and initiator usage
          Sharing an iSCSI target
          Distributing iSCSI network traffic
          Managing iSCSI initiator allocation
          Viewing iSCSI initiator allocation
    Backing up and recovering
      Backing up the NWSD and other objects
        What objects to save
        Backing up the NWSD
        Backing up virtual storage
        Backing up virtual storage for active Windows servers
        Backing up NWSH objects
        Backing up NWSCFG objects
      Backing up individual Windows files
        File-level backup restrictions
        Installing and configuring IBM i NetServer
        Configuring Windows for file-level backup
        Creating shares on Windows
        Adding members to the QAZLCSAVL file
        Verifying that NetServer and Windows are in same domain
        Saving integrated Windows server files
          Examples: Saving parts of integrated servers
        Using the Windows Server 2003 Backup utility
      Saving user enrollment information
      Restoring the NWSD and other objects
        Restoring the NWSD and virtual storage
          Restoring virtual storage
          Restoring NWSDs
        Restoring NWSH objects
        Restoring NWSCFG objects
      Restoring individual Windows files
      Restoring user enrollment information
    Uninstalling integrated servers
      Deleting shareable IBM i objects
      Uninstalling IBM i Integrated Server Support
    Related information
  Connecting to your system
    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
    IBM i Access
      IBM i Access for Web
        What's new for IBM i 7.1
        PDF file for IBM i Access for Web
        License information
        Planning
          IBM 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 IBM i Access for Web
            Hardware requirements
              Tune performance
            IBM i software requirements
              PTF requirements
            Web browser requirements
              Browser considerations
            Upgrade considerations
        Installing IBM i Access for Web
        Installing IBM i Access for Web PTFs
        IBM i Access for Web in a Web application server environment
          Configuring IBM i Access for Web
            Examples for configuring a new Web application server environment
              integrated Web application server for i
              WebSphere Application Server V7.0 for IBM i
              WebSphere Application Server V7.0 for IBM i with Single sign-on
              WebSphere Application Server - Express V7.0 for IBM i
              WebSphere Application Server Network Deployment V7.0 for IBM i
              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
            Examples for configuring an existing Web application server environment
              integrated Web application server for i
              WebSphere Application Server V7.0 for IBM i
              WebSphere Application Server - Express V7.0 for IBM i
              WebSphere Application Server Network Deployment V7.0 for IBM i
              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
            New Web application server considerations
          Customizing IBM 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
          IBM 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 IBM i Access for Web
        IBM i Access for Web in a portal environment
          Portal application (Standard)
            Portal concepts
              Cross-site scripting
            Configuring IBM i Access for Web
            Customizing IBM i Access for Web
              Creating pages
              Customizing portlets
              Portal roles
            IBM 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 IBM i Access for Web
              Examples for configuring a new portal environment
                IBM WebSphere Portal V6.1
              Examples for configuring an existing portal environment
                IBM WebSphere Portal V6.1
            Customizing IBM i Access for Web
              Creating pages
              Customizing portlets
              Portal roles
            IBM 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 IBM i Access for Web in a portal environment
        Deleting IBM i Access for Web
        Removing IBM i Access for Web from an unsupported environment
        Related information
      IBM i Access for Windows
        Introduction
          Installation and setup
            What's new for IBM i 7.1
            PDF file for IBM i Access for Windows: Installation and setup
            License information
            Setting up the IBM i platform
              Prerequisites to install IBM i Access for Windows on IBM i
                IBM i release requirements
                IBM i storage requirements
                Required and optional programs to install
              Installing IBM i Access for Windows on the IBM i
              Obtaining and installing PTFs
              Configuring TCP/IP on IBM i platform
              Configuring IBM i NetServer on IBM i
              Removing IBM i Access for Windows from IBM i
            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 IBM i NetServer
              Installation considerations
              SSL considerations
              Preparing an installation image to install on multiple PCs
                Deploying from IBM i NetServer
                Administrative installation image
                  Creating an administrative installation image
                  Patching an administrative installation image
                Deploying from a network drive
                Using command 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 IBM i Access for Windows on the PC
                Finding your installation image
                  Using Licensed Program 5770-XE1 as the installation source
                  Using the IBM 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
              Publishing directory information to LDAP
              Upgrading IBM i Access for Windows
              Uninstalling IBM i Access for Windows from the PC
              Troubleshooting
            Related information
          Using
        Administration
          What's new for IBM i 7.1
          PDF file for IBM i Access for Windows: Administration
          IBM i Access for Windows network environments
            Microsoft Windows Terminal Server
            Use IBM i Access for Windows in a three-tier environment
              Using distributed transaction support
              Access IBM 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 IBM i Access ODBC driver
            Set up your system for the IBM i Access ODBC driver
              Adding the local system to the RDB directory
              Specify the ODBC data source
              Use independent ASPs through ODBC
            IBM 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)
              IBM i Access ODBC error messages
              Troubleshoot the IBM 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 i 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 IBM i host servers and associated programs.
              Host servers by function
              File server
              File server programs
              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 IBM i 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
              IBM i Subsystems
                Subsystems used for server Jobs
                Use of autostart jobs
                Use of prestart jobs
              IBM i system values
              Identify and display IBM i server jobs
                Use System i Navigator to identify server jobs
                Use the IBM i character-based interface to display server job
                  IBM 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
          IBM i NetServer administration
          Restrict users with policies and application administration
            Overview of IBM i Access for Windows policies
            Types and scopes of policies
            Set up your system to use policies
              Configure a system for using IBM i Access for Windows policies
              Configure client PCs for policies
              Create policy files
                Microsoft System Policy Editor
                Create IBM i Access for Windows policy templates
                Create and update policy files
            IBM 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 IBM i file creation
                    Data Transfer policy: Prevent host file creation
                      Data Transfer policy: Prevent Wizard IBM i file creation
                      Data Transfer policy: Prevent non-Wizard IBM 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 IBM 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 IBM i password expires
                  Password policy: Prevent IBM 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: IBM i Access for Windows Runtime Restrictions
                Config.adm: IBM i Access for Windows mandated connections
                Installation policy: Prevent check service pack level
                SYSNAME.adm: Per-system policies
          Secure Sockets Layer (SSL) administration
        Programming
          What's new for IBM i 7.1
          PDF file for IBM i Access for Windows: Programming
          IBM i Access for Windows C/C++ APIs
            IBM 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
              IBM i name formats for connection APIs
              OEM, ANSI, and Unicode considerations
                Use a single IBM i Access for Windows API type
                Use mixed IBM i Access for Windows API types
                Write a generic IBM i Access for Windows application
              Obsolete IBM 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
              Return codes and error messages
                IBM i Access for Windows return codes that correspond to operating system errors
                IBM i Access for Windows return codes
                  Global IBM i Access for Windows return codes
                  IBM 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
                IBM i Access for Windows component-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
            IBM i Access for Windows Administration APIs
              Administration APIs list
                cwbAD_GetClientVersion
                cwbAD_GetProductFixLevel
                cwbAD_IsComponentInstalled
                cwbAD_IsOpNavPluginInstalled
              Example: Administration APIs
            IBM 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_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 IBM i Access for Windows communications APIs
            IBM 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_GetLibName
                cwbDQ_GetQueueAttr
                cwbDQ_GetQueueName
                cwbDQ_GetSysName
                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
            IBM i Access for Windows data transformation and National Language Support (NLS) APIs
              IBM i Access for Windows data transformation APIs
                IBM 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
              IBM i Access for Windows National Language Support (NLS) APIs
                Coded character sets
                IBM i Access for Windows general NLS APIs list
                  cwbNL_FindFirstLang
                  cwbNL_FindNextLang
                  cwbNL_GetLang
                  cwbNL_GetLangName
                  cwbNL_GetLangPath
                  cwbNL_SaveLang
                IBM 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
                IBM 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: IBM i Access for Windows NLS APIs
            IBM i Access for Windows Directory Update APIs
              Typical use of IBM 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
            IBM i Access for Windows PC5250 emulation APIs
            System Objects APIs for IBM 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 IBM i Access for Windows
                cwbOBJ_CloseList
                cwbOBJ_CreateListHandle
                cwbOBJ_DeleteListHandle
                cwbOBJ_GetListSize
                cwbOBJ_OpenList
                cwbOBJ_ResetListAttrsToRetrieve
                cwbOBJ_ResetListFilter
                cwbOBJ_SetListAttrsToRetrieve
                cwbOBJ_SetListFilter
                cwbOBJ_SetListFilterWithSplF
              IBM i Access for Windows Object APIs
                cwbOBJ_CopyObjHandle
                cwbOBJ_DeleteObjHandle
                cwbOBJ_GetObjAttr
                cwbOBJ_GetObjAttrs
                cwbOBJ_GetObjHandle
                cwbOBJ_GetObjHandleFromID
                cwbOBJ_GetObjID
                cwbOBJ_RefreshObj
                cwbOBJ_SetObjAttrs
              IBM i Access for Windows Parameter object APIs
                cwbOBJ_CopyParmObjHandle
                cwbOBJ_CreateParmObjHandle
                cwbOBJ_DeleteParmObjHandle
                cwbOBJ_GetParameter
                cwbOBJ_SetParameter
              IBM i Access for Windows Writer job APIs
                cwbOBJ_EndWriter
                cwbOBJ_StartWriter
              IBM i Access for Windows output queues APIs
                cwbOBJ_HoldOutputQueue
                cwbOBJ_PurgeOutputQueue
                cwbOBJ_ReleaseOutputQueue
              IBM i Access for Windows AFP resource APIs
                cwbOBJ_CloseResource
                cwbOBJ_CreateResourceHandle
                cwbOBJ_DisplayResource
                cwbOBJ_OpenResource
                cwbOBJ_OpenResourceForSplF
                cwbOBJ_ReadResource
                cwbOBJ_SeekResource
              IBM 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 IBM i Access for Windows
                cwbOBJ_CloseSplF
                cwbOBJ_OpenSplF
                cwbOBJ_ReadSplF
                cwbOBJ_SeekSplF
              APIs for manipulating spooled files for IBM 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 IBM i Access for Windows
                cwbOBJ_AnswerSplFMsg
                cwbOBJ_GetSplFMsgAttr
              APIs for analyzing spooled file data for IBM i Access for Windows
                cwbOBJ_AnalyzeSplFData
              Server program APIs for IBM i Access for Windows
                cwbOBJ_DropConnections
                cwbOBJ_GetNPServerAttr
                cwbOBJ_SetConnectionsToKeep
              Example: Using system objects APIs for IBM i Access for Windows
            IBM i Access for Windows Remote Command/Distributed Program Call APIs
              Typical use of IBM i Access for Windows Remote Command/Distributed Program Call APIs
              Remote Command/Distributed Program Call: Access remote command APIs list for IBM i Access for Windows
                cwbRC_GetClientCCSID
                cwbRC_GetHostCCSID
                cwbRC_StartSysEx
                cwbRC_StopSys
              Remote Command/Distributed Program Call: Run APIs list for IBM i Access for Windows
                cwbRC_RunCmd
              Remote Command/Distributed Program Call: Access programs APIs list for IBM 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 IBM i Access for Windows Command/Distributed Program Call APIs
            IBM 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 IBM i Access for Windows Serviceability APIs
            IBM i Access for Windows System Object Access (SOA) APIs
              SOA objects
              System object views
              Typical use of System Object Access APIs for IBM i Access for Windows
                Display a customized list of system objects
                  Sample program: Display a customized list of system objects
                Display the Properties view for a system object
                  Sample program: Display the Properties view of an object
                Access and update data for system objects
                  Sample program: Access and update data for system objects
              IBM i Access for Windows System Object Access programming considerations
                About System Object Access errors
                System Object Access application profiles
                Manage IBM i communications sessions for application programs
              System Object Access APIs for IBM 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
          IBM i Access for Windows: Database programming
            IBM i Access for Windows .NET provider
            IBM i Access for Windows OLE DB provider
            IBM 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
                  Multiple row INSERT and multiple row FETCH examples
                  Example: Multiple row inserts using Visual Basic
                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 IBM 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 i database types
                Working with the XML data type
                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 IBM i Access for Windows ODBC Driver
                SQLTables Description
                Handle long-running queries
                Isolation level considerations
              IBM i Access for Windows ODBC performance
                Performance-tuning IBM i Access for Windows ODBC
                  Introduction to server performance
                  Introduction to client/server performance
                  Performance architecture of the IBM 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 support for multiple row statements
                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
                SQL and External procedures
                  Procedure result sets
                  Examples: Stored procedures
                    Example: Run CL commands that use SQL stored procedures and ODBC
                    Example: Stored procedure calls from Visual Basic with return values
                    Example: Call an IBM i stored procedure by using Visual Basic
                    Example: Call CL command using SQL CALL statement
                    Tips: Run and call IBM i procedures
              ODBC program examples
                Example: Visual C++ - Access and return data by calling a procedure
                Example: Visual Basic - Access and return data by a call to a procedure
                Examples: ILE RPG - Host code for ODBC procedures
            IBM Toolbox for Java JDBC Driver
            IBM i Access database APIs
          Java programming
            IBM Toolbox for Java
          ActiveX programming
        Operations Console
          What's new for IBM i 7.1
          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
              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
              Scenario: Understanding your configuration
                Scenario: Consoles for multiple systems or partitions
            Planning considerations for your control panel
              Remote control panel
          PC preparations for Operations Console
            Completing the setup prerequisite checklist
              Setting up a 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 IBM i Access for Windows
                Applying IBM i Access for Windows service packs
              Configuring Operations Console on the PC
                Configuring a local console on a network (LAN)
                  Connecting a local console on a network to a system
          Managing Operations Console
            Takeover or recovery of an Operations Console connection
              Takeover details
              Recovery details
              Enabling console takeover
              Scenario: Takeover and recovery
                Scenario: LAN connected devices only with takeover enabled
            Managing your console configuration
              Connecting a local console to a system
                Connecting to another system
              Changing a console configuration
                Changing a local console on a network (LAN)
              Deleting a console configuration
              Using the Properties page
              Customizing the Operations Console window
            Management of multiple consoles
              Multiple local PC consoles on a network
            Changing from one console type to another
              Switching from one console type to another when the current console is not operational
              Changing from a twinaxial console to an Operations Console local console on a network (LAN)
                Changing the console from a twinaxial console to an Operations Console local console on a network (LAN) in a nonpartitioned system
                Changing the console from a twinaxial console to an Operations Console local console on a network (LAN) in a logical partition
                Configuring the PC to use the new console type after changing from a twinaxial console to an Operations Console local console on a network (LAN)
              Changing from an Operations Console local console on a network (LAN) to a twinaxial console
                Changing the console from an Operations Console local console on a network (LAN) to a twinaxial console in a nonpartitioned system
                Changing the console from an Operations Console local console on a network (LAN) to a twinaxial console in a logical partition
                Performing optional steps on the PC when changing from an Operations Console local console on a network (LAN) to a twinaxial console
            Managing your local console on a network
              Changing keyboard definitions
              Changing the mode of the emulator between 3179 and 3477
              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
              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 by using a console session with another device
                  Resetting the service tools device ID password by using unused service tools device ID
                  Resetting the QCONSOLE service device ID password by using the control panel or the remote control panel
                Resetting the service tools device ID password on the PC
              Creating service tools device IDs on the system
              Changing the value of the autocreate device ID option
              Changing the RCP privilege on autocreate device IDs
              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
          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
                Network connection errors
                Error message: The connection to the system is not a secure connection
                Local console status remains Connecting
                Unexpected disconnections
            Troubleshooting authentication problems
              Authentication errors
            Troubleshooting emulator problems
            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
              IPL step C6004031 takes longer than expected
            Troubleshooting remote control panel problems
              Remote control panel fails to start
              Unable to use the mode function
              Authentication problems
            Troubleshooting configuration wizard problems
              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 Linux
        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
        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 tasks on the Web
        What's new for IBM i 7.1
        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 i
        What's new for IBM i 7.1
        PDF file for IBM Systems Director Navigator for i
        Working with IBM Systems Director Navigator for i
        Related information for IBM Systems Director Navigator for i
      Application Administration
        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 IBM i 7.1
        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
            What's new for IBM i 7.1
            PDF file for Advanced Job Scheduler
            Advanced Job Scheduler on the Web
              Web URL direct access
              Advanced Job Scheduler properties
                General Properties
                Schedules
                Data libraries
                Setting up systems and groups
                Users
                Calendars
              Scheduled jobs
                Scheduled job list
                Creating a scheduled job
                Scheduled Job Properties
              Job groups
                Job group job list
                Creating a job group
              Notification
              Scheduled job activity
                Scheduled job activity list
                Scheduled job activity properties
              Activity log
                Activity log list
                Activity log properties
              Features not supported
            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
                Setting up systems and groups
                  Adding a new system or system group
                    Communication type
              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 IBM i operating system
                Customizing your connection
                Managing Advanced Job Scheduler for Wireless
              Troubleshooting the Advanced Job Scheduler
        Related information for Management Central
      Intelligent agents
    Operations Console
  Database
    PDF files for Database
    Database overview
      What's new for IBM i 7.1
      PDF file for Database overview
      DB2 for IBM i
      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
          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
        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 IBM i 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 IBM i 7.1
      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 IBM i Access for Windows OLE DB Provider
          Accessing data with IBM i Access for Windows .Net 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
        Authority Options for SQL Analysis and Tuning
    Commitment control
      What's new for IBM i 7.1
      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
        Finding large or old transactions
      Related information
    Performance and query optimization
      What's new for IBM i 7.1
      Print PDF
      Query engine overview
        SQE and CQE engines
        Query dispatcher
        Statistics manager
        Global Statistics Cache
        Plan cache
      Data access methods
        Permanent objects & access methods
          Table
            Table scan
            Table probe
          Radix index
            Radix index scan
            Radix index probe
          Encoded vector index
            EVI probe
            EVI index-only access
            EVI symbol table scan
            EVI symbol table probe
        Temporary objects & 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
          Array unnest temporary table
            Array unnest temporary table scan
        Objects processed in parallel
        Spreading data automatically
      Processing queries: Overview
        Query optimizer
        Query optimization tips
        Access plan validation
        Single table optimization
        Join optimization
          Nested loop join
          Join optimization
          Join order optimization
          Full outer join
          Join cost & index selection
          Transitive closure predicates
          LPG
          CQE Join performance tips
          Multiple join types
          Join performance problems
          Join performance tips
        Distinct optimization
        Grouping optimization
          Hash grouping
          Index grouping
          Eliminate grouping columns
          Add grouping columns
          Index skip key processing
          Read trigger considerations
          Grouping set optimization
        Ordering optimization
        View implementation
          View composite
          View materialization
        MQT optimization
          MQT supported function
          Using MQTs
          MQT examples
          MQT matching
          Determining MQT usage
          MQT recommendations
        Recursive query optimization
          Example
          Multiple initialization & iterative fullselects
          Predicate pushing
          SEARCH considerations
          CYCLE considerations
          SMP & recursive queries
        Adaptive Query Processing
          How AQP works
          AQP example
          AQP join order
          Database Monitor additions
      Tools
        Health Center
          Navigator view
          SQL procedures
            Health_Database_Overview
            Health_Activity
            Health_Design_Limits
            Health_Size_Limits
            Health_Environmental_Limits
            Reset_Environmental_Limits
        Database Monitor
          Start
          End
          Performance rows
          Examples
            Application with table scans
            Queries with table scans
            Table scan detail
            Additional examples
        Navigator monitors
          Start
          Analyze data
          Compare data
          View statements
          Import
        Index advisor
          Display information
            System table
          Column descriptions
          Database monitor view
          Condense advice
        Visual Explain
          Start
          Information available
          Adaptive Query Processing in VE
        SQL Plan Cache
          Show Statements
          Column descriptions
          Properties
          Creating snapshots
          Event monitor
          SQL stored procedures
        Verify performance
        View debug messages
        Print SQL Information
        Tool comparison
        Change query attributes
          QAQQINI
            CHGQRYA
            Create
            Override support
            File format
            Update
            Authority requirements
            System-supplied triggers
            Query options
            SQL_XML_DATA_CCSID option
          Predictive Query Governor
            How to use
            Cancel a query
            Control the reply
            Test performance
            Time limit examples
            Test temporary storage use
            Storage limit examples
          Parallel processing
            System-wide
            Job level
        Statistics manager
          Automatic collection
          Automatic refresh
          View requests
          Indexes and column statistics
          Background collection
          Replicate column statistics
          View column statistics
          Manual collection and refresh
          APIs
        Display MQT columns
        Check pending constraints
      Creating an index strategy
        Binary radix indexes
          Derived key index
          Sparse indexes
            Optimization
            Matching algorithm
            Sparse index examples
          Specify PAGESIZE
          Index maintenance
        Encoded vector indexes
          How the EVI works
          When to create
          Maintenance
          Recommendations
        Compare radix & EVIs
        Indexes & the optimizer
          Index not used
          Display indexes for a table
          Determine unnecessary indexes
          Reset usage counts
          View index builds
          Manage index rebuilds
        Indexing strategy
          Reactive approach
          Proactive approach
        Coding for effective indexes
          Avoid numeric conversions
          Avoid arithmetic expressions
          Avoid character string padding
          LIKE considerations
          Derived indexes
          Sparse indexes
        Indexes with sort sequence
          Selection, joins, or grouping
          Ordering
        Index examples
          Equal selection, no sort sequence
          Equal selection, unique-weight sort sequence
          Equal selection, shared-weight sort sequence
          Greater than selection, unique-weight sort sequence
          Join selection, unique-weight sort sequence
          Join selection, shared-weight sort sequence
          Order, no sort sequence
          Order, unique-weight sort sequence
          Order, shared-weight sort sequence
          Order, ALWCPYDTA(*OPTIMIZE), unique-weight sort sequence
          Group, no sort sequence
          Group, unique-weight sort sequence
          Group, shared-weight sort sequence
          Order & group on same columns, unique-weight sort sequence
          Order & group on same columns, ALWCPYDTA(*OPTIMIZE), unique-weight sort sequence
          Order & group on same columns, shared-weight sort sequence
          Order & group on same columns, ALWCPYDTA(*OPTIMIZE), shared-weight sort sequence
          Order & group on different columns, unique-weight sort sequence
          Order & group on different columns, ALWCPYDTA(*OPTIMIZE), unique-weight sort sequence
          Order & group on different columns, ALWCPYDTA(*OPTIMIZE), shared-weight sort sequence
          Sparse index examples
      Application design tips
        Live data
        Reduce open operations
        Retain cursor positions
          Non-ILE program calls
          ILE program calls
          General rules
      Programming techniques
        Use the OPTIMIZE clause
        Use FETCH FOR n ROWS
          Improve SQL blocking performance
        Use INSERT n ROWS
        Control database manager blocking
        Optimize columns selected
        PREPARE considerations
        REFRESH(*FORWARD) considerations
        Improve concurrency
      Performance considerations
        Long object names
        Precompile options
        ALWCPYDTA
        VARCHAR and VARGRAPHIC
        Field procedures
          Examples
      SYSTOOLS
        Using SYSTOOLS
      Database monitor formats
        SQL table
        SQL view
          1000 - SQL Information
          3000 - Table Scan
          3001 - Index Used
          3002 - Index Created
          3003 - Query Sort
          3004 - Temp Table
          3005 - Table Locked
          3006 - Access Plan Rebuilt
          3007 - Optimizer Timed Out
          3008 - Subquery Processing
          3010 - Host Variable, ODP Implementation
          3011 - Array Host Variables
          3012 - Global Variables
          3014 - Generic QQ Information
          3015 - Statistics Information
          3018 - STRDBMON/ENDDBMON
          3019 - Rows retrieved
          3020 - Index advised (SQE)
          3021 - Bitmap Created
          3022 - Bitmap Merge
          3023 - Temp Hash Table Created
          3025 - Distinct Processing
          3026 - Set operation
          3027 - Subquery Merge
          3028 - Grouping
          3030 - Materialized query tables
          3031 - Recursive common table expressions
      Messages reference
        Performance information
        Open data paths
        PRTSQLINF
    Programming
      Database programming
        What's new for IBM i 7.1
        PDF file for Database programming
        Database file concepts
          DB2 for i
          Interfaces to DB2 for i
            Traditional system interface
            SQL
            System i Navigator
            IBM Query for i
          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