Xtivia Services for IBM DB2 Universal Database (UDB)

Xtivia offers a wide range of database administration services for IBM DB2 Universal Database (UDB) for Linux, UNIX, and Windows (LUW) environments. These services are offered by the Virtual-DBA Service or through Xtivia’s Professional Services group.

DB2 on Storage Area Network (SAN) Storage

We can make recommendations according to IBM's Best Practices on SAN Storage for your database running on AIX, HP-UX, Solaris, Linux or Microsoft Windows. These recommendations will include Logical Unit Number (LUN) sizes, RAID type, file system sizes, and where to place your data, indexes and transaction logs to provide the best performance possible. 

DB2 Performance Tuning

Poor Structured Query Language (SQL) statement performance and high CPU usage on your DB2 server almost always indicates the need for performance tuning.  We can analyze your pain points and make recommendations on your DB2 configuration, memory settings and storage architecture. We will also analyze poor performing SQL statements that may benefit from the correct index and in some cases a clustering index to drastically reduce the amount of CPU your database server needs to use. These activities can focus on  specific targets or as part of our Health Check package for DB2

DB2 Memory Usage

Allocating memory on your DB2 server can be a daunting task, especially for DB2 V7 and V8 running on 32-bit architecture.  We can make recommendations on how to divide your available memory into the places DB2 needs it the most.  Places like the bufferpools, sort heap, lock list, and utility heap.  DB2 ESE, DB2 WSE and DB2 Express-C instances on 64-bit architecture have more memory to work with.  We can help you take advantage of that extra memory and allocate it appropriately.

Request More Information

DB2 Upgrades

Upgrading your DB2 ESE or DB2 WSE instance from V7 to V8.2?  Maybe migrating from V8.2 to V9.5?  Whatever versions you work with, migrating to a new version of DB2 takes planning and experience.  We can handle all aspects of your DB2 upgrade on AIX, HP-UX, Solaris, Linux or Microsoft Windows including code installation, instance migration, database migration and licensing.

DB2 Migration from 32-bit to 64-bit

Are you ready to get your DB2 ESE or WSE system out from under the 32-bit memory limits?  If you are planning a version upgrade or just want to take advantage of your 64-bit AIX, HP-UX, Solaris, Linux or Microsoft Windows operating system, we can help you migrate your DB2 ESE or DB2 WSE instance to take advantage of the 64-bit architecture on Linux, Unix and Windows.

DB2 Fixpacks

Fixpacks for DB2 include important changes, known as APAR’s, to existing features and additional features that you aren’t currently using.  We can install the latest fixpack for your version of DB2 and help you take advantage of any new features.

Request More Information

DB2 HADR

HADR stands for High Availability Disaster Recovery.  HADR is a database replication feature that provides a high-availability solution for both partial and complete site failures. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.  We can implement HADR in your DB2 V8.2. V9.1 or V9.5 environment and show you how to manage it.

DB2 Self Tuning Memory Manager (STMM)

Starting with V9.1, DB2 comes with a new feature called STMM.  We can help you fully take advantage of this feature to allow DB2 to handle memory allocation and allow you to work on other things.

DB2 Health Check

Ever wonder if you are getting the most out of your DB2 ESE, WSE, or DWE database running on AIX, HP-UX, Solaris, Linux or Microsoft Windows?  Our DB2 Health Check service will provide you with exactly what you need.  We do a deep analysis of your environment, database workload, and database configuration to provide you an easy to read, management-level report with the current state of your system and any recommendations to improve its performance and availability. 

Request More Information

DB2 SQL Replication

DB2 SQL Replication is useful in setting up a reporting database, a test database or even a High Availability fail-over database.  DB2 SQL Replication comes standard with DB2 ESE and WSE V8.2 and V9, and DB2 Express V9.  We can help you gather requirements, implement and manage your replication solution. 

Backup and Recovery

The best solution to avoid downtime and data loss in a production environment is to implement a preventive maintenance strategy before problems occur.  We can work with you to identify potential problems, produce a course of action and implement data security and recovery strategies that fit your business plan.

Problem Analysis

We have helped many clients experiencing performance, configuration or implementation issues with their DB2 environments. They have experienced issues with the DB2 system set up or configuration or one of the many available tools such as DB2 Connect, DB2 Query Patroller or DB2 Information Integrator.  Following an assessment, our DBAs can suggest a course of action and  work with you to implement it.

Request More Information

DB2 Development

Very often the role of the DBA is overlooked in development efforts. We work with the our clients development teams in the developer, DBA or architect roles.  We can help with SQL writing and tuning, reviews of data models, performance, data modeling and general best practices. 

DB2 Security and Auditing

Database security is a major concern for all of us. We can work with you to insure that you have the proper security for your DB2 environment.  We can also help you identify potential problems, develop a course of action and implement system security strategies that fit your business model.

Request More Information