error running repotools.bat -createTables Db2 v9.1.5 RTC 2.0
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
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
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.
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.
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.
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.
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.
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.