Select Page

DB2 LUW Support and Services

Add Datavail’s DB2 Subject Matter Experts to Your Team

Datavail DB2 LUW services range from the routine to the advanced.

On our team, Datavail has established specialty groups to provide deep technical and administrative services on the following:

Configuration of DB2 server

  • Installing all IBM supported versions of DB2 software on Linux, Unix and Windows platforms
  • Support for all available editions of DB2 including WSE, ESE, AESE, DB2 Connect and PureScale
  • Support of all types of installations, including Silent Install
  • Configuring database manager and instances for communication, tooling, logging, recovery and interfacing with other systems including mainframe and midrange servers
  • Catalog databases and apply licenses

Routine administrative tasks

  • Capacity and memory management
  • Autonomic computing setup and support
  • Management of database objects like tables paces, indexes, statistics, reorg etc.
  • Setup and support of data movement utilities
  • Work identification and activities management using DB2 Workload Manager
  • Conversion and migration of databases from other platforms into DB2

High availability

  • Consulting on high availability strategies like redundancy, failover, clustering and automatic client reroute
  • Setup, review and manage HADR and pureScale features
  • Reviewing of database logging for high availability and recovery, including log shipping and log mirroring

Data recovery

  • Development and review of backup and recovery strategy
  • Monitor and support of backup, recover, restore operations
  • Support for TSM and Advanced Copy Services

DB2 tools

  • Setup and support for DB2 tools including IBM Data Studio and Optim Suite

Performance monitoring and tuning

  • Benchmark testing and analysis
  • Review of DBM and DB configuration, table space, buffer pool and top SQL analysis

Database monitoring

  • Routine monitoring of key elements like disk space, memory usage and availability, database load, buffer pool metrics
  • Time spent for sorting, dead locks, package cache performance and log performance

Security

  • Review of security for users, roles and groups
  • Review of users with higher privileges

SQL support

  • Reviewing and tuning of SQL that are top resource consuming, top time consuming and higher number of execution
  • Monitoring and calibrating both Static and Dynamic SQL queries

Troubleshooting and support

  • Troubleshooting of DB2 servers using tools like db2pd, db2diag, db2val etc.
  • Obtain required fixes from IBM and apply them to resolve problems

Health checks and best practices

  • Performing routine health checks on DB2 server and providing recommendations for the issues identified
  • Best practices review for DB2 planning and setup, administration, performance and SQL tuning

Contact a Data Expert

Call us at: 877-634-9222

Or, tell us about what you are trying to accomplish and we will contact you:

* denotes a required field:

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS