1271 - 超越 Db2 舒适区：深层性能提升.pdf

1、Orlando,FLOctober 69IBM TechXchange 2025Session code:12711271Nemi AgrawalCEO&Director,Raindrops IncBeyond Db2 Comfort Zone:Beyond Db2 Comfort Zone:Deep down Performance Deep down Performance EnhancementEnhancementAgendaOverviewOverviewDb2 Performance Db2 Performance-SystemSystemDb2 Performance Db2 P

2、erformance-Db2MonDb2MonDb2 Performance Db2 Performance Mon Get TablesMon Get TablesIBM TechXchange|2025 IBM CorporationNemi Agrawal,Director,Data Infinity Work Experience since 1991 Department of Homeland Security/Customs and Border Protection Citibank,IBM,Deutsche Bank,Deutsche Telekom IBM Champion

3、-2023-25 Speaker IBM TechXChange 2023-2025 Speaker-IDUG NA 2024-2025 Speaker-IDUG EMEA-2024-2025 Speaker-Postgres Conference NYC 2023 Certifications Project Management Professional-PMI Management certification from Harvard Business School AWS Certified Solution Architect-AWS Oracle Certified Profess

4、ional-Oracle IBM Certified Database Administrator-DB2 Interests:Volunteer Photographer at FIRST WORLD Robotic Championship Write,Editor and Publisher of children magazine(BileiNani,Oriya)System OverviewDB2 High Volume,Highly Active,Complex&Resilient High Volume EnvironmentNumber of Databases:250Numb

5、er of clients:300AIX Servers:Power 9&10High AvailabilityHome Grown CDC due to Q-Replication latencyDiester RecoveryApplications hosted on AWSNumber of years:23 yearsPRODUCT Supports:LDAP Informatica SAP ISVG TivoliConnect types:JDBC,ODBC,GSS,Db2 ClientApplications:AWS&On-PremOther database supports:

6、Oracle,PostgreSQL,SQL servers,MySQL,Cassandra,Mongo DB,Technical Overview DB2AUDITDB2 Encryption at RestDB2 Encryption in TransitDB2 Encrypted Backup,HADR and federationDB2 HADRGSS AuthenticationDB2 Replication Home Grown CDCDB2 CompressionDB2 Compressed Backup using NX842DB2 BLUComplex Data Structu