by XTIVIA | May 28, 2014 | Blog, Data Management, Databases
So for various reasons I run into orphaned datapump jobs either due to a session failure during the import or for some other unknown reason for a failed import. What I wanted to show you really quick was how to find them and how to remove them so you can run your...
by XTIVIA | May 22, 2014 | Blog, Databases
SQL1035N The database is currently in use. SQLSTATE=57019 IBM UDB DB2 V9.7/10.1/10.5 on Windows/UNIX/Linux I have been trying to create a script that will refresh the test database using QA data on a regular schedule. As part of the script I force all...
by XTIVIA | May 9, 2014 | Blog, Databases
Anyone who has worked with an Informix database knows that the moment you run into a query performance issue, you start with update statistics on that table. This was always what we were taught in support and talking with big names at IIUG, it’s still the...
by XTIVIA | May 7, 2014 | Blog, Data Management, Databases
Managing Logins If you have worked with SQL Server a while you may recognize there is a difference between logins and users. When it comes to managing security with SQL Server it is important to know the difference, and the differences that have come about over...
by Paul Anderson | May 6, 2014 | Blog, Databases
Informix provides the functionality to restore a single table or a subset of a table to a point in time or to the last archive. This functionality was originally released in IDS v10 and is provided through the archecker software which is included with the...
by XTIVIA | Apr 16, 2014 | Blog, Databases
Many of our Virtual-DBA clients need to complete audits for compliance with regulations. SOX (Sarbanes Oxley) is a common audit that our customers need to successfully complete. A common question the auditors ask is, “How do you know a user has been granted elevated...
by XTIVIA | Apr 3, 2014 | Blog, Databases
If you’re like me, you tend to brush off concerns of compatibility between Oracle Client and Server versions. After all, SQL*Plus hasn’t changed much in the last 15-20 years, and I’ve gotten used to being able to connect to pretty much any...
by XTIVIA | Mar 31, 2014 | Blog, Data Management, Databases
So I just wanted to share this quick write up on how to stop and start your Oracle database and listener automatically on a Linux server. I use this approach for 10g, 11g, and 12c and so far I haven’t had any issues. Oracle provides the means to do this using scripts...
by XTIVIA | Mar 28, 2014 | Blog, Data Management, Databases
In cases when a database change needs to be made there are some good rules that when used can save you a lot of time down the road. Run changes via scripts – Scripts add for precise execution and help remove human error when it comes to typos. When creating scripts...
by XTIVIA | Feb 14, 2014 | Blog, Data Management, Databases
I was working with a customer the other day and they were asking for some help setting up dbconsole for their 12c database. It seems that it wasn’t working out of the box and they needed some help configuring it. So of course I said sure no problem! I have done...
