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

Page 186
Image 186
IBM HPSS manual 8. DB2 Configuration and Tuning for 4.5 upgrades only, Checking Database Configuration Settings