Join us for an insightful discussion on 15 July, 2025 at 11:00 AM ET. As databases grow and evolve, table and index fragmentation can become a significant challenge, leading to inefficient storage utilization and degraded query performance. This session provides a deep dive into the structure and maintenance of Db2 LUW tables and indexes, with a focus on the REORG process as a critical performance tuning strategy. Attendees will gain a solid understanding of how Db2 organizes data and indexes, and learn how to identify when reorganization is necessary. The session will explore the different types of REORG operations: REORG TABLE, REORG INDEX, and Online vs. Offline REORG, along with best practices for selecting the right approach based on system availability and performance goals. Whether you're a DBA or performance engineer, this session will equip you with the knowledge and tools to maintain a healthy, high-performing Db2 LUW environment.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Wei Cao will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

------------------------------
IBM TechXchange Community Team
------------------------------

Hello Everyone! 

If you missed the webinar, you can find the recording and presentation Here.

Join us for an insightful discussion on 15 July, 2025 at 11:00 AM ET. As databases grow and evolve, table and index fragmentation can become a significant challenge, leading to inefficient storage utilization and degraded query performance. This session provides a deep dive into the structure and maintenance of Db2 LUW tables and indexes, with a focus on the REORG process as a critical performance tuning strategy. Attendees will gain a solid understanding of how Db2 organizes data and indexes, and learn how to identify when reorganization is necessary. The session will explore the different types of REORG operations: REORG TABLE, REORG INDEX, and Online vs. Offline REORG, along with best practices for selecting the right approach based on system availability and performance goals. Whether you're a DBA or performance engineer, this session will equip you with the knowledge and tools to maintain a healthy, high-performing Db2 LUW environment.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Wei Cao will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

------------------------------
IBM TechXchange Community Team
------------------------------

Hi,

It will be helpful to know if we can synchronize xfs extent map and tablespace map at the storage or file system  level. 

When we talk about reorg organizing pages of tablespace is it only a logical construction or physical at the file system level or storage medium level?

Thanks

Harishkumar 

Hello Everyone! 

If you missed the webinar, you can find the recording and presentation Here.

Join us for an insightful discussion on 15 July, 2025 at 11:00 AM ET. As databases grow and evolve, table and index fragmentation can become a significant challenge, leading to inefficient storage utilization and degraded query performance. This session provides a deep dive into the structure and maintenance of Db2 LUW tables and indexes, with a focus on the REORG process as a critical performance tuning strategy. Attendees will gain a solid understanding of how Db2 organizes data and indexes, and learn how to identify when reorganization is necessary. The session will explore the different types of REORG operations: REORG TABLE, REORG INDEX, and Online vs. Offline REORG, along with best practices for selecting the right approach based on system availability and performance goals. Whether you're a DBA or performance engineer, this session will equip you with the knowledge and tools to maintain a healthy, high-performing Db2 LUW environment.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Wei Cao will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

------------------------------
IBM TechXchange Community Team
------------------------------

Hi Harish,

you are mixing up OS level or file system level defragmentation with logical reorganization within Db2 tablespace containers. These things have to be done separate.

Cheers

Hi,

It will be helpful to know if we can synchronize xfs extent map and tablespace map at the storage or file system  level. 

When we talk about reorg organizing pages of tablespace is it only a logical construction or physical at the file system level or storage medium level?

Thanks

Harishkumar 

Hello Everyone! 

If you missed the webinar, you can find the recording and presentation Here.

Join us for an insightful discussion on 15 July, 2025 at 11:00 AM ET. As databases grow and evolve, table and index fragmentation can become a significant challenge, leading to inefficient storage utilization and degraded query performance. This session provides a deep dive into the structure and maintenance of Db2 LUW tables and indexes, with a focus on the REORG process as a critical performance tuning strategy. Attendees will gain a solid understanding of how Db2 organizes data and indexes, and learn how to identify when reorganization is necessary. The session will explore the different types of REORG operations: REORG TABLE, REORG INDEX, and Online vs. Offline REORG, along with best practices for selecting the right approach based on system availability and performance goals. Whether you're a DBA or performance engineer, this session will equip you with the knowledge and tools to maintain a healthy, high-performing Db2 LUW environment.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Wei Cao will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

------------------------------
IBM TechXchange Community Team
------------------------------

Hi Harish,

you are mixing up OS level or file system level defragmentation with logical reorganization within Db2 tablespace containers. These things have to be done separate.

Cheers

Hi,

It will be helpful to know if we can synchronize xfs extent map and tablespace map at the storage or file system  level. 

When we talk about reorg organizing pages of tablespace is it only a logical construction or physical at the file system level or storage medium level?

Thanks

Harishkumar 

Hello Everyone! 

If you missed the webinar, you can find the recording and presentation Here.

Join us for an insightful discussion on 15 July, 2025 at 11:00 AM ET. As databases grow and evolve, table and index fragmentation can become a significant challenge, leading to inefficient storage utilization and degraded query performance. This session provides a deep dive into the structure and maintenance of Db2 LUW tables and indexes, with a focus on the REORG process as a critical performance tuning strategy. Attendees will gain a solid understanding of how Db2 organizes data and indexes, and learn how to identify when reorganization is necessary. The session will explore the different types of REORG operations: REORG TABLE, REORG INDEX, and Online vs. Offline REORG, along with best practices for selecting the right approach based on system availability and performance goals. Whether you're a DBA or performance engineer, this session will equip you with the knowledge and tools to maintain a healthy, high-performing Db2 LUW environment.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Wei Cao will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

------------------------------
IBM TechXchange Community Team
------------------------------

Hello Harish,

quite some long time ago IBM gave up the raw disk support. I think it was in Db2 9.7 or so.

Now Db2 just asks the file system to create a file of x GB size. The file system checks if it has an according junk of free space, but also return you a fragmented file depending on your previous disk content. This is another reason for starting on a clean and separate file space with a decent file size.

Db2 builds its own logical system within these container files.

The file system on OS level could also consist of multiple junks from your storage subsystem. 

All these details are transparent to the user.

Yes, there are chances to make it better, and chances to wreck it.

Cheers

Hi Harish,

you are mixing up OS level or file system level defragmentation with logical reorganization within Db2 tablespace containers. These things have to be done separate.

Cheers

Hi,

It will be helpful to know if we can synchronize xfs extent map and tablespace map at the storage or file system  level. 

When we talk about reorg organizing pages of tablespace is it only a logical construction or physical at the file system level or storage medium level?

Thanks

Harishkumar 

Hello Everyone! 

If you missed the webinar, you can find the recording and presentation Here.

Join us for an insightful discussion on 15 July, 2025 at 11:00 AM ET. As databases grow and evolve, table and index fragmentation can become a significant challenge, leading to inefficient storage utilization and degraded query performance. This session provides a deep dive into the structure and maintenance of Db2 LUW tables and indexes, with a focus on the REORG process as a critical performance tuning strategy. Attendees will gain a solid understanding of how Db2 organizes data and indexes, and learn how to identify when reorganization is necessary. The session will explore the different types of REORG operations: REORG TABLE, REORG INDEX, and Online vs. Offline REORG, along with best practices for selecting the right approach based on system availability and performance goals. Whether you're a DBA or performance engineer, this session will equip you with the knowledge and tools to maintain a healthy, high-performing Db2 LUW environment.

Click here to register and add the event to your calendar.

Where is the link to join? Check your email the day before the event!

 How to get the most out of this webinar:

• Explore the Db2 Community.

• Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Wei Cao will be happy to answer your questions and share insights.

• Check out upcoming Db2 events here.

We look forward to seeing you there!

------------------------------
IBM TechXchange Community Team
------------------------------