Can I change the Insight 1.1.1 database temp tablespace locations?
Tablespace ID = 3
Name = CTEMPSPACE32K
Type = System managed space
Contents = System Temporary data
State = 0x0000
Tablespace Containers for Tablespace 3
Container ID = 0
Name = C:\Documents and Settings\Administrator\
RICM5\ctempspace32k
Type = Path
One answer
On the pages in the setup where you specify the details for the content store and the data warehouse their should be a field to specify the tablespace location.
Regards,
Ali
Comments
Thanks Ali. You are right when "Set up Rational Insight" is selected from the Rational Reporting setup wizard. However, if "Evaluation" is selected, there is no option to specify the table space location. And I agree that for an Evaluation install, specifying the table space location is probably unnecessary. However, the choice of the default location Insight is using in an Evaluation install could be improved. If I create a database via the DB2 command line, "create db temp", DB2 does not create the temp table spaces in the same location Insight is, which would seem to indicate Insight is explicitly choosing "C:\Documents and Settings\Administrator". A better choice would be to do what DB2 does by default, or even using the system's TEMP environment variable.
Is there a file I can modify to force Insight to use a different directory for the table space when going through the Evaluation setup?