Skip to main content
  • Log in
  • twitter
  • linkedin
  • facebook

Dataprix main menu

  • Blogs
  • Software
  • News and resources
Home

Main tematic navigation

  • Business Intelligence
  • Data Science
  • Cloud
  • Databases
  • Security
  • ERP

Entradas de blog

Detecting indexes, tables and packages not used on DB2

By Oscar_paredes on Mon, 02/10/2020 - 19:53
  • 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:

Uptime / Last reboot of DB2

By Oscar_paredes on Tue, 01/14/2020 - 19:30
  • 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?

 

more posts
Más software empresarial

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.

The beginners guide to NoSQL

Beginners guide to NoSQLTake advantage of noSQL by learning the basics and more with this FREE eBook offered by Robert Gordon University that includes:

  • An introduction to noSQL
  • The four different types of noSQL database that exist
  • The difference between SQL and noSQL and which to choose for your work

 

Más recursos sobre software empresarial
Más videos IT

Publicaciones en la red

Here’s Your Opportunity to Try Data Safe Cloud Security for
Free

Read on:

https://blogs.oracle.com/database/here%E2%80%99s-your-opportunity-to-tr…

MySQL Membership

MySQL membership conditions are in the MySQL 8 Documentation.
They’re found in the 13.2.11.3 Subqueries with ANY, IN, or SOME
section. The IN and =ANY operators both perform equality matches
with one twist. The IN operator works with a set of values or a
subquery but the =ANY operator only works with a subquery.

I created the digits, letters, and words tables for…

Read on:

https://blog.mclaughlinsoftware.com/2021/01/24/mysql-membership/

More publications from the net

Popular today

How to do an update from a select with summarized registers in SQLServer

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

Useful Oracle SQL queries and scripts

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

Easily export data from Oracle to flat file

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

Avoiding errors concatenating fields with numerical values in SQL Server

The operator to concatenate in SQL Server is '+', but this operator is also used to add values.   Being the same operator for both, the…

Listagg: New Oracle 11.2 function to summarize and aggregate strings

  In a LinkedIn debate about how to update from a select with summarized registers in SQL Server, Sergio Romero has shared an interesting…

Tips for UPSERT or update using insert in SQL Server

In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the…

How to disable autocommit option in SQL Server Management Studio

Have you ever wondered how to disable the autocommit option in Sql Server Management Studio? The answer is quick. Simply uncheck the option…

Slowly Changing Dimensions

Slowly changing dimensions or SCD (Slowly Changing Dimensions) are dimensions in which their data tend to change over time, either…

db2look – Create DDL for table or full schema

Db2look is an utility to extract the definition of database objects.

How to connect from Oracle SQL Developer with a remote SQL Server

I tried to create a connection in SQL Developer with a remote SQL Server database.

Breadcrumb

  1. Home
  2. Databases

Creative Commons License  This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.

Footer menu

  • Contact
Clear keys input element