3381 - 将 Db2_Z 迁移到 Db2 pureScale 的真实案例.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Session code 3381Real Life Experiences in Migrating Db2/Z to Db2 pureScaleJames Sobieski,Fourth Millennium TechnologiesSMike Toppins,RocketSoftwareReal Life Experiences in Migrating Db2/Z to Db2 pureScaleOrlando,FLOctober 69IBM TechXchange 2025Session code 388

2、1Real Life Experiences in Migrating Db2/Z to Db2 pureScaleJames Sobieski,Fourth Millennium TechnologiesSMike Toppins,RocketSoftwareReal Life Experiences in Migrating Db2/Z to Db2 pureScaleOverviewAgendaChallenges going from Db2/Z to Db2 LUWDifferences between Db2/Z and LUWDDL and DB Objects conversi

3、onsApplication ConsiderationsMigration Alternatives ConsideredReal Customer Migration ExperiencePerformance ObservationsIBM TechXchange|2025 IBM CorporationOrlando,FLOctober 69IBM TechXchange 2025Session code 3881Real Life Experiences in Migrating Db2/Z to Db2 pureScaleJames Sobieski,Fourth Millenni

4、um TechnologiesSMike Toppins,RocketSoftwareChallenges going fromDb2/Z to Db2 LUWArchitecture DifferencesArchitecture Change Mainframe to Linux pureScale has differences and similarities to Db2/Z Data Sharing Code pages and CCSID differences:EBCDIC to UTF-8 User interfaces ISPF and Batch Jobs to Shel

5、l Big Endian to Little Endian(on RHEL AIX is Big Endian also)DDL Changes About 80-90%same Most differences in Physical Design Some Db2/Z features dont exist in Db2 LUW and vice versaIBM TechXchange|2025 IBM CorporationArchitecture SimilaritiesBoth Db2/Z and Db2 LUW pureScale have multiple members fo

6、r 24x7 availability.Both use RDMA to communicate internallyBoth have shared Global BufferpoolsBoth have Global Lock ManagementDb2 Database architecture is similarDb2/Z database roughly equivalent to Db2 LUW SchemaTables,Tablespaces,Bufferpools Catalog tables similar but differentDb2 SQL syntax is be