Please enter search query.
Search <book_title>...
InfoScale™ 9.0 Storage and Availability Management for DB2 Databases - AIX, Linux
Last Published:
2025-09-09
Product(s):
InfoScale & Storage Foundation (9.0)
Platform: AIX,Linux
- Section I. Storage Foundation High Availability (SFHA) management solutions for DB2 databases
- Overview of Storage Foundation for Databases
- Introducing Storage Foundation High Availability (SFHA) Solutions for DB2
- About the File System component
- About the Volume Manager component
- About Dynamic Multi-Pathing (DMP)
- About Cluster Server
- About Cluster Server agents
- About InfoScale Operations Manager
- Feature support for DB2 across InfoScale products
- Use cases for InfoScale products
- Overview of Storage Foundation for Databases
- Section II. Deploying DB2 with InfoScale products
- Deployment options for DB2 in a Storage Foundation environment
- DB2 deployment options in an InfoScale environment
- DB2 on a single system with Storage Foundation
- DB2 on a single system with off-host in a Storage Foundation environment
- DB2 in a highly available cluster with Storage Foundation High Availability
- DB2 in a parallel cluster with SF Cluster File System HA
- Deploying DB2 and Storage Foundation in a virtualization environment
- Deploying DB2 with Storage Foundation SmartMove and Thin Provisioning
- Deploying DB2 with Storage Foundation
- Deploying DB2 in an off-host configuration with Storage Foundation
- Deploying DB2 with High Availability
- Deployment options for DB2 in a Storage Foundation environment
- Section III. Configuring Storage Foundation for Database (SFDB) tools
- Configuring and managing the Storage Foundation for Databases repository database
- About the Storage Foundation for Databases (SFDB) repository
- Requirements for Storage Foundation for Databases (SFDB) tools
- Storage Foundation for Databases (SFDB) tools availability
- Configuring the Storage Foundation for Databases (SFDB) tools repository
- Updating the Storage Foundation for Databases (SFDB) repository after adding a node
- Updating the Storage Foundation for Databases (SFDB) repository after removing a node
- Removing the Storage Foundation for Databases (SFDB) repository
- Configuring authentication for Storage Foundation for Databases (SFDB) tools
- Configuring and managing the Storage Foundation for Databases repository database
- Section IV. Improving DB2 database performance
- About database accelerators
- Improving database performance with Quick I/O
- About Quick I/O
- How Quick I/O improves database performance
- Tasks for setting up Quick I/O in a database environment
- Preallocating space for Quick I/O files using the setext command
- Accessing regular VxFS files as Quick I/O files
- Converting DB2 containers to Quick I/O files
- About sparse files
- Displaying Quick I/O status and file attributes
- Extending a Quick I/O file
- Monitoring tablespace free space with DB2 and extending tablespace containers
- Recreating Quick I/O files after restoring a database
- Disabling Quick I/O
- Improving DB2 database performance with VxFS Concurrent I/O
- Section V. Using point-in-time copies
- Understanding point-in-time copy methods
- About point-in-time copies
- When to use point-in-time copies
- About Storage Foundation point-in-time copy technologies
- Point-in-time copy solutions supported by SFDB tools
- About snapshot modes supported by Storage Foundation for Databases (SFDB) tools
- Volume-level snapshots
- Storage Checkpoints
- Considerations for DB2 point-in-time copies
- Administering third-mirror break-off snapshots
- Administering Storage Checkpoints
- About Storage Checkpoints
- Database Storage Checkpoints for recovery
- Creating a Database Storage Checkpoint
- Deleting a Database Storage Checkpoint
- Mounting a Database Storage Checkpoint
- Unmounting a Database Storage Checkpoint
- Creating a database clone using a Database Storage Checkpoint
- Restoring database from a Database Storage Checkpoint
- Gathering data for offline-mode Database Storage Checkpoints
- Backing up and restoring with Netbackup in an SFHA environment
- Understanding point-in-time copy methods
- Section VI. Optimizing storage costs for DB2
- Section VII. Storage Foundation for Databases administrative reference
- Storage Foundation for Databases command reference
- Tuning for Storage Foundation for Databases
- Troubleshooting SFDB tools
Adding nodes to a cluster that is using authentication for SFDB tools
To add a node to a cluster that is using authentication for SFDB tools, perform the following steps as the root user
- Export authentication data from a node in the cluster that has already been authorized, by using the -o export_broker_config option of the sfae_auth_op command.
Use the -f option to provide a file name in which the exported data is to be stored.
# /opt/VRTS/bin/sfae_auth_op \ -o export_broker_config -f exported-data
- Copy the exported file to the new node by using any available copy mechanism such as scp or rcp.
- Import the authentication data on the new node by using the -o import_broker_config option of the sfae_auth_op command.
Use the -f option to provide the name of the file copied in Step 2.
# /opt/VRTS/bin/sfae_auth_op \ -o import_broker_config -f exported-data Setting up AT Importing broker configuration Starting SFAE AT broker
- Stop the vxdbd daemon on the new node.
# /opt/VRTS/bin/sfae_config disable vxdbd has been disabled and the daemon has been stopped.
- Enable authentication by setting the AUTHENTICATION key to yes in the
/etc/vx/vxdbed/admin.propertiesconfiguration file.If
/etc/vx/vxdbed/admin.propertiesdoes not exist, then use cp /opt/VRTSdbed/bin/admin.properties.example /etc/vx/vxdbed/admin.properties - Start the vxdbd daemon.
# /opt/VRTS/bin/sfae_config enable vxdbd has been enabled and the daemon has been started. It will start automatically on reboot.
The new node is now authenticated to interact with the cluster to run SFDB commands.