by XTIVIA | May 15, 2015 | Blog, Data Management, Databases
During routine integrity checks one of our Virtual-DBA customers encountered an error 17053 was encountered causing the job performing these tasks to fail. Investigating the problem further this information was also included with the error in the SQL Error Log:...
by XTIVIA | May 7, 2015 | Blog, Databases
The Informix “onclean” command was introduced in Informix 11. I am sure that most Informix DBAs have occasionally faced a situation where the Informix instance won’t come online due to an improper shutdown, killed process, interrupted restore, or an instance...
by XTIVIA | May 6, 2015 | Blog, Data Management, Databases
Tip # 6 – Change History, Top 10 Tips for SQL Server Performance and Resiliency This article is part 6 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake...
by XTIVIA | Mar 4, 2015 | Blog, Data Management, Databases
This article is part 5 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common mistake #5: Not Setting a Maximum Memory Default configurations are not always the best...
by Kathleen Long | Feb 27, 2015 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
SUMMARY: This guide details the technical process for establishing connections between SQL Server Reporting Services (SSRS) and non-SQL data sources by installing the Microsoft Access Database Engine and configuring specific OLE DB or ODBC connection strings....
by XTIVIA | Feb 26, 2015 | Blog, Data Management, Databases
This is a pretty common error and there are a few reasons you might be seeing this error. 1. The database could simply be down. If you’re on *nix platform you can simple check this by a simple ps -ef | grep pmon. If this returns ora_pmon_<instance_name>....
by XTIVIA | Feb 25, 2015 | Blog, Data Management, Databases
Problem Description A working federation environment – querying an 11gR2 Oracle database from a DB2 10.5 FP4 database – suddenly started returning error ORA-01013. Four minutes into each statement, the following error was returned: SQL1822N...
by Matt Wolinski | Feb 25, 2015 | Blog, Databases, Enterprise Infrastructure
I was recently working on a client’s site and ran into the following warning: WARNING: You are running on a NUMA machine. We suggest launching mongod like this to avoid performance problems: numactl –interleave=all mongod [other options] This warning shows...
by XTIVIA | Feb 12, 2015 | Blog, Data Management, Databases
Click to download full Oracle Error eBook A very common Oracle database error that is basically telling you that you have run out of logical or physical space on the mount, disk, or your db_recovery_file_dest location that holds your archivelogs. When you get this...
by XTIVIA | Feb 11, 2015 | Blog, Data Management, Databases
MySQL creates a default configuration file named my.cnf (or my.ini in Windows), that can be edited to include and fine tune the startup options to meet the needs of your environment. This is often more convenient than entering these values every time you start the...
