Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces

Jorg Lueke

Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces

Robert in his blog around 2014 mentioned that a requirement existed for DB2 to handle multi-table tablespace conversions. So far that does not appear to have been accomplished. Does anyone know if this is still on the docket? If yes with a potential timeframe?

Daniel Luksetich

Non-disruptive universal table space conversion process for multi-table simple and segmented table s
(in response to Jorg Lueke)
I spoke with Haakon Roberts late last year and at that time he said late 2019. I’ll see him next week and ask him.

Cheers,

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: Jorg Lueke <[login to unmask email]>
Sent: Tuesday, May 28, 2019 9:17 AM
To: [login to unmask email]
Subject: [DB2-L] - Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces



Robert in his blog around 2014 mentioned that a requirement existed for DB2 to handle multi-table tablespace conversions. So far that does not appear to have been accomplished. Does anyone know if this is still on the docket? If yes with a potential timeframe?



-----End Original Message-----

Andy Smith

RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces
(in response to Jorg Lueke)

Jorg, I wasn't at the IBM THINK conference earlier this year, but apparently Jeff Josten talked about "Online conversion of multi-table tablespaces to UTS PBG" as a Future Improvement.  Dave Beulke wrote about it here:

https://www.idug.org/p/fo/st/thread=48781

I've been waiting for news on this topic to be posted to Paul McWilliams' News From The Lab blog....

Phil Grainger

Non-disruptive universal table space conversion process for multi-table simple and segmented table s
(in response to Andy Smith)
I couldn’t possibly comment, but Dave Buelke says

“Another new Db2 for z/OS enhancement takes care of that pesky legacy problem of having multiple tables in an old style tablespace. New enhancements are providing Db2 V12 capabilities to provide online reorganization facilities to take those multiple table tablespaces to seamlessly migrate them to universal tablespaces partition by growth (UTS PBG) tablespaces”

So I guess it’s a matter of time. And doing it with the Reorg utility also fits with the ever-increasing list of on-line schema changes (or as someone once said “Drop Avoidance”)

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Andy Smith <[login to unmask email]>
Sent: 30 May 2019 14:44
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces


Jorg, I wasn't at the IBM THINK conference earlier this year, but apparently Jeff Josten talked about "Online conversion of multi-table tablespaces to UTS PBG" as a Future Improvement. Dave Beulke wrote about it here:

https://www.idug.org/p/fo/st/thread=48781 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_st_thread-3D48781&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=ncTZIEOS12gvQmtxam3veKuFsaet1wYVCM_6uuLLQEA&s=jdDw7DIPoBciMkATaazZ0FcVAL2LxKx28fBdVq54t24&e=

I've been waiting for news on this topic to be posted to Paul McWilliams' News From The Lab blog....

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.png (3.7k)
  • image004.png (<1k)

Philip Sevetson

Non-disruptive universal table space conversion process for multi-table simple and segmented table s
(in response to Phil Grainger)
It’ll be interesting to see how that REORG affects the use of LISTDEF and other utilities performed against the previously-multi-table-tablespace. And, of course, our LOAD RESUMEs will have to become LOAD REPLACEs (Multi step load to replace the contents of a reference-table tablespace).

It is, I admit, nice to look at possibly being able to move all of those tables without explicit DROP/CREATE code.

-phil (sevetson)

From: Grainger, Phil [mailto:[login to unmask email]
Sent: Thursday, May 30, 2019 10:16 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces

I couldn’t possibly comment, but Dave Buelke says

“Another new Db2 for z/OS enhancement takes care of that pesky legacy problem of having multiple tables in an old style tablespace. New enhancements are providing Db2 V12 capabilities to provide online reorganization facilities to take those multiple table tablespaces to seamlessly migrate them to universal tablespaces partition by growth (UTS PBG) tablespaces”

So I guess it’s a matter of time. And doing it with the Reorg utility also fits with the ever-increasing list of on-line schema changes (or as someone once said “Drop Avoidance”)

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Andy Smith <[login to unmask email]>
Sent: 30 May 2019 14:44
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces


Jorg, I wasn't at the IBM THINK conference earlier this year, but apparently Jeff Josten talked about "Online conversion of multi-table tablespaces to UTS PBG" as a Future Improvement. Dave Beulke wrote about it here:

https://www.idug.org/p/fo/st/thread=48781 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_st_thread-3D48781&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=ncTZIEOS12gvQmtxam3veKuFsaet1wYVCM_6uuLLQEA&s=jdDw7DIPoBciMkATaazZ0FcVAL2LxKx28fBdVq54t24&e=

I've been waiting for news on this topic to be posted to Paul McWilliams' News From The Lab blog....

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Roy Boxwell

Non-disruptive universal table space conversion process for multi-table simple and segmented table s
(in response to Philip Sevetson)
It sure will be, but I have a few customers who are a little bit afraid of that many open vsam datasets.... that is a real benefit of multi-table spaces of course...

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de
Link zur Datenschutzerklärung

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

> On 30 May 2019, at 16:19, Sevetson, Phil <[login to unmask email]> wrote:
>
> It’ll be interesting to see how that REORG affects the use of LISTDEF and other utilities performed against the previously-multi-table-tablespace. And, of course, our LOAD RESUMEs will have to become LOAD REPLACEs (Multi step load to replace the contents of a reference-table tablespace).
>
> It is, I admit, nice to look at possibly being able to move all of those tables without explicit DROP/CREATE code.
>
> -phil (sevetson)
>
> From: Grainger, Phil [mailto:[login to unmask email]
> Sent: Thursday, May 30, 2019 10:16 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces
>
> I couldn’t possibly comment, but Dave Buelke says
>
> “Another new Db2 for z/OS enhancement takes care of that pesky legacy problem of having multiple tables in an old style tablespace. New enhancements are providing Db2 V12 capabilities to provide online reorganization facilities to take those multiple table tablespaces to seamlessly migrate them to universal tablespaces partition by growth (UTS PBG) tablespaces”
>
> So I guess it’s a matter of time. And doing it with the Reorg utility also fits with the ever-increasing list of on-line schema changes (or as someone once said “Drop Avoidance”)
>
> Phil Grainger
> Principal Enablement Manager
>
> Direct
> +44 1189 218 000
> Mobile
> +44 7808 643 479
> Email
> [login to unmask email]
> E2, Eskdale Road
> Winnersh
> Berkshire
> United Kingdom
> RG41 5TS
>
>
>
> From: Andy Smith <[login to unmask email]>
> Sent: 30 May 2019 14:44
> To: [login to unmask email]
> Subject: [EXTERNAL] [DB2-L] - RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces
>
> Jorg, I wasn't at the IBM THINK conference earlier this year, but apparently Jeff Josten talked about "Online conversion of multi-table tablespaces to UTS PBG" as a Future Improvement. Dave Beulke wrote about it here:
>
> https://www.idug.org/p/fo/st/thread=48781
>
> I've been waiting for news on this topic to be posted to Paul McWilliams' News From The Lab blog....
>
>
> -----End Original Message-----
> BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
> -----End Original Message-----
> **This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Visit ESAi at IDUG Charlotte. Enter drawings & learn about BCV4, BCV5, Masking Tool, BPA4DB2...
> great automated solutions for Cloning, Buffer Pool Tuning, Log processing, TDM & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)

J&#248;rn Thyssen

RE: Non-disruptive universal table space conversion process for multi-table simple and segmented table spaces
(in response to Jorg Lueke)

Hi Jorg,

Are you on Db2 12? This feature will be tied to a specific future function level.


In Reply to Jorg Lueke:

Robert in his blog around 2014 mentioned that a requirement existed for DB2 to handle multi-table tablespace conversions. So far that does not appear to have been accomplished. Does anyone know if this is still on the docket? If yes with a potential timeframe?



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal.