I have a Db2 table which is having its Clone table as well. I had the requirement to add few more columns in it. However, db2 didn't allow me to add these column because of its clone. So, I have dropped the clone and ran alter to add these columns. It went fine. Now, I am trying to again run the alter to re-create its clone table. But, I am getting the SQLCODE =-148 REASON 09. I have found somewhere on net that it is because of active versioning and it should not be active for Clone table. fyi, I've ran the REORG after adding the columns.
Can anyone tell me more about this "Versioning in Db2", like how to deactivate it and what will be the impact, etc ?
Find the value of VERSION column in SYSIBM.SYSTABLES for this table.
VERSION The version of the data row format for this table.
A value of zero indicates that a version-creating alter operation has never occurred against this table.
A value of -1 indicates that the view has been regenerated because a column of the base table has been altered.
A value of 800 indicates that a successful CREATE VIEW or ALTER VIEW statement has occurred against this table in Version 8 or later.