Skip to main content
  • Log in

Menu principal

  • Quienes somos
  • Para Profesionales IT
  • Publicidad y servicios
  • Contact
  • twitter
  • linkedin
  • facebook

Dataprix main menu

  • Blogs
  • Software
  • News and resources
Home

Main tematic navigation

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

Software

Huawei Gauss DB

Huawei GaussDB is an enterprise-class AI-Native distributed database that uses the massively parallel processing (MPP) architecture.

GaussDB supports both row and column-oriented storage and is capable of processing petabytes of data. GaussDB offers a cost-efficient, general-purpose computing platform to manage massive data sets and is compatible with a wide range of data warehousing systems, business intelligence (BI) systems, and decision support systems (DSS).

Más software empresarial

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:

more posts

Publicaciones en la red

Databases


Database And Developer Enhancements In IBM i 7.5 And 7.4 TR6

Database And Developer Enhancements In IBM i 7.5 And 7.4 TR6Alex WoodieIBM has made a number of enhancements to the Db2 for i database with the launch of IBM i 7.5, which becomes generally available tomorrow. So this enables that journey into Boolean.”There’s a bunch of other cool stuff that IBM has done with the database in IBM i 7.5, too. As noted, IBM i 7.5 ships tomorrow, while IBM i 7.4 TR6…
Read on:

https://www.itjungle.com/2022/05/09/database-and-developer-enhancements…


"CommonSpirit Health ""IT security issue,"" MySQL backdoor, P2P fraud"

CommonSpirit Health hit with “IT security issue”The issue impacted its electronic health record systems, forcing the nonprofit health care organization to shut off systems at some facilities. (The Record)MySQL servers backdooredAnalysts at the German security firm DCSO CyTec discovered a new piece of malware targeting Microsoft MySQL servers. The Consumer Financial Protection Bureau is expected…
Read on:

https://cisoseries.com/cyber-security-headlines-commonspirit-health-it-…

More publications from the net

Software destacado

SEMrush

SEMrushSEMrush is a web tool for SEO and SEM analysis, focused on the search for keywords (Keyword Research) and competitive analysis.
This web tool, pay per use, provides a user-friendly analysis using data giving access to organic positioning and pay…

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by Recommended by NetLine

Popular today

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…

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…

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…

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…

Use SYSDUMMY1 in DB2 to obtain the actual server name

By using the auxiliar table sysdummy1 you can query information about a server with DB2 installed.

Slowly Changing Dimensions

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

TOP 10 rows on DB2

In this shosrt post we will show how to obtain the N first rows from a Query on IBM DB2.

db2look – Create DDL for table or full schema

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

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…

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