IBM TotalStorage Productivity Center V3.1: The Next Generation

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

db2cmd).

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

subsystem.

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

SUBSYSTEM_ID= TPC.T_RES_STORAGE_SUBSYSTEM.SUBSYSTEM_ID)))