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>