Software

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

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


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