by XTIVIA | Sep 10, 2015 | Blog, Databases
Usually only a DBA forces or even views connections to a DB2 database. But in many small companies, people play multiple roles, and I thought I’d share a detailed introduction to how to look at and force off connections to a DB2 database. All details and...
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 | 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 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 even when the id you used to restore has...
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...