by XTIVIA | Nov 15, 2012 | Blog, Databases
Learn how to setup and backup Informix Dynamic Server and ISM Let’s talk about the Informix Dynamic Server. I have often been asked how difficult it is to use ISM and Onbar to backup their Informix Dynamic Server. I gave a webinar early in October that will...
by XTIVIA | Oct 2, 2012 | Blog, Databases
I recently had a client ask me about how to use profiler. I looked online and did not find anything that was concise and to the point for what I wanted to show him so I decided to just make a quick tutorial which is listed below. This tutorial covers the usage...
by XTIVIA | Oct 1, 2012 | Blog, Databases
Quick, DBA with the sysadmin role in SQL Server: What’s your default database? I’ll bet you think it’s the master database. But, as I learned this weekend, that’s not something you can take for granted — especially if you didn’t...
by XTIVIA | Sep 28, 2012 | Blog, Databases
Given the general mayhem and wanton destruction database developers can inflict on an organization, you’d think there’d be a best-practices set of SQL Server permissions that DBAs should grant developers. Or better yet, a “dbdeveloper” server...
by XTIVIA | Sep 26, 2012 | Blog, Databases
One way to make your DB2 database use less storage and speed up Inserts and Updates is to drop the indexes that are never used. As the application changes and the database workload changes, you may find many indexes are no longer needed. Dropping these...
by XTIVIA | Aug 6, 2012 | Blog, Databases
While creating a linked server from SQL Server 2005 to SQL Server 2000, I got the following error when I tried to query the remote server. OLE DB provider “SQLNCLI10” for linked server “XXXXXX” returned message “The stored procedure...
by XTIVIA | Aug 2, 2012 | Blog, Databases
Hello again, I wanted to follow up on my last blog entry about speeding up the DB2 database restore on an AIX machine. We did some more testing last night by enabling the jfs2 logging back to how it should be. The restore took only 5 minutes when it used...
by XTIVIA | Jul 31, 2012 | Blog, Databases
Hello, I wanted to share some lessons learned with AIX kernel parameters and DB2 database restore performance. We have a client with a 21 GB database on AIX version 6.1 and DB2 9.7 fixpack 6. The server has 8 quad-core CPU and 32 GB of memory. This is a...
by Tony Salerno | Jul 25, 2012 | Blog, Databases, Perspectives
How do you know if you have the right number of database administrators (DBAs) on staff to properly take care of your environment? All your organization’s databases need to be kept operational and properly tuned, which probably requires around the clock...
by XTIVIA | Jun 1, 2012 | Blog, Databases
I was presented a problem which entailed removing 100s of millions of records from several tables in order to recover disk space and improve query performance. There were several options to choose from of which I explored: I could do the most basic “DELETE FROM…” all...
