It's all about the answers!

Ask a question

createTables in DB2


Dana Cleveland (142) | asked Jan 10 '08, 1:49 p.m.
retagged May 29 '13, 2:24 a.m. by Krzysztof Ka┼║mierczyk (7.4k35499)
I have been attempting to build the tables in our test UDB environment and seen to get the same error. It works in my local v9.1 copy of UDB Express. I know its v9 just not sure what version after that..

The error seems to refer to the use of deprecated user functions that seem to exist in my local database/environment but no in our distributed/shared UDB environment.
>>
SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092 Reason code or token: DBADMIN
<<

I'm using Beta2


Any ideas? How I can get around this..


D:\jazz\server>repotools -createTables
Repo Tools, Version 0.6.0.I20071214-0415
Loading configuration from file:.\teamserver.properties
Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09013
Db Name/Location: //tosa-udbtest:52020/TSPJAZT1:fullyMaterializeLobData=false;
user=xxxxxxxx;password=xxxxxxxx;
Unable to wrap service com.ibm.team.repository.service.IMailerService because th
e component id of service implementation com.ibm.team.workitem.service.internal.
save.notify.ChangeEventMailNotifier is not known
Creating tables for database "//tosa-udbtest:52020/TSPJAZT1:fullyMaterializeLobD
ata=false;user=xxxxxxxx;password=xxxxxxxx;" with indices.
Failed to update DB2 configuration options
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -1092, SQLSTATE: ,
SQLERRMC: DBADMIN
at com.ibm.db2.jcc.b.zc.d(zc.java:1351)
at com.ibm.db2.jcc.a.db.l(db.java:366)
at com.ibm.db2.jcc.a.db.e(db.java:102)
at com.ibm.db2.jcc.a.r.e(r.java:72)
at com.ibm.db2.jcc.a.sb.i(sb.java:194)
at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
at com.ibm.db2.jcc.b.ad.W(ad.java:1276)
at com.ibm.db2.jcc.b.ad.execute(ad.java:1260)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.Prepare
dStatementStatWrapper.execute(PreparedStatementStatWrapper.java:52)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.Prepa
redStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.Prepare
dStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:51)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.updateDat
abaseConfig(Db2Provider.java:113)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDb
ForInitialization(Db2Provider.java:135)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
internalRebuildAllSchemas(DatabaseCreationService.java:111)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
access$0(DatabaseCreationService.java:108)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$
3.run(DatabaseCreationService.java:98)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService$
ConnectionRunnable.run(AbstractDatabaseService.java:80)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans
action.run(RepositoryDatabase.java:449)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr
ansaction(RepositoryDatabase.java:263)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runEx
clusive(RepositoryDatabase.java:241)
at com.ibm.team.repository.service.internal.TransactionService.runExclus
ive(TransactionService.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:324)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:316)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.
invoke(ExportProxyServiceRecord.java:106)
at $Proxy22.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
doRebuildSchemas(DatabaseCreationService.java:94)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
rebuildAllSchemas(DatabaseCreationService.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:324)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:316)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.
invoke(ExportProxyServiceRecord.java:106)
at $Proxy38.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.CreateTablesApplicationModel.crea
teTables(CreateTablesApplicationModel.java:120)
at com.ibm.team.repotools.rcp.internal.CreateTablesApplicationModel.run(
CreateTablesApplicationModel.java:167)
at com.ibm.team.repotools.rcp.internal.ApplicationModel.run(ApplicationM
odel.java:399)
at com.ibm.team.repotools.rcp.RepositoryToolsApplication.run(RepositoryT
oolsApplication.java:605)
at com.ibm.team.repotools.rcp.RepositoryToolsApplication.start(Repositor
yToolsApplication.java:637)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandl
e.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runAppli
cation(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(Ec
lipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
at org.eclipse.equinox.launcher.Main.main(Main.java:1148)
Error querying tablespace size
com.ibm.team.repository.common.TeamRepositoryException: Error querying tablespac
e size
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCre
ateNewContentTablespace(Db2Provider.java:215)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDb
ForInitialization(Db2Provider.java:160)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
internalRebuildAllSchemas(DatabaseCreationService.java:111)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
access$0(DatabaseCreationService.java:108)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$
3.run(DatabaseCreationService.java:98)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService$
ConnectionRunnable.run(AbstractDatabaseService.java:80)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Trans
action.run(RepositoryDatabase.java:449)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTr
ansaction(RepositoryDatabase.java:263)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runEx
clusive(RepositoryDatabase.java:241)
at com.ibm.team.repository.service.internal.TransactionService.runExclus
ive(TransactionService.java:87)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:324)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:316)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.
invoke(ExportProxyServiceRecord.java:106)
at $Proxy22.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
doRebuildSchemas(DatabaseCreationService.java:94)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.
rebuildAllSchemas(DatabaseCreationService.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in
voke(ExportProxyServiceRecord.java:324)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.ac
cess$0(ExportProxyServiceRecord.java:316)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$1.
invoke(ExportProxyServiceRecord.java:106)
at $Proxy38.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.rcp.internal.CreateTablesApplicationModel.crea
teTables(CreateTablesApplicationModel.java:120)
at com.ibm.team.repotools.rcp.internal.CreateTablesApplicationModel.run(
CreateTablesApplicationModel.java:167)
at com.ibm.team.repotools.rcp.internal.ApplicationModel.run(ApplicationM
odel.java:399)
at com.ibm.team.repotools.rcp.RepositoryToolsApplication.run(RepositoryT
oolsApplication.java:605)
at com.ibm.team.repotools.rcp.RepositoryToolsApplication.start(Repositor
yToolsApplication.java:637)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandl
e.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runAppli
cation(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(Ec
lipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
at org.eclipse.equinox.launcher.Main.main(Main.java:1148)
Caused by:
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, S
QLERRMC: SNAPSHOT_TBS_CFG;*SHOT_TBS_CFG;SQL1092 Reason code or token: DBADMIN
at com.ibm.db2.jcc.b.rc.c(rc.java:347)
at com.ibm.db2.jcc.b.rc.next(rc.java:277)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.ResultSetStatWrapper.next(ResultSetStatWrapper.java:444)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.ResultSetErrLogWrapper.next(ResultSetErrLogWrapper.java:890)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.ResultSetLeakWrapper.next(ResultSetLeakWrapper.java:397)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.getContentTablespaceSize(Db2Provider.java:328)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewContentTablespace(Db2Provider.java:201)
... 45 more
D:\jazz\server>

One answer



permanent link
Shawn Lauzon (38174) | answered Jan 10 '08, 2:04 p.m.
Well, the -1092 error seems to be an authorization problem:

SQL1092N "<authorization-ID>" does not have the authority to
perform the requested command.

You should make sure your user has the ability to create tables.

shawn.

Your answer


Register or to post your answer.