Db2

Hello,

Can anyone tell me when the online index reorg will be made available in Db2 pureScale ? I have a Customer using Db2 pureScale that would use the online index reorg as it used in Db2 z/OS. The only information I have found is in the online documentation (last updated 18 April 2023) reporting "Restriction: Online index reorganization is not supported in Db2 pureScale® environments and will fail with SQL1419N".

Thanks in advance. Ciao. Roberto

------------------------------
Roberto Stradella
------------------------------

According to the IBM documentation, online index reorganization is not currently supported in Db2 pureScale environments. However, IBM is working on adding this feature in a future release. There is no specific ETA for when this feature will be available, but it is expected to be released in the next few months.

In the meantime, if your customer needs to reorganize indexes in a Db2 pureScale environment, they can do so offline. To do this, they can use the REORG INDEXES command with the OFFLINE option. This will rebuild the indexes without affecting the availability of the database.

Hello,

Can anyone tell me when the online index reorg will be made available in Db2 pureScale ? I have a Customer using Db2 pureScale that would use the online index reorg as it used in Db2 z/OS. The only information I have found is in the online documentation (last updated 18 April 2023) reporting "Restriction: Online index reorganization is not supported in Db2 pureScale® environments and will fail with SQL1419N".

Thanks in advance. Ciao. Roberto

Hello Youssef,

thanks for the answer, I have a couple of questions:

1) you wrote "There is no specific ETA for when this feature will be available, but it is expected to be released in the next few months", do you have info from IBM stating that they are working on this feature to made it available on pureScale ? I have found nothing related to it.

2) Offline Reorg Index is what my Customer would avoid because the indexes he would reorganize are related to a very big table. And running offline reorg on it I think will cause a lot of problems to applications that need to access the index.

Thanks. Bye. Roberto

------------------------------
Roberto Stradella

Original Message:
Sent: Fri July 07, 2023 08:14 PM
From: Youssef Sbai Idrissi
Subject: Online index reorganization in Db2 pureScale®

According to the IBM documentation, online index reorganization is not currently supported in Db2 pureScale environments. However, IBM is working on adding this feature in a future release. There is no specific ETA for when this feature will be available, but it is expected to be released in the next few months.

In the meantime, if your customer needs to reorganize indexes in a Db2 pureScale environment, they can do so offline. To do this, they can use the REORG INDEXES command with the OFFLINE option. This will rebuild the indexes without affecting the availability of the database.

------------------------------
Youssef Sbai Idrissi
Software Engineer

Original Message:
Sent: Fri July 07, 2023 07:55 PM
From: Roberto Stradella
Subject: Online index reorganization in Db2 pureScale®

Hello,

Can anyone tell me when the online index reorg will be made available in Db2 pureScale ? I have a Customer using Db2 pureScale that would use the online index reorg as it used in Db2 z/OS. The only information I have found is in the online documentation (last updated 18 April 2023) reporting "Restriction: Online index reorganization is not supported in Db2 pureScale® environments and will fail with SQL1419N".

Thanks in advance. Ciao. Roberto

------------------------------
Roberto Stradella
------------------------------

According to the IBM documentation, online index reorganization is not currently supported in Db2 pureScale environments. However, IBM is working on adding this feature in a future release. There is no specific ETA for when this feature will be available, but it is expected to be released in the next few months.

In the meantime, if your customer needs to reorganize indexes in a Db2 pureScale environment, they can do so offline. To do this, they can use the REORG INDEXES command with the OFFLINE option. This will rebuild the indexes without affecting the availability of the database.

Hello,

Can anyone tell me when the online index reorg will be made available in Db2 pureScale ? I have a Customer using Db2 pureScale that would use the online index reorg as it used in Db2 z/OS. The only information I have found is in the online documentation (last updated 18 April 2023) reporting "Restriction: Online index reorganization is not supported in Db2 pureScale® environments and will fail with SQL1419N".

Thanks in advance. Ciao. Roberto

It is possible/beneficial to create an additional index, with say one extra (small, low cardinality, potentially useful) field, then reorg ( or drop, rebuild) the old index then do this alternately whenever an online reorg is required ?

According to the IBM documentation, online index reorganization is not currently supported in Db2 pureScale environments. However, IBM is working on adding this feature in a future release. There is no specific ETA for when this feature will be available, but it is expected to be released in the next few months.

In the meantime, if your customer needs to reorganize indexes in a Db2 pureScale environment, they can do so offline. To do this, they can use the REORG INDEXES command with the OFFLINE option. This will rebuild the indexes without affecting the availability of the database.

Hello,

Can anyone tell me when the online index reorg will be made available in Db2 pureScale ? I have a Customer using Db2 pureScale that would use the online index reorg as it used in Db2 z/OS. The only information I have found is in the online documentation (last updated 18 April 2023) reporting "Restriction: Online index reorganization is not supported in Db2 pureScale® environments and will fail with SQL1419N".

Thanks in advance. Ciao. Roberto

Hi Greg!
How you propose to deal with packages referring to now inaccessible index when implementing your idea of "flipping" indexes?

It is possible/beneficial to create an additional index, with say one extra (small, low cardinality, potentially useful) field, then reorg ( or drop, rebuild) the old index then do this alternately whenever an online reorg is required ?

According to the IBM documentation, online index reorganization is not currently supported in Db2 pureScale environments. However, IBM is working on adding this feature in a future release. There is no specific ETA for when this feature will be available, but it is expected to be released in the next few months.

In the meantime, if your customer needs to reorganize indexes in a Db2 pureScale environment, they can do so offline. To do this, they can use the REORG INDEXES command with the OFFLINE option. This will rebuild the indexes without affecting the availability of the database.

Hello,

Can anyone tell me when the online index reorg will be made available in Db2 pureScale ? I have a Customer using Db2 pureScale that would use the online index reorg as it used in Db2 z/OS. The only information I have found is in the online documentation (last updated 18 April 2023) reporting "Restriction: Online index reorganization is not supported in Db2 pureScale® environments and will fail with SQL1419N".

Thanks in advance. Ciao. Roberto