It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788

question asked: May 28 '08, 7:18 a.m.
question was seen: 7,352 times
last updated: May 28 '08, 7:18 a.m.

Related questions

FAQ - How this Forum works

Creating the db tables fails with db2 err -970

0
Yan Liang (6●2) | asked May 28 '08, 7:18 a.m.
I just installed the TC according to the installation manual. After creating the Jazz db, and modify the teamserver.properties file, I tried to run: 
repotools -createTables

However, I got the error message: 
CRJAZ0256I Exception occurred creating content tablespace


Could anyone help me? Thanks.

Log: 

com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0256I Exception occurred creating content tablespace

	at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.internalCreateContentTablespace(Db2Provider.java:231)

	at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:211)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:618)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)

	at $Proxy5.prepareDbForInitialization(Unknown Source)

	at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:112)

	at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:109)

	at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:99)

	at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService$ConnectionRunnable.run(AbstractDatabaseService.java:101)

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)

	at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)

	at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:84)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:618)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)

	at $Proxy30.runExclusive(Unknown Source)

	at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:95)

	at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:86)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:618)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)

	at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)

	at $Proxy48.rebuildAllSchemas(Unknown Source)

	at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:55)

	at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:93)

	at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:162)

	at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:593)

	at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:627)

	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)

	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)

	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)

	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)

	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	at java.lang.reflect.Method.invoke(Method.java:618)

	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)

	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)

	at org.eclipse.equinox.launcher.Main.run(Main.java:1173)

	at org.eclipse.equinox.launcher.Main.main(Main.java:1148)

Caused by: 

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -970, SQLSTATE: 55009, SQLERRMC: null

	at com.ibm.db2.jcc.c.kh.b(kh.java:1367)

	at com.ibm.db2.jcc.c.kh.c(kh.java:1354)

	at com.ibm.db2.jcc.b.db.k(db.java:352)

	at com.ibm.db2.jcc.b.db.a(db.java:60)

	at com.ibm.db2.jcc.b.t.a(t.java:52)

	at com.ibm.db2.jcc.b.tb.b(tb.java:202)

	at com.ibm.db2.jcc.c.lh.X(lh.java:1842)

	at com.ibm.db2.jcc.c.lh.d(lh.java:2411)

	at com.ibm.db2.jcc.c.lh.U(lh.java:1401)

	at com.ibm.db2.jcc.c.lh.execute(lh.java:1385)

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)

	at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)

	at com.ibm.team.repository.service.db.provider.AbstractDbProvider.executeStatement(AbstractDbProvider.java:375)

	at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.executeStatement(Db2Provider.java:384)

	at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.createContentTablespace(Db2Provider.java:265)

	at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.internalCreateContentTablespace(Db2Provider.java:229)

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Dmitry Karasik (1.8k●1●1) | answered May 28 '08, 7:18 a.m.
JAZZ DEVELOPER
On Wed, 28 May 2008 11:28:00 +0000, yanliang wrote:

org.eclipse.equinox.launcher.Main.main(Main.java:1148) Caused by:
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -970, SQLSTATE:
55009, SQLERRMC: null


SQL0970N The system attempted to write to a read-only file.


There is something wrong with your DB2 setup.

- Dmitry
0
permanent link
Aaron Cohen (820●78●51) | answered May 28 '08, 12:51 p.m.
JAZZ DEVELOPER
Can you take TC out of the equation and try to create a database & table
manually with that user and the specified tablespace location. This may
be a DB2 issue. I know I ran into similar errors where I did not have
permission to write to the tablespace location.

yanliang wrote:
I just installed the TC according to the installation manual. After
creating the Jazz db, and modify the teamserver.properties file, I
tried to run:
repotools -createTables
However, I got the error message:
CRJAZ0256I Exception occurred creating content
tablespace


Could anyone help me? Thanks.

Log:

com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0256I
Exception occurred creating content tablespace
	at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.internalCreateContentTablespace(Db2Provider.java:231)
	at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:211)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:618)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
	at $Proxy5.prepareDbForInitialization(Unknown Source)
	at
com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:112)
	at
com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:109)
	at
com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:99)
	at
com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService$ConnectionRunnable.run(AbstractDatabaseService.java:101)
	at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:455)
	at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:286)
	at
com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:264)
	at
com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:84)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:618)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
	at $Proxy30.runExclusive(Unknown Source)
	at
com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:95)
	at
com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:86)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:618)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:375)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:361)
	at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:55)
	at $Proxy48.rebuildAllSchemas(Unknown Source)
	at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:55)
	at
com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:93)
	at
com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:162)
	at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:593)
	at
com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:627)
	at
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
	at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
	at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
	at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
	at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:618)
	at
org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
	at
org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
	at
org.eclipse.equinox.launcher.Main.main(Main.java:1148)
Caused by:
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE:
-970, SQLSTATE: 55009, SQLERRMC: null
	at com.ibm.db2.jcc.c.kh.b(kh.java:1367)
	at com.ibm.db2.jcc.c.kh.c(kh.java:1354)
	at com.ibm.db2.jcc.b.db.k(db.java:352)
	at com.ibm.db2.jcc.b.db.a(db.java:60)
	at com.ibm.db2.jcc.b.t.a(t.java:52)
	at com.ibm.db2.jcc.b.tb.b(tb.java:202)
	at com.ibm.db2.jcc.c.lh.X(lh.java:1842)
	at com.ibm.db2.jcc.c.lh.d(lh.java:2411)
	at com.ibm.db2.jcc.c.lh.U(lh.java:1401)
	at com.ibm.db2.jcc.c.lh.execute(lh.java:1385)
	at
com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
	at
com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
	at
com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
	at
com.ibm.team.repository.service.db.provider.AbstractDbProvider.executeStatement(AbstractDbProvider.java:375)
	at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.executeStatement(Db2Provider.java:384)
	at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.createContentTablespace(Db2Provider.java:265)
	at
com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.internalCreateContentTablespace(Db2Provider.java:229)
0
permanent link
Yan Liang (6●2) | answered Jun 04 '08, 6:03 a.m.
:( My system is Windows XP, and I'm sure the user "db2admin" have the access right to driver C. I could create db and tablespaces manually.

:) Actually, I resolved it by changing the command of creating db 
db2 create database JAZZ on c: using codeset UTF-8 territory en
to 
db2 create database JAZZ using codeset UTF-8 territory en

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.