Search dba-db2.com
*Use the Comments section for questions
Recent Posts
DB2 software requirements gathering for a new server
14 June,2011 by Tom Collins
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? |
|
|
|
|
|
|
Is HADR required? |
|
|
|
High Availability |
What is the RPO? |
|
|
High Availability |
What is the RTO? |
|
|
|
|
|
|
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)Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |