############### Begin Standard Header - Do not add comments here ###############
# 
# File:     %W%
# Version:  %I%
# Modified: %G% %U%
# Build:    %R% %L%
# 
# Licensed Materials - Property of IBM
# 
# Restricted Materials of IBM
# 
# 5724-M19
# 
# (C) COPYRIGHT IBM CORP. 2008.  All Rights Reserved.
# 
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
# 
############################# End Standard Header ##############################
################################################################################
#
# Defect   Name       Date         Description
# -------  ---------  ----------   -----------------------------------------------
# 218133   rbs        03/24/08     Create.
# 221947   rbs        08/18/08     Fix typo
############################## End Change History ##############################

The db2tuning scripts are optional scripts that will make database configuration 
changes based on recommendations of the Maximo database team.  The configuration 
parameters will not be ideal for all environments and can be modified for your 
particular configuration and workload.

The values provided can be modified by editing the appropriate script.  Note: it is 
recommended that you make a backup copy of the original script prior to modification.

The script must be run by a user with database administration authority.

Syntax: 
  Windows:    db2tuning.cmd [ dbName [ dbInstance ] ]
  Unix:       db2tuning.sh [ dbName [ dbInstance ] ]

  If the dbName is not provided, it will default to MAXDB71
  If the dbInstance is not provided it will default to ctginst1.  If a database 
    instance other than the default is needed, the dbName must also be provided.

The following database configuration parameters will be set by default:

DFT_QUERYOPT 2
LOCKLIST 15000 DEFERRED
MAXLOCKS 60
PCKCACHESZ 12600
DBHEAP 2000
CATALOGCACHE_SZ 800
LOGBUFSZ 256
UTIL_HEAP_SZ 10000
APP_CTL_HEAP_SZ 16384 DEFERRED
STMTHEAP 16384
APPLHEAPSZ 2048
STAT_HEAP_SZ 8196
CHNGPGS_THRESH 40
MAXFILOP 200
LOGFILSIZ 2048 DEFERRED
LOGPRIMARY 10
LOGSECOND 15 DEFERRED

The following database manager configuration parameters will also be set:

PRIV_MEM_THRESH 32767
NUMDB 2