by XTIVIA | Nov 2, 2021 | Blog, Db2
Recently I had a client ask me if there was a way to calculate the size of individual indexes on a table and how to interpret what is reported by the table function sysproc.admin_get_index_info. The client asked whether the value is reported as a sum per table or per...
by XTIVIA | Oct 8, 2019 | Blog, Db2
There are several scenarios where you might need details to re-build TSAMP. If TSAMP did not start properly after an upgrade or even while troubleshooting, the option to open a case with IBM and get root cause analyzed takes time. In many of these scenarios,...
by XTIVIA | Sep 12, 2019 | Blog, Db2
While I’ve covered this topic in detail, and blogged about a specific backup performance problem, I’ve never talked about this at the basic level. What is a Backup? A backup is a binary image of the entire Db2 database. It is, therefore, the size of the...
by Tony Salerno | Apr 30, 2019 | Blog, Database
IBM’s Db2 (previously DB2 up until 2017) is a popular Relational Database Management System used by businesses of all sizes in the computer software and IT service industries. Originally developed for the relational model, IBM has extended Db2’s support to...
by Marc Petros | Feb 14, 2019 | Blog, Db2
How do I grant a user SYSADM, SYSCTRL, SYSMAINT, or SYSMON privileges in Db2? As a newbie to the database administration world, I was tasked with giving a pretend user the ability to create databases in a virtual environment setup for learning. I easily found that the...
by XTIVIA | Feb 7, 2019 | Blog, Db2
After applying a Db2 fixpack, you can get SQL0443N when calling the get_dbsize_info() stored procedure. Cause and resolving the problem: get_dbsize_info() uses the system catalogs internally which do not get updated as part of a fix pack update, and should be updated...