Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is it possible to specify custom tablespace names for Data Warehouse upgrade?

Questions
Tags
Users
Badges
Jason Fregien
(58●9●10) Oct 14 '13, 2:32 p.m.
When upgrading from 2.0.0.2 to 3.0.1.2, it appears like our Oracle DBA customized the Data Warehouse creation scripts to create all the tables in a custom tablespace name, and not in the default tablespaces -- VNF_IDX, VNF_32K, VSTR_IDX, VSTR_32K, RIS_TEMP.  

Now I'm trying to do an upgrade to 4.0.4, and am getting an error on the upgrade warehouse step since it's trying to create a new table in the "VNF_32K" tablespace, which doesn't exist.  Is there any way to specify custom tablespace names for the upgrade script to use?

0 votes

2 answers
4,533 views
0 votes

Accepted answer

Permanent link
Kot T.
JAZZ DEVELOPER (1.5k●1●13●19) edited
Oct 16 '13, 3:02 p.m.

Starting 4.0.3 (https://jazz.net/downloads/jazz-foundation/releases/4.0.3?p=news), it is possible to generate DDLs for DW upgrade (and also create)

See http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_gen_dw_upgradescripts.html&scope=null for upgrade

and...

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_gen_dw_ddlScripts.html&scope=null for DW creation

Jason Fregien selected this answer as the correct answer

1 vote

Comments
Jason Fregien
Oct 16 '13, 3:12 p.m.

Perfect.  Thanks for the info! 

One other answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) Oct 15 '13, 3:02 a.m.
Hi Jason,
There are couple of updates regarding that in version for. Look at this document https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup.

Let us know if it helps for you.

0 votes

Comments
Jason Fregien
Oct 15 '13, 1:10 p.m.

 Thanks for the reply, but I already know about this page.  It shows how to customize some of the settings on the user, tablespace, schema, but it does not say anything about being able to override the tablespace name that new tables get created in.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 267

Question asked: Oct 14 '13, 2:32 p.m.

Question was seen: 4,533 times

Last updated: Oct 16 '13, 3:12 p.m.

Confirmation Cancel Confirm