by XTIVIA | Feb 5, 2015 | Blog, Data Management, Databases
DB2’s automated maintenance does not currently allow us to automate inplace reorgs. Inplace reorgs are more online than other reorgs, and in my experience are heavily used. This means that many DBAs wrap some sort of scripting around reorgs. Working in a variety...
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 16, 2013 | Blog, Databases
One of our Virtual-DBA clients has a small DB2 environment with version 9.7 on Linux and HADR connecting a primary and standby system. When the application team created the database, it was created using Automatic Storage on the /home filesystem. This will...
by XTIVIA | Apr 25, 2013 | Blog, Databases
Many of our Virtual-DBA clients have DB2 upgrade plans in the works. One of them wants to move from V9.1 to V10.1 on Windows. I’ll share some of my experience with this project. Right now I’ve completed the set up of the 10.1 instance and...
by XTIVIA | Feb 20, 2013 | Blog, Databases
At XTIVIA, we monitor and support multiple clients that use Lawson applications with a DB2 LUW (Linux, Unix and Windows) database back end. I wanted to share some of my experience and lessons learned over the years. Schema Layout: Out of the box, Lawson uses...
by XTIVIA | Jan 2, 2013 | Blog, Databases
I’m working on a data purging project for one of our clients and I’ll blog as it progresses. The first step was to find the oldest data in the database and let the application team look it over to decide what can be purged. I came up with the handy...