Without knowing all the details, IBM put in a tremendous amount of work, due to customer requests, to provide the ability to perform online conversions from "old" table spaces to UTS (PBR or PBG), so you wouldn't need to deal with unloads, capturing/restoring GRANTs, all those ugly things you don't like to deal with when dealing with conversion outages. We did that almost exclusively on ours and it made our DBAs much happier not having to deal with unload/reloads on monstrous tables.
------------------------------
Greg DeBo
------------------------------
Original Message:
Sent: Wed September 01, 2021 09:15 AM
From: Gloria Fries
Subject: Unloading a PBG Tablespace
Hello,
We have Db2 v12 for z/os at CATALOG LEVEL(V12R1M507) and CURRENT FUNCTION LEVEL(V12R1M505).
We've been advising our DBAs to convert to PBG's when possible and one user raised a concern:
Instead of unloads by partition, when you convert to PBG, the unload is in one file and it would be very large for the partitioned tablespaces. This is another perspective and not something that has been discussed with encouraging PBG.
Can someone address this concern?
Thanks.
Gloria Fries
------------------------------
Gloria Fries
------------------------------
#Db2forz/OS