Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE = -148, REASON 09

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sonipankaj

New User


Joined: 23 Nov 2005
Posts: 10

PostPosted: Mon Dec 14, 2009 9:37 pm    Post subject: SQLCODE = -148, REASON 09
Reply with quote

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
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Dec 15, 2009 11:30 am    Post subject:
Reply with quote

Hi Soni,

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

Sushanth
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Tue Dec 15, 2009 12:12 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us