Chapter 28 Further Reading

IBM Official Documentation

  • DB2 for z/OS Data Sharing: Planning and Administration (SC27-8849) The definitive IBM reference for data sharing configuration, operation, and troubleshooting. Covers every aspect from initial setup to advanced performance tuning. Essential reading for any z/OS DBA managing a data sharing group.

  • DB2 for z/OS Installation and Migration Guide (GC28-0837) Includes detailed instructions for enabling data sharing during DB2 installation, adding members to a data sharing group, and performing version migrations with version coexistence.

  • Parallel Sysplex Configuration Overview (SG24-2673) IBM Redbook covering the end-to-end Parallel Sysplex architecture, including coupling facility configuration, CFRM policy management, sysplex distributor setup, and XCF group services.

  • z/OS MVS Setting Up a Sysplex (SA38-0673) The z/OS base documentation for configuring a Parallel Sysplex, including coupling facility resource management (CFRM) policies, sysplex failure management (SFM), and automatic restart management (ARM).

IBM Redbooks

  • DB2 for z/OS Data Sharing: Achieving High Availability (SG24-6872) A practical IBM Redbook focused on achieving high availability through data sharing. Covers real-world deployment scenarios, performance tuning, and failure recovery procedures with detailed examples.

  • DB2 for z/OS: Data Sharing in a Nutshell (REDP-5455) A concise Redpaper providing an overview of data sharing concepts for DBAs new to the technology. Good for quick reference and initial learning.

  • Coupling Facility Performance and Sizing (SG24-6398) Detailed guidance on sizing coupling facility structures including lock structures, group buffer pools, and the SCA. Includes formulas, worksheets, and real-world sizing examples.

  • DB2 for z/OS Performance Topics (SG24-6867) Covers data sharing performance considerations in depth, including GBP tuning, lock structure optimization, false contention analysis, and workload balancing strategies.

Performance and Monitoring

  • OMEGAMON for DB2 Performance Expert IBM's premier monitoring tool for DB2 on z/OS. Provides real-time dashboards for data sharing metrics including CF service time, GBP hit ratios, XI rates, castout activity, and retained lock monitoring.

  • RMF (Resource Measurement Facility) for z/OS The z/OS system-level monitoring tool that provides coupling facility performance data. RMF reports include CF utilization, link busy percentages, and structure activity statistics.

  • IBM Data Server Manager Web-based monitoring and administration tool that can monitor multiple data sharing members from a single console.

Technical Articles and Whitepapers

  • "Understanding DB2 Data Sharing Locking" — IBM Developer A detailed technical article explaining P-locks, L-locks, lock propagation, and the relationship between local and global locking in data sharing.

  • "Group Buffer Pool Tuning in DB2 Data Sharing" — IBM Support Step-by-step guidance for diagnosing and resolving GBP performance problems including low hit ratios, excessive castout activity, and directory reclaims.

  • "Rolling Maintenance in a DB2 Data Sharing Environment" — IBM Knowledge Center Procedures for performing rolling maintenance including PTF application, SMP/E APPLY processing, and DB2 version migration with version coexistence.

Community and Conference Resources

  • SHARE Conference — z/OS and DB2 Track The SHARE user group conference features multiple sessions on data sharing each year, presented by IBM developers and experienced DBAs from major enterprises. Presentation materials are available to SHARE members.

  • IDUG (International DB2 Users Group) IDUG conferences and webinars frequently cover data sharing topics. The IDUG content library includes presentations from decades of conferences.

  • IBM Z and LinuxONE Community Online community with forums, blogs, and technical articles about z/OS technologies including data sharing. Accessible at community.ibm.com/z.

  • Chapter 18: Concurrency and Locking — Foundation for understanding L-locks in data sharing
  • Chapter 26: DB2 on z/OS — The Mainframe Environment — Prerequisites for understanding the z/OS platform
  • Chapter 27: z/OS Performance and Optimization — Performance tuning that complements data sharing tuning
  • Chapter 30: Backup, Recovery, and Business Continuity — Disaster recovery strategies that extend data sharing HA