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