DB2 software requirements gathering for a new server

14 June,2011 by Jack Vamvas

DB2 software requirements gathering for a new server is important for planning a DB2 server deployment.

I use this DB2 software requirements gathering template  to elicit requirements.

The template is designed to record and maintain the initial consultation. It is important for me , to keep this stage smooth and stress-free. By working through a checklist – both I and the requestor establish a starting point.

 Once the information is gathered , I present this to the wider DBA team – and depending the details and analysis process occurs. This could lead to further meetings with the requestor – drilling-down into certain points .

 

Type

Requirement Description

Requirement Results

Business App

Name of business applications

 

App Owner

Name of the Owner of this instance (approve changes etc)

 

 

 

 

Server Roles

Names of relational or OLTP databases required

 

Server Roles

Names of data warehouse databases required

 

 

 

 

Maintenance

What Backup Schedule ?

 

Maintenance

Is monitoring required ?

 

 

 

 

Database Engine

Name of Server if know

 

Database Engine

Name of Instance if know

 

Database Engine

Disk storage requirements

 

Database Engine

IOPS and throughput requirements

 

Database Engine

Database in new or existing instance?

 

Database Engine

Will instance reside on existing server with DB2 or new server?

 

Database Engine

Number of servers required to support scale-out options, if selected

 

Database Engine

Number of servers required to support fault-tolerance option, if selected

 

Database Engine

Failover clustering protection required?

 

Database Engine

In which office or geographical location will instance be placed?

 

Database Engine

Will instance be on physical server or virtualized environment?

 

Database Engine

Number of CPUs required

 

Database Engine

Required architecture

 

Database Engine

Required processor speed

 

Database Engine

Amount of memory required

 

Database Engine

Disk subsystem configuration

 

Database Engine

Number of network adapters

 

Database Engine

What version of DB2?

 

Database Engine

Data drives ?

 

Database Engine

Log Drives ?

 

 

 

 

Security Management(DB2)

Do you require DB2 login

 

 

Whats Rights Does the DB2 login's require

 

Security Management(AD)

What AD groups require access

 

 

What Rights do the AD groups require (R/W/E/Other)

 

 

 

 

Management

How regularly do maintenance procedures need to be run?

 

 

 

 

High Availability

Is HADR required?

 

High Availability

What is the RPO?

 

High Availability

What is the  RTO?

 

 

 

 

Configuration

DB2_FMP_COMM_HEAPSZ (ON|OFF)

 

Configuration

DFT_MON_BUFPOOL (ON|OFF)

 

Configuration

DFT_MON_LOCK (ON|OFF)

 

Configuration

DFT_MON_SORT (ON|OFF)

 

Configuration

DFT_MON_STMT (ON|OFF)

 

Configuration

DFT_MON_TABLE (ON|OFF)

 

Configuration

DFT_MON_TIMESTAMP (ON|OFF)

 

Configuration

DFT_MON_UOW (ON|OFF)

 

Configuration

HEALTH_MON (ON|OFF)

 

Configuration

INSTANCE_MEMORY (AUTOMATIC)

 

 My aim is to achieve  DB2 software requirements gathering for a new server , with  maximum efficiency. Of course, this is rarely done , but documenting the process with accurate information is first step.

 I hope this checklist helps. If you can see line items missing – let me know – as I would like to enhance this DB2 software requirements gathering template

Author: Jack Vamvas(http://www.dba-db2.com)
Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 software requirements gathering for a new server

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright