DB2 LUW Support and Services
Add Datavail’s DB2 for LUW Expertise 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 Us
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 USWork for Us
Where do you want to take your career? Explore exciting opportunities to join our team.
EXPLORE JOBS