by XTIVIA | Jul 7, 2015 | Blog, Data Management, Databases
When upgrading DB2 fix pack, you need to make sure that all DB2 related processes have been shut down clean. In normal circumstances, you would: db2stop (if that does not work, try db2stop force) db2licd –end ipclean Even after following the steps, you may still see...
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 | 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 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...
by XTIVIA | Nov 27, 2012 | Blog, Databases
Hi. I recently finished a project for a client who needed Update-Anywhere Repliction on one table between 4 DB2 version 9.1 databases at different locations. I thought I would share a high-level overview of the process I used, starting with 2-way...
