Db2 Sql Error Sqlcode=-968 Sqlstate=57011
Contents |
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can
Db2 Sql Error Sqlcode 964 Sqlstate 57011 Sqlerrmc Null Driver 3.58 82
post: click the register link above to proceed. To start viewing
Db2 Sqlcode 904 Sqlstate 57011
messages, select the forum that you want to visit from the selection below. Results 1 to 2 of db2 sqlcode 289 sqlstate 57011 2 Thread: SQL Message: SQL2216N SQLerror "-968" occurred while reorganizing Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch http://www.ibm.com/support/knowledgecenter/SSATW2_7.3.0/com.ibm.ituam.doc_7.3/troubleshooting/t_exception_db2_sql_error_sqlcode_-964.html to Hybrid Mode Switch to Threaded Mode 05-27-08,17:23 #1 kulesal View Profile View Forum Posts Registered User Join Date May 2008 Posts 1 Unanswered: SQL Message: SQL2216N SQLerror "-968" occurred while reorganizing Hi all, I am a pretty new to DB2 and I need help. Reorg process of one of the tables failed with this error message: Reorg_Table: SQL http://www.dbforums.com/showthread.php?1630725-SQL-Message-SQL2216N-SQLerror-quot-968-quot-occurred-while-reorganizing Message: SQL2216N SQLerror "-968" occurred while reorganizing. The table that I tried to reorg is over 12GB of size and it was offline reorg with using temporary table space. Did it fail because of insufficient size of the temporary table space? And if 'Yes' then what needs to be done to fix the problem? Thank you in advance, Alex Reply With Quote 05-27-08,19:40 #2 n_i View Profile View Forum Posts Visit Homepage :-) Join Date Jun 2003 Location Toronto, Canada Posts 5,516 Provided Answers: 1 Code: SQL0968C The file system is full. Explanation: One of the file systems containing the database is full. This file system may contain the database directory, the database log files, or a table space container. The statement cannot be processed. User response: Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may be necessary to drop tables and indexes identified as not required. On unix-based systems, this disk full condition may be due to exceeding the maximum file size allowed
×35,544 clm ×4,217 configuration ×4,123 db2 ×62 database ×59 ccm ×30 sql-error ×4 automatic-storage ×1 Asked: Feb 19 '13, 1:41 a.m. Seen: 5,519 times Last updated: Feb 20 '13, 3:11 a.m. https://jazz.net/forum/questions/103138/clm-install-error-database-creation-sql-error-968 Related questions Sizing for derby before DB2 Error configuring DB2 express-C edition with Jazz Team Server Converting from Oracle 10 -> Oracle 11 Problem with migration using JTS 4.0.3 on Rational Team Concert 4.0 Extensions Workshop Port 50000 fails to connect and error CRJAZ1579E on database configuration page. Need Instructions for migrating CLM database from DB2 on AIX to DB2 on Linux 6.0.1 evaluation db2 sql install errors. WAS Liberty and CLM RAM. No Longer have Administrator access after changing LDAP Domains (xyz.com to abc.com) Sharing a work item between projects FAQ - How this Forum works CLM Install error - Database Creation (SQL Error 968) 1 Chris Hardy (36●4●12●19) | asked Feb 19 '13, 1:41 a.m. edited Feb 19 '13, 10:46 p.m. Hi I am trying to install CLM 4.0.1 db2 sql error with WAS 8.0.0.3 and DB2 9.7 When running through the custom set up I get as far as trying to create the CCM tables when I get the following error. The crux of the error is the sql error code 968 Now Ive spoken to the DB admin person and their opinion is that the way in which the DB2 database creation scripts are working is flawed and is max- ing out their database server disk(?) space The DB admin guy seems to think that the scripts could be modified to get around this, but I'm not sure how or if we should do this ( would this be supported??) (Sorry but not being a DB person the terminology is a bit beyond me!!) Any help would be appreciated: Error Message: The database creation failed with an exception com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A database connection error occurred. CRJAZ0265I The virtual storage or database resource is not available. SQL: CREATE LARGE TABLESPACE CONTENTTS MANAGED BY DATABASE USING (file 'jazzdata' 250000) AUTORESIZE YES DROPPED TABLE RECOVERY OFF SQL Exception #1 SQL Message: DB2 SQL Error: SQLCODE=-968, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.14.88 SQL State: 57011 Error Code: -968 at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractEr