(888) 685-3101 ext. 2

Remote DBA Support
& Data Management

Virtual-DBA, powered by XTIVIA,
leads the way in the database support industry.
Trust in your database. Trust in XTIVIA.

Remote DBA Support
& Data Management

Virtual-DBA, powered by XTIVIA,
leads the way in the database support industry.
Trust in your database. Trust in XTIVIA.

IBM DB2
Informix
SQL Server
Oracle
MySQL
MongoDB
postgresql

DBA Support and Professional data management offered through our Virtual-DBA services on www.virtual-dba.com.
Learn more about the database platforms we support.

Our technical support database team has expertise in all of the database platforms listed here. They are comprised of seasoned database professionals who also possess the business background, project management experience, and technology expertise to deliver business-critical technology solutions. These data management solutions include a variety of platforms, devices and networks, including integration with legacy systems, development of business applications and web-based functionality.

Data Management Services

Remote Managed DBA Service

Software and Licensing

l

Health Checks and Performance Tuning

Replication

Installation

Backup and Recovery

!

Migration and Upgrades

Consolidation and Virtualization

Professional Services

For more information about our remote data management services, please visit our Virtual-DBA website.

Bill Santos

IT Manager

Darice Inc.

“Working with Virtual-DBA has been a breath of fresh air for our company. We are no longer bottlenecked having a single in-house DBA trying to support different database platforms. The Virtual-DBA team has years of experience and it’s easy to communicate with a DBA anytime we need assistance. Quite frankly, I don’t lose sleep knowing that Virtual-DBA is proactively monitoring our critical business systems.”

Bill Santos

IT Manager

Darice Inc.

“Working with Virtual-DBA has been a breath of fresh air for our company. We are no longer bottlenecked having a single in-house DBA trying to support different database platforms. The Virtual-DBA team has years of experience and it’s easy to communicate with a DBA anytime we need assistance. Quite frankly, I don’t lose sleep knowing that Virtual-DBA is proactively monitoring our critical business systems.”

Database Support & Management Blog

Using The Informix REST API To Insert Into A JSON Time Series

I often use the Informix Developer Edition for ARM on my Raspberry Pi for quick prototyping and proof-of-concept (POC) experiments as the Informix Developer Edition has all of the features of the full Enterprise Edition, including native JSON and Time Series...
Programming code

DB2 SQL: Rewriting a Distinct with a Correlated Sub-Query to a Group By for Performance Improvement

Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they basically said "What's wrong with DB2? my query is running long! Are there lock timeouts happening?" The query came from...

Analyzing Lock Escalation

What is Lock Escalation? When LOCKLIST and MAXLOCKS are not set to AUTOMATIC, or total system memory is constrained, lock escalation can occur. When there is not enough room in the lock list to store additional locks that an application needs to continue processing,...
XTIVIA team member with tablet doing database maintenance

Timing Your SQL Server Maintenance Jobs

Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There is going to be times when you are going to need to run maintenance on your server. The tricky part is trying to...

Stopping Your SQL Server Jobs

Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There are going to be times when you need to perform maintenance on your server. The tricky part is trying to determine...
server rack

Dropping a DB2 Schema and Objects it Contains

It may be something that's not terribly common to have to do, but that makes it all the more important that we document how to do it. Dropping a schema and all of the objects in that schema used to be tedious and time-consuming. We used to have to look for a large...
XTIVIA team members working together on a project

SQL2032N When Backing Up a DB2 Database

When taking a backup of a DB2 LUW database, there are a lot of options to choose from. I like to specify as many as possible to make it clear exactly what I want, even if I am specifying the defaults. Though I very rarely specify the number or size of backup buffers,...

ENOMEM by db2fmp in db2diag.log

I can't remember the last time a ulimit bit me, but the time has come again. Everyone is used to removing all the limits for the instance ID at this point, I hope, but have you ever considered the ulimits for your fenced user id? The Problem In the DB2 diagnostic log,...

DB2 LUW Error Message: SQL0964C

Error Message SQL0964C The transaction log for the database is full. SQLSTATE=57011 or DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction log for...

DB2 LUW Error Message: SQL0968C

Error Message SQL0968C The file system is full. This is frequently an error that is returned to an application and reported simply as -968 When You Might Encounter This Error Message This error typically is encountered when updating or inserting data, though in some...

SQL Server Database Encryption Status

Securing your data is very important and database encryption is just part of that landscape. Taking advantage SQL Server database encryption can be a daunting task but once it is configured it is also important to monitor it. This query is intended to allow the...

SQL Toolbox – SQL Server Management Studio SSMS Shortcut Alt + F1

SSMS Shortcut is what we are going to be learning about in this blog post. When writing T-SQL it can be quite distracting to go look up a table definition or information on a database object. Enter the SQL Server Management Studio (SSMS) shortcut key ALT + F1....

Database Support & Management Blog

Using The Informix REST API To Insert Into A JSON Time Series

I often use the Informix Developer Edition for ARM on my Raspberry Pi for quick prototyping and proof-of-concept (POC) experiments as the Informix...

DB2 SQL: Rewriting a Distinct with a Correlated Sub-Query to a Group By for Performance Improvement

Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they...

Analyzing Lock Escalation

What is Lock Escalation? When LOCKLIST and MAXLOCKS are not set to AUTOMATIC, or total system memory is constrained, lock escalation can occur. When...

Timing Your SQL Server Maintenance Jobs

Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam....

Stopping Your SQL Server Jobs

Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam....

Dropping a DB2 Schema and Objects it Contains

It may be something that's not terribly common to have to do, but that makes it all the more important that we document how to do it. Dropping a...

SQL2032N When Backing Up a DB2 Database

When taking a backup of a DB2 LUW database, there are a lot of options to choose from. I like to specify as many as possible to make it clear...

ENOMEM by db2fmp in db2diag.log

I can't remember the last time a ulimit bit me, but the time has come again. Everyone is used to removing all the limits for the instance ID at this...

DB2 LUW Error Message: SQL0964C

Error Message SQL0964C The transaction log for the database is full. SQLSTATE=57011 or DB21034E The command was processed as an SQL statement...

DB2 LUW Error Message: SQL0968C

Error Message SQL0968C The file system is full. This is frequently an error that is returned to an application and reported simply as -968 When You...

SQL Server Database Encryption Status

Securing your data is very important and database encryption is just part of that landscape. Taking advantage SQL Server database encryption can be...

SQL Toolbox – SQL Server Management Studio SSMS Shortcut Alt + F1

SSMS Shortcut is what we are going to be learning about in this blog post. When writing T-SQL it can be quite distracting to go look up a table...

Let's Talk Today!

No obligation, no pressure. We're easy to talk with and you might be surprised at how much you can learn about your project by speaking with our experts.

XTIVIA CORPORATE OFFICE
304 South 8th Street, Suite 201
Colorado Springs, CO 80905 USA

Additional offices in New York, New Jersey,
Missouri, Texas, Virginia, and Hyderabad, India.

USA toll free: 888-685-3101, ext. 2
International: +1 719-685-3100, ext. 2
Fax: +1 719-685-3400

Complete the form to hear from us.

XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.

Share This