Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Creating the db tables fails with db2 err -970

Questions
Tags
Users
Badges
Yan Liang
(6●2) 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)

0 votes

3 answers
7,890 views
0 votes

3 answers

Permanent link
Dmitry Karasik
JAZZ DEVELOPER (1.8k●1●1) May 28 '08, 7:18 a.m.
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 votes

Permanent link
Aaron Cohen
JAZZ DEVELOPER (820●78●51) May 28 '08, 12:51 p.m.
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 votes

Permanent link
Yan Liang
(6●2) 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

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: May 28 '08, 7:18 a.m.

Question was seen: 7,890 times

Last updated: May 28 '08, 7:18 a.m.

Confirmation Cancel Confirm