Archive for the ·
· Category...
This PDF takes you through a sample configuration setup using DB2 UDB –
Abstract:This paper is intended for IBM Power Systems customers, IBM Technical Sales Specialists and consultants who are interested in learning more about the requirements involved in building and tuning an Oracle RDBMS system for optimal performance on AIX platform.
This white paper contains best practices which have been collected during the extensive period of time my team colleagues and I have spent working in the Oracle RDBMS based environment. It is focused on AIX versions 5.3, 6.1, 7.1 and Oracle 9i, 10g, 11g.
It begins with a short description of the most important Oracle DB architectural elements. It continues with an overview of the AIX-related tuning elements that are most crucial for optimal DB activity.
This document can be expanded into many different OS or DB-related directions. Additional information on related topics is included in the Appendix of this paper, as well as references to supporting documentation. However, this paper is not focused on the application tuning area. Application performance tuning is a subject too broad to be covered in a white paper of this length.
Download PDF:
This technote describes how to create a DB2® managed GPFS™ cluster using the db2cluster_prepare utility and how to clean the GPFS cluster manually from the DB2 pureScale™ environment.
Before you begin
About this task
In a DB2 pureScale environment, all data and logs must be on an IBM General Parallel File System (GPFS). You may need to create a DB2 managed GPFS cluster and file system. This can be done without an instance by using the db2cluster_prepare command.
Procedure
Perform these steps to create a DB2 managed GPFS cluster and file system on a host which has no previously existing GPFS cluster. This is the recommended method to setup a DB2 pureScale environment.
a. Use the db2cluster_prepare command to create a DB2 managed GPFS.
db2cluster_prepare -instance_shared_dev /dev/hdisk1
b. Verify the GPFS cluster exists using the following commands. For example:
/opt/IBM/db2/V9.8/instance/db2cluster –cfs –list –domain
/opt/IBM/db2/V9.8/bin/db2greg -dump
Example output:
V,GPFS_CLUSTER,NAME,db2cluster_20110331115346.in.ibm.com,-,DB2_CREATED
a. The db2greg command will fail if you already have a GPFS_CLUSTER variable record
in the global registry. You can remove the existing record using the following command:
db2greg -delvarrec service=GPFS_CLUSTER
b. Clean the GPFS from the system using the instructions in tech note 1447939
