Filter
Top Products
running the metadata conversion. This directory will be used to store one text-based restart file,
various text-based db2 output files, and other text files.
Prior to performing the metadata conversion, become familiar with the conversion program output for
the HPSS 4.5 conversion in Section 6.5: HPSS 4.5 Conversion Utilities Output on page 232 or for
the HPSS 5.1 conversion in Section 6.3.15: Upgrade from HPSS 5.1 to HPSS 6.2 on page 213.
Should any of the conversion programs fail, they will exit with an error. To correct the error and
continue with the conversion, refer to Section 6.4: Metadata Conversion Troubleshooting Procedures
on page 227.
6.2.8. DB2 Configuration and Tuning (for 4.5 upgrades only)
The DB2 database configurations, that will store the converted 6.2 metadata, must be carefully
planned. In order to optimize the amount of time a conversion from HPSS 4.5 takes, it is essential
that DB2 be configured specifically for HPSS. Prior to performing the conversion, verify the
database configuration and make any needed adjustments. Refer to the sections below for examples
on how to check and update a database configuration settings. Additionally, we recommend running
several test metadata conversions to determine what DB2 settings might help or hinder performance
of the conversion utilities in your specific environment. Refer to Section 6.2.5: Testing the Metadata
Conversion on page 184. After running a metadata conversion and prior to placing the HPSS 6.2
system and DB2 databases in production, review the DB2 configuration settings that may affect the
performance of the HPSS system.
For more information on how to setup and tune DB2, refer to Section 5.3.2.6: Configure DB2
Services on page 165 and Section 5.7: Tune DB2 on page 171. For additional concerns about
configuring DB2 that are not addressed, see the latest version of the DB2 UDB Performance Tuning
Guide, an IBM redbook.
Checking Database Configuration Settings
To check database configuration setting, login as the database administrator or instance owner (e.g.
hpssdb), connect to each database and list its tables. DB2 commands are not case sensitive. To
connect and list tables:
% DB2 CONNECT TO CFG
% DB2 LIST TABLES FOR SCHEMA HPSS
% DB2 CONNECT RESET
% DB2 CONNECT TO SUBSYS1
% DB2 LIST TABLES FOR SCHEMA HPSS
% DB2 CONNECT RESET
Check the database manager configuration settings at the instance level. For example:
% DB2 GET DBM CFG
Check the database configuration settings at the database level. For example:
% DB2 GET DBM CFG FOR CFG
% DB2 GET DBM CFG FOR SUBSYS1
Updating the Database Configuration
To update the database configuration settings for any databases within an instance, become the
database administrator or instance owner, connect to the database and execute:
HPSS Installation Guide July 2008
Release 6.2 (Revision 2.0) 186