It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×267
×83

question asked: Nov 16 '12, 4:00 a.m.
question was seen: 3,967 times
last updated: Nov 19 '12, 4:44 a.m.

Related questions

FAQ - How this Forum works

Upgrade server and database from RTC 2.0.0.2 to RTC 4.0 Fail in Step 3

0
Eric Leung (11●1●1) | asked Nov 16 '12, 4:00 a.m.
Got fail in step 3 during the upgrade, i have granted all privilege to the account - db2admin, but still got the error, is there anyway to trace what privilege is needed.

Here is the log:
2012-11-16 15:24:39,425 Repo Tools
2012-11-16 15:24:39,425 java.version=1.5.0
2012-11-16 15:24:39,425 java.runtime.version=pwa64dev-20120810 (SR14 )
2012-11-16 15:24:39,425 Provisioning using "C:\Program Files (x86)\IBM\JazzTeamServer\server\conf\jts\provision_profiles".
2012-11-16 15:24:39,456 repotools-jts -migration_importJTSData createMappingFile=C:\Program Files (x86)\IBM\JazzTeamServer\server\appli-mapping.txt createTables fromFile=C:\Program Files (x86)\IBM\JazzTeamServer\server\jtsData.tar
2012-11-16 15:24:39,456   Jazz Foundation - Core Libraries, Version 3.0.1.5 (RJF-I20121026-1636)

2012-11-16 15:24:39,472 CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".
2012-11-16 15:24:39,472
2012-11-16 15:24:40,064 CRJAZ1779I This server is configured as a JTS.
2012-11-16 15:24:40,064 CRJAZ1971I The server is configured with:
  Public URI: "https://localhost:9443/jts"
2012-11-16 15:24:42,233 CRJAZ1365I The server is attempting to connect to the following database: "//localhost:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;"
2012-11-16 15:24:42,576 CRJAZ1364I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL09074
  Db URL: jdbc:db2://localhost:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.57.82
2012-11-16 15:24:43,028 CRJAZ8192I: Fulltext Index Location: C:\Program Files (x86)\IBM\JazzTeamServer\server\conf\jts\indices\workitemindex\fulltext_index
2012-11-16 15:24:43,028 CRJAZ8190I: The fulltext index should point to an absolute directory but is currently set to 'conf/jts/indices/workitemindex'
2012-11-16 15:24:43,216 Creating the tables for the database "//localhost:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;" without indices.
2012-11-16 15:24:43,325 CRJAZ1245I The database user does not have the required privileges to perform the specified operation. Check with your database administrator or your database vendor product documentation and ensure the user account has appropriate authority to read, write, and administer tables.
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-1092, SQLSTATE=     , SQLERRMC=DB2ADMIN, DRIVER=3.57.82
    at com.ibm.db2.jcc.am.bd.a(bd.java:679)
    at com.ibm.db2.jcc.am.bd.a(bd.java:60)
    at com.ibm.db2.jcc.am.bd.a(bd.java:127)
    at com.ibm.db2.jcc.am.km.b(km.java:2164)
    at com.ibm.db2.jcc.am.km.c(km.java:2147)
    at com.ibm.db2.jcc.t4.db.k(db.java:354)
    at com.ibm.db2.jcc.t4.db.e(db.java:96)
    at com.ibm.db2.jcc.t4.t.e(t.java:81)
    at com.ibm.db2.jcc.t4.sb.j(sb.java:160)
    at com.ibm.db2.jcc.am.km.hb(km.java:2113)
    at com.ibm.db2.jcc.am.lm.b(lm.java:3589)
    at com.ibm.db2.jcc.am.lm.Yb(lm.java:2130)
    at com.ibm.db2.jcc.am.lm.execute(lm.java:2114)
    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.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:193)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.configureDb(Db2Provider.java:294)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:287)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy56.prepareDbForInitialization(Unknown Source)
    at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:114)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:112)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:102)
    at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
    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:458)
    at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
    at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy58.withCurrentConnection(Unknown Source)
    at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
    at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259)
    at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy92.runExclusive(Unknown Source)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:98)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:89)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy116.rebuildAllSchemas(Unknown Source)
    at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.createTables(CreateTablesCommand.java:89)
    at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.execute(CreateTablesCommand.java:194)
    at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
    at com.ibm.team.repotools.commands.local.internal.ImportCommand.createTables(ImportCommand.java:90)
    at com.ibm.team.repotools.commands.local.internal.ImportCommand.execute(ImportCommand.java:120)
    at com.ibm.team.repotools.commands.local.internal.ImportJTSDataCommand.execute(ImportJTSDataCommand.java:91)
    at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
    at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
    at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
    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:368)
    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:619)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
2012-11-16 15:24:43,372 CRJAZ0258I Error querying tablespace size.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0258I Error querying tablespace size.
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewTablespace(Db2Provider.java:466)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewDataTablespace(Db2Provider.java:447)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.createTablespaces(Db2Provider.java:336)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:290)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy56.prepareDbForInitialization(Unknown Source)
    at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:114)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:112)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:102)
    at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
    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:458)
    at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
    at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy58.withCurrentConnection(Unknown Source)
    at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
    at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259)
    at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy92.runExclusive(Unknown Source)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:98)
    at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:89)
    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:619)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
    at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
    at $Proxy116.rebuildAllSchemas(Unknown Source)
    at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.createTables(CreateTablesCommand.java:89)
    at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.execute(CreateTablesCommand.java:194)
    at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
    at com.ibm.team.repotools.commands.local.internal.ImportCommand.createTables(ImportCommand.java:90)
    at com.ibm.team.repotools.commands.local.internal.ImportCommand.execute(ImportCommand.java:120)
    at com.ibm.team.repotools.commands.local.internal.ImportJTSDataCommand.execute(ImportJTSDataCommand.java:91)
    at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
    at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
    at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
    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:368)
    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:619)
    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
    at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
    at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSPROC.SNAPSHOT_TBS_CFG;SNAPSHOT_TBS_CFG;, DRIVER=3.57.82
    at com.ibm.db2.jcc.am.bd.a(bd.java:679)
    at com.ibm.db2.jcc.am.bd.a(bd.java:60)
    at com.ibm.db2.jcc.am.bd.a(bd.java:127)
    at com.ibm.db2.jcc.am.zl.b(zl.java:3760)
    at com.ibm.db2.jcc.am.zl.a(zl.java:3742)
    at com.ibm.db2.jcc.t4.db.a(db.java:792)
    at com.ibm.db2.jcc.t4.db.m(db.java:762)
    at com.ibm.db2.jcc.t4.db.i(db.java:245)
    at com.ibm.db2.jcc.t4.db.c(db.java:53)
    at com.ibm.db2.jcc.t4.t.c(t.java:44)
    at com.ibm.db2.jcc.t4.sb.i(sb.java:147)
    at com.ibm.db2.jcc.am.km.gb(km.java:1985)
    at com.ibm.db2.jcc.am.lm.b(lm.java:3576)
    at com.ibm.db2.jcc.am.lm.Vb(lm.java:654)
    at com.ibm.db2.jcc.am.lm.executeQuery(lm.java:628)
    at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
    at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
    at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.getTablespaceSize(Db2Provider.java:587)
    at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewTablespace(Db2Provider.java:453)
    ... 71 more
2012-11-16 15:24:43,372 The database tables were not created.
2012-11-16 15:24:45,758 The data will not be imported.

5 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered Nov 16 '12, 5:29 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Can you provide more details about what you do?

This is especially important because I am not sure which step you mean going to which version, since the documentation e.g. the interactive upgrade guide clearly states that if you want to upgrade from 2.x to 4.x you have to upgrade 2.x to 3.x and then upgrade 3.x to 4.x.
0
permanent link
Eric Leung (11●1●1) | answered Nov 18 '12, 7:55 p.m.
I am upgrading from 2.0.0.1 to 3.0.1.15 following the instruction in infocenter, the command i used is: 
upgrade\ccm_upgrade.bat -oldApplicationHome <RTC2.x_install_dir>\server\conf -createJTSTables
the first 2 steps is fine, but in steps 3, it prompt me with the above error.

Many Thanks.
0
permanent link
YOGESH LOKHANDE (104●4●19●27) | answered Nov 19 '12, 12:17 a.m.
 Hi Eric 

      If you have error on database configuration step then do this.
1.open control center od DB2 
2.go to databases 
3.select your Database and right click on it .
4.there is option authenticat 
5.go there and add your user as administrator and grant all permission to it.

for DB2 only
0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered Nov 19 '12, 2:05 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I would suggest to follow: https://jazz.net/library/article/662

You can grant permissions using

db2 connect to JTS
db2 grant dbadm on database to user db2admin
db2 disconnect JTS

I hope this is a test/demo system, the public URI is not a good choice. I would suggest not to use localhost, not even for demo systems.
0
permanent link
Eric Leung (11●1●1) | answered Nov 19 '12, 2:16 a.m.
I have tried "Grant All", but also fail at the same location. Do you think I need to change localhost to IP or hostname?

Thanks.



Comments
Ralph Schoon commented Nov 19 '12, 4:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Did you run the statements above for the user that is used to connect to the DB?
The localhost won't help with the problem above, I think.

Your answer

Register or to post your answer.


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