SQLCODE = -148, REASON 09

sonipankaj · New User Joined: 23 Nov 2005 Posts: 10

Hi,

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 ?

Thanks
Soni

sushanth bobby · Posted: Tue Dec 15, 2009 11:30 am

Hi Soni,

Take a look @ DB2 V9 Administration Guide and search for "Table space versions". It has all the information you need.

Sushanth

Srihari Gonugunta · Posted: Tue Dec 15, 2009 12:12 pm

Soni,

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.

Hope this helps.