Databases | Dataprix TI

Entradas de blog

Read more about Detecting indexes, tables and packages not used on DB2
Log in or register to post comments

DB2, from version 9.7, allows to know easily what indexes are not being used in a Database. The query is also for tables and packages.

This is a useful tool for tuning indexes and detecting problems in their use.

After version 9.7 DB2 includes a new LASTUSED field in the SYSCAT.INDEXES, SYSCAT.TABLES and SYSCAT.PACKAGES tables.

This field indicates the date of last use of indexes, tables or packages.

For example, to query unused indexes since 1/1/2019, you could use this simple query:

Read more about Uptime / Last reboot of DB2
Log in or register to post comments

This mini tip show you how to know when was the last time you restart a DB2 server on a UNIX / LINUX.

> db2 get snapshot for dbm | grep Start

Start Database Manager timestamp = 04/02/2011 13:45:20.516473

Simple, isn't it?

Documentación y recursos

How to repair SQL Server databases with Stellar Repair MS SQL

How to Repair Corrupt SQL Database with the help of Stellar Repair for MS SQL software.Most Recommended software by MVP's and administrators to repair corrupt MDF and NDF files. It recovers tables, triggers, indexes, keys, rules and stored procedures. It supports SQL Server 2017, 2016, 2014, 2012, 2008, 2008R2 and all lower versions.