Chapter 11. Hints, tips and good to knows 511
If all table data is in a single tablespace, a tablespace can be dropped and redefined with
less overhead than dropping and redefining a table.
In general, a well-tuned set of DMS table spaces will outperform SMS table spaces.
In general, small personal databases are easiest to manage with SMS table spaces. On the
other hand, for large, growing databases, you will probably only want to use SMS table
spaces for the temporary table spaces, and separate DMS table spaces, with multiple
containers, for each table. In addition, you will probably want to store long field data and
indexes on their own table spaces.
11.2 DB2 installation known issues
If you update DB2 from an older version, say from DB2 7.2 to DB2 8.2, then TPC installer
does not recognize the DB2 version.
The workaround is:
1. Execute the following command in a DB2 environment (on Windows 2003 you can use
db2 update dbm cfg using JDK_PATH <DB2_InstallLocation>\java\jdk
db2 update dbm cfg using JDK_PATH "C:\PROGRAM Files\IBM\SQLLIB\java\jdk"
2. Start TPC V3.1 installer.
11.3 How to get rid of Engenio provider 5989 port
In the CIMOM discovery definition, deselect the Scan Local Subnet and specify the SLP DA
to be contacted.
11.4 DB2 view for CIMOM discovered each subsystem
The following DB2 view in Figure 11-1 is used to determine which CIMOM discovered each
Figure 11-1 DB2 view for CIMOM discovery of subsystems
11.5 Valid characters for user ID and passwords
This section lists possible valid characters for login sequences.
create view TPC.T_ITSO_CIMOM2SS (CIMOM_URL, SUBSYSTEM_ID) as (select
TPC.T_RES_REGISTERED_CIMOM.SERVICE_URL, TPC.T_RES_STORAGE_SUBSYSTEM.NAME from
TPC.T_RES_REGISTERED_CIMOM,TPC.T_RES_STORAGE_SUBSYSTEM where REG_CIMOM_ID =
(select CIMOM_ID from TPC.T_RES_CIMOM2NAMESPACE where CIM_NAMESPACE_ID =
(select distinct CIM_NAMESPACE_ID from TPC.T_RES_CIMKEY_SUBSYSTEM where