Db2 Sql Error 968
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design
Sql2216n Sql Error "-668"
and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware
Db2 Sql2216n
Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre sql2216n sql error "-291" bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies http://www.ibm.com/support/knowledgecenter/SSNE44_4.2.0/com.ibm.tpc_V42.doc/fqz0_r_tbs_db2_sql_968.html Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken http://database.ittoolbox.com/groups/technical-functional/db2-l/sql2216n-error-code-968-while-reorganization-of-the-database-5439279 If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. SQL2216N Error Code '-968' while reorganization of the database prasadpande1990 asked Feb 28, 2014 | Replies (7) Hi All, I am not sure about this. I was performing the reorg and runstats on all the tables in my database through shell script. After reorg I am lowering the high water mark for one of the tablespace and then resizing it. But During the Reorg on one of table I got following issue which points that File System is Full. SQL2216N Error Code '-968' Before REORG I had 9G Memory in my filesystem. HOw come REORG operation consume so much amount of the memory. There are three tables in this tablespace data is around 50 lacs to 1.3 crores. Please help me to understand the background stuffs happened here. Join this group Best Answer Updated html error If you do not u
from GoogleSign inHidden fieldsSearch for groups or messages
help? Post your question and get tips & solutions from a community of 418,478 IT Pros & Developers. It's quick & easy. Cannot Reorganise any table in the tablespace P: n/a Rahul Babbar Hi, I am unable to reorganise the tables and get an error "SQL2216N SQL error "-968" occurred while reorganizing a database table or its indexes." Further, i find that all these tables belong to a tablespace and i cannot reorganise any tables in that tablespace. But, the tablespace has enough free space. What could be the reason for it and what should be done to fix it. Thanks a lot Rahul Sep 17 '07 #1 Post Reply Share this Question 2 Replies P: n/a kavallin Hi Rahul.. SQL0968C The file system is full.... pls check Tempspace, is it a DMS or SMS ? IF DMS, is it big enough ? IF SMS, do you have enough free space on the file system where the tempspace is ? /roger Sep 17 '07 #2 P: n/a Ian Rahul Babbar wrote: Hi, I am unable to reorganise the tables and get an error "SQL2216N SQL error "-968" occurred while reorganizing a database table or its indexes." Further, i find that all these tables belong to a tablespace and i cannot reorganise any tables in that tablespace. But, the tablespace has enough free space. Look in your db2diag.log to see which tablespace/container filled up and caused the issue; this will give you somewhere to start. Also you may want to look at the ulimit settings (fsize) for the instance owner. Sep 17 '07 #3 This discussion thread is closed Start new discussion Replies have been disabled for this discussion. Similar topics Restoring selected tables / table data error moving table to tablespace (8.0 beta win32 ) Change a table's tablespace Cannot alocate 2,4 GB for Bufferpools, DB v 8.2.1 on AIX 5L Table & Tablespace size tablespace scan, but not table scan Which tablespce is used when running ALTER TABLE & CREATE INDEX why the table create in different tablespace table record distribution query. Browse more DB2 Database Questions on Bytes Question stats viewed: 6744 replies: 2 date asked: Sep 17 '07 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us S