Backup and recovery are two important mechanisms designed for the purpose of ensuring the continual health of your data. Backups are typically divided into categories that measure level of usage, such as cold storage for archives. The purpose of recovery is to ensure that you have a backup to restore if and when your data is lost. This article offers a review of key Azure backup and recovery services..

Azure provides several services to help companies easily migrate to the cloud. This article offers a review of key tips and tools you can use to ensure a successful migration to Azure. 

Before you start migrating your data..

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:

High-Performance Computing (HPC) enables you to leverage cloud-based supercomputing with the scalability of the cloud. Most major cloud vendors offer HPC services, including Azure, Google, and AWS. In this article, you’ll learn what HPC is and how it works on Azure. You’ll also learn how to deploy and manage Azure-based HPC.

Moving big data to the cloud has many advantages. The cloud enables you to run business intelligence in extra-large datasets, getting valuable insights. You can also make the data available for collaboration or store it to ensure availability in case of failure or disaster..

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?

In this tables, I relate general terminology, versions, utilities and views from IBM DB2 and Oracle databases..

Below are a list with the more common status of IBM DB2 tablespaces

The most used method to show the status of the tablespaces is, from the console command line:

Db2look is an utility to extract the definition of database objects. It also allows some really interesting statistics to extract objects for export to other test environments / integration plans and get the same access to objects.

In this article we will see more frequent usefulness.

DDL extraction of the objects in my schema:

db2look -d MI_BBDD -a -e -x -o FICHERO_SALIDA.txt

Extraction of the DDL of the DEPT table:

db2look -d MI_BBDD -t DEPT -a -e -x -o FICHERO_SALIDA.txt

To include statistics to have to use the “-m” option.

Many are claiming that containerization is the future of the cloud and maybe even of application development in general. Supporting this is the fact that Google alone launches more than two billion containers each week. In fact, almost all of the Google services you know and use are built on containers..