by XTIVIA | Sep 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases, Enterprise Infrastructure
20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don’t remember the HDD capacity – I believe it was around 120MB or so) from my infrastructure guy, I felt like I’m hero on the street advertising to everyone the great piece of...
by XTIVIA | Aug 6, 2015 | Blog, Data Management, Databases
A lot of DB2 LUW DBAs spend significantly more time working with DB2 on Linux and UNIX than they do working with DB2 on Microsoft Windows. This can lead to frustration when administering DB2 on Windows. Using a PowerShell command line for DB2 instead of a DB2 Command...
by XTIVIA | Jul 16, 2015 | Blog, Data Management
Logging method There are two methods of logging that DB2 supports: Circular and Archive. Other RDBMSes have similar modes. Circular The default that DB2 uses if you don’t change anything is Circular logging. Circular logging is more often appropriate for...
by XTIVIA | Jun 30, 2015 | Blog, Data Management, Databases
There are several times that you may have DB2 restore authorization errors and have to restore from a production box to a beta or a QA environment as a different user. In that scenario, the restore commands will work just fine but you will receive authorization errors...
by XTIVIA | Jun 23, 2015 | Blog, Data Management, Databases
One of our customers recently wanted to extract data using db2audit, but the documentation on this topic is very limited and scarce. Moreover, the commands have changed after V9.7 and finding documentation or following it could be tricky. After some testing, we were...
by XTIVIA | May 28, 2015 | Blog, Data Management, Databases
This article is part 7 of a 10 part series explaining the most common mistakes that I have seen in reference to SQL Server Performance and Resiliency. However, this post is not all-inclusive. Most common mistake #7: Disaster Recovery Plans Often when people hear...
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 | 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 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...
