Possibly relevant: Is there an unexpanded additional column in the
table? You might need to run a REORG of the tablespace to
instantiate the new column(s) in rows which are older than the last
Whether or not there's an unexpanded column, this is how we add
CLONEs in the worst case where nothing else works:
* REORG the tablespace
* UNLOAD the table to protect the data
* MODIFY RECOVERY / DELETE AGE(*)
* ALTER TABLE / ADD CLONE
* COPY the tablespace (immediately).
Computer Systems Manager
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
[cid:[login to unmask email]
From: Melanie Bowen <[login to unmask email]>
Sent: Wednesday, July 8, 2020 2:37 PM
To: [login to unmask email]
Subject: [DB2-L] - Versions in Db2 for z/OS V11
I have a tablespace that has an oldest version of 4 and a current
version of 5. There is only one table in this tablespace.
I would like to clone this table, but receive an SQLCODE -148
REASON 09 when trying to add the clone.
Therefore, I ran a repair using the INSERTVERSIONPAGES
SETCURRENTVERSION TABLESPACE, I also ran a reorg, did an image
copy, and then ran a modify recovery, only retaining the
After following the above steps, I still get the -148 SQLCODE with
a REASON 09 when trying to clone the tablespace, and the oldest
version and current version did not change.
I did notice that the following message was received from the
REPAIR INSERTVERSIONPAGES COMPLETED. NO VERSION PAGES NEED TO BE
Can someone tell me what I've missed?
Thanks for your help.
-----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