Loading…
Audience: Advanced clear filter
Wednesday, June 11
 

10:20am EDT

C10 | Automatic Fast DB Size Reduction, NO DELETE, NO REORG, NO System Down
Wednesday June 11, 2025 10:20am - 11:20am EDT
Spring
Databases keep growing.  Many applications do not need the older data at certain age, which could vary from a few days to a few years.  Reducing the DB size can not only save storage, but also the backup/restore time, and more importantly improves the database performance, in most cases.  But, DELETE/REORG has always been a nightmare to DBAs, specially on large databases.  This presentation demonstrates a working system which purges the older data from DB2 databases, FAST (in seconds/minutes), with NO System down, NO DELETE/REORG involvement, which is pretty much independent of the database size.  The system also provides the option of old–data–archive before purging.
Speakers
avatar for Farid Hosseini

Farid Hosseini

Tech Lead Database Engineer, Freddie Mac
Farid Hosseini is a former IBMer at DB2 Lab in late 90s and early 2000s, working as a DB2 consultant for decades with multiple mission critical organizations, resolved tough issues and currently working at Freddie Mac as a Tech lead Database Engineer.
Wednesday June 11, 2025 10:20am - 11:20am EDT
Spring
  Technical Session, Operations & Automation
 
  • Filter By Date
    Jun 8 - 12, 2025
  • Filter By Venue
    265 Peachtree Center Avenue Northeast, Atlanta, GA, USA
    All
    Auburn
    Edgewood
    Embassy B/C
    Embassy D/E
    Fairlie
    Inman
    International Ballroom
    International Tower Lobby
    Piedmont
    Roswell
    Spring
    Techwood
    University
  • Filter By Type
    Badging & Certification
    Break
    Breakfast
    Coffee Break
    Evening Event
    Expert Panel
    Hands–On Lab
    IDUG Essentials
    IDUG Reception
    Lunch
    Main Stage Event
    Partner-Sponsored Presentation
    Registration
    Spotlight
    Technical Session
    All
    AI Data Mining and ML
    Backup Recovery & Data Movement
    Cloud Warehouse and Data Lakes
    Database Practices
    Db2 Features Improvements and Tips LUW
    Db2 Features Improvements and Tips z/OS
    Db2 Solutions Utilities and Tools
    Operations & Automation
    Performance Monitoring and Troubleshooting
    SQL App Dev and Modernization
    Security Compliance and Governance
    Workshop
  • Audience
    Advanced
    All
    Beginner
    Intermediate
  • Subject
    AI / ML
    Cross Platform
    LUW
    z/OS
  • Timezone
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Sunday, June 8
Monday, June 9
Tuesday, June 10
Wednesday, June 11
Thursday, June 12
Auburn
Edgewood
Embassy B/C
Embassy D/E
Fairlie
Inman
International Ballroom
International Tower Lobby
Piedmont
Roswell
Spring
Techwood
University
  • Badging & Certification
  • Break
  • Breakfast
  • Coffee Break
  • Evening Event
  • Expert Panel
  • Hands–On Lab
  • IDUG Essentials
  • IDUG Reception
  • Lunch
  • Main Stage Event
  • Partner-Sponsored Presentation
  • Registration
  • Spotlight
  • Technical Session
  • Workshop
  • Audience
  • Advanced
  • All
  • Beginner
  • Intermediate
  • Subject
  • AI / ML
  • Cross Platform
  • LUW
  • z/OS