It's all about the answers!

Ask a question

error running repotools.bat -createTables Db2 v9.1.5 RTC 2.0


Rajasimhan Mandayam (3811144) | asked Jun 24 '09, 6:20 p.m.
JAZZ DEVELOPER
I have the latest RTC server 2.0 RC3

I ran repotools.bat -createTables

I ran it against a DB2 v9.1.500.555

The database I created was with the command

"CREATE DATABASE <databasename> ON <drive> USING CODESET UTF-8 TERRITORY en PAGESIZE 8 K"


Here is the output


D:\RTC-Server\jazz\server>repotools.bat -createTables teamserver.properties=conf
\jazz\teamserver.db2.win32.properties
Repo Tools

Provisioning using "D:\RTC-Server\jazz\server\conf\jazz\provision_profiles".
Rational Jazz Team Server - Standard
CRJAZ1363I Loading configuration from "file:conf\jazz\teamserver.db2.win32.prope
rties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //ramperfsrvr1.rtp.raleigh.ibm.com:50000/RTCDB4:user=xxxxxxx
x;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT64
Db Product Version: SQL09015
Db URL: jdbc:db2://ramperfsrvr1.rtp.raleigh.ibm.com:50000/RTCDB4
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
Creating the tables for the database "//ramperfsrvr1.rtp.raleigh.ibm.com:50000/R
TCDB4:user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts
can occur during periods of high server traffic. You should retry your operation
, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MO
DIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_
SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

CRJAZ0534I Failed to cleanup the failed creation of the "NUCLEUS" schema.
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts
can occur during periods of high server traffic. You should retry your operation
, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MO
DIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_
SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

The database tables were not created.

THis was in the repotool_createTables.log


2009-06-24 17:36:18,062 CRJAZ1363I Loading configuration from "file:conf\jazz\teamserver.db2.win32.properties".
2009-06-24 17:36:19,906 CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //ramperfsrvr1.rtp.raleigh.ibm.com:50000/RTCDB4:user=xxxxxxxx;password=xxxxxxxx;
2009-06-24 17:36:26,125 CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT64
Db Product Version: SQL09015
Db URL: jdbc:db2://ramperfsrvr1.rtp.raleigh.ibm.com:50000/RTCDB4
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
2009-06-24 17:36:26,671 CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
2009-06-24 17:36:28,015 Creating the tables for the database "//ramperfsrvr1.rtp.raleigh.ibm.com:50000/RTCDB4:user=xxxxxxxx;password=xxxxxxxx;" with indices.
2009-06-24 17:38:38,062 CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MODIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:679)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.b(fm.java:2132)
at com.ibm.db2.jcc.b.fm.c(fm.java:2115)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)
at com.ibm.db2.jcc.b.gm.e(gm.java:3287)
at com.ibm.db2.jcc.b.gm.Tb(gm.java:1901)
at com.ibm.db2.jcc.b.gm.execute(gm.java:1885)
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.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:226)
at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:114)
at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQueryOn(JdbcDB.java:103)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatement(JdbcDBBuilder.java:147)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:193)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:182)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.createIndices(JdbcDBBuilder.java:174)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.createIndices(PluggableJdbcDbBuilder.java:175)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.buildArtifactsFromCreateStatements(JdbcDBBuilder.java:202)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.buildArtifactsFromCreateStatements(PluggableJdbcDbBuilder.java:90)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchema(AbstractDatabaseService.java:388)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:321)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchemaForPackage(AbstractDatabaseService.java:191)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreatePackageSchemas(AbstractDatabaseService.java:178)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:171)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:115)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:110)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:100)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy5.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:267)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy36.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:96)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:87)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy57.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:67)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:115)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
2009-06-24 17:38:38,078 CRJAZ0534I Failed to cleanup the failed creation of the "NUCLEUS" schema.
java.lang.NullPointerException
at com.ibm.db2.jcc.b.fm.kb(fm.java:2542)
at com.ibm.db2.jcc.b.fm.a(fm.java:2505)
at com.ibm.db2.jcc.b.gm.a(gm.java:4429)
at com.ibm.db2.jcc.b.fm.P(fm.java:746)
at com.ibm.db2.jcc.b.gm.P(gm.java:4399)
at com.ibm.db2.jcc.b.hc.a(hc.java:7758)
at com.ibm.db2.jcc.b.hc.Zd(hc.java:6356)
at com.ibm.db2.jcc.b.hc.getSchemas(hc.java:6284)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.getSchemas(AbstractDbProvider.java:533)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.doesTableExist(AbstractDbProvider.java:283)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy4.doesTableExist(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.buildArtifactsFromCreateStatements(PluggableJdbcDbBuilder.java:97)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchema(AbstractDatabaseService.java:388)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:321)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchemaForPackage(AbstractDatabaseService.java:191)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreatePackageSchemas(AbstractDatabaseService.java:178)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:171)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:115)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:110)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:100)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy5.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:267)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy36.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:96)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:87)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy57.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:67)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:115)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
2009-06-24 17:38:42,281 CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MODIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

com.ibm.team.repository.common.RetryableDatabaseException: CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MODIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.AbstractErrLogWrapper.logAndReturnException(AbstractErrLogWrapper.java:99)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.StatementErrLogWrapper.logAndReturnException(StatementErrLogWrapper.java:66)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:67)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:226)
at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:114)
at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQueryOn(JdbcDB.java:103)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatement(JdbcDBBuilder.java:147)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:193)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:182)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.createIndices(JdbcDBBuilder.java:174)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.createIndices(PluggableJdbcDbBuilder.java:175)
at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.buildArtifactsFromCreateStatements(JdbcDBBuilder.java:202)
at com.ibm.team.repository.service.internal.rdb.PluggableJdbcDbBuilder.buildArtifactsFromCreateStatements(PluggableJdbcDbBuilder.java:90)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchema(AbstractDatabaseService.java:388)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAndSaveSchema(AbstractDatabaseService.java:321)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateSchemaForPackage(AbstractDatabaseService.java:191)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreatePackageSchemas(AbstractDatabaseService.java:178)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:171)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:115)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:110)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:100)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:466)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:292)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:328)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy5.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:288)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:267)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy36.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:96)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:87)
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:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy57.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.createTables(CreateTablesCommand.java:67)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:115)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:161)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:671)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:702)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
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:549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
at org.eclipse.equinox.launcher.Main.main(Main.java:1212)
Caused by:
com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:679)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.b(fm.java:2132)
at com.ibm.db2.jcc.b.fm.c(fm.java:2115)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.b.gm.Zb(gm.java:2445)
at com.ibm.db2.jcc.b.gm.e(gm.java:3287)
at com.ibm.db2.jcc.b.gm.Tb(gm.java:1901)
at com.ibm.db2.jcc.b.gm.execute(gm.java:1885)
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)
... 70 more

5 answers



permanent link
Rajasimhan Mandayam (3811144) | answered Jun 24 '09, 11:17 p.m.
JAZZ DEVELOPER
Looking at the error codes and searching for it online.

SQL Message: DB2 SQL Error: SQLCODE=-973,
SQLSTATE=57011,
SQLERRMC=APP_CTL_HEAP_SZ,


The error code implies that Virtual storage or database resource is not available.



Apparently for Db2 9.1, when you create the database the value of the parameter APP_CTL_HEAP_SZ is set to 128.

I found that I had to set it to at least 256 for repotools to work

though I read on the db2 help for 9.1 recommend that this be set to atleast 1024 for db2 spatial extender applications, not sure if repotools is such an application (http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.spatial.doc/cfgappctlheap.html)


Steps taken to resolve problem
------------------------------------
1. run the command

UPDATE DATABASE CONFIGURATION FOR db_name USING APP_CTL_HEAP_SZ 256

2. stop & start db2 for the value to take effect


3. run repotools -createTables again.


Maybe, this should be documented in the RTC install guide when creating db2 v9.1 database.

permanent link
Andrei Kirshin (3642) | answered Jul 01 '09, 6:16 a.m.
I had the same problem. Thank you for the solution.

permanent link
Steve Viens (61175) | answered Jul 02 '09, 3:00 p.m.
We're having the same issue but I've confirmed that our APP_CTL_HEAP_SZ is set to 4KB. Any other ideas?

Steve

$ ./repotools.sh -createTables
Repo Tools
Jazz Foundation Server, Version 1.0 (I20090618-1753)
Rational Team Concert, Version 2.0 (I20090618-1753)

Provisioning using "./conf/jazz/provision_profiles".
Rational Jazz Team Server - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //t002ppmdb:60096/jazz:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09015
Db URL: jdbc:db2://t002ppmdb:60096/jazz
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
Creating the tables for the database "//t002ppmdb:60096/jazz:user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MODIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

CRJAZ0534I Failed to cleanup the failed creation of the "NUCLEUS" schema.
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: CREATE INDEX NUCLEUS.TRTN_PLNRCRDMDFDDX ON NUCLEUS.ITERATION_PLAN_RECORD(MODIFIED)
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=APP_CTL_HEAP_SZ, DRIVER=3.53.70
SQL State: 57011
Error Code: -973

The database tables were not created.

permanent link
Steve Viens (61175) | answered Jul 02 '09, 3:24 p.m.
Strange, we set the APP_CTL_HEAP_SZ down to 256 and the script ran successfully. Thanks for posting the solution.

Steve

permanent link
Rajasimhan Mandayam (3811144) | answered Jul 07 '09, 12:04 p.m.
JAZZ DEVELOPER
I think the jazz team is aware of this problem (i remember seeing some work items ). The problem happens the first time you run repotools
at which time DB2 automatically bumps up the value of APP_CTL_HEAP_SIZE but the value is applied only after the database is restarted and if that happens, you may see repotools run successfully the 2nd time around.

Your answer


Register or to post your answer.