Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  RMAN is a tool also recommended by Oracle for backup and recovery. There are many recovery scenarios. The main ones are: Recovering a database …

  Sometimes we may want to create the same table in a database without the data in it by using a different name or we …

  Setting communication protocols for a DB2 instance is part of the main task of configuring TCP/IP or SSL communications for a DB2 instance. Set …

How to activate DB2 License, If you purchased a DB2 V10.5, V10.1, V9.8, V9.7, V9.5, V9.1 product then you can obtain license key from Passport …

  IBM introduced a new Db2 table with Db2 for z/OS V11 called SYSIBM.SYSSTATFEEDBACK.  The table verifies if statistics were collected and if the correct …

  You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql …

  Replication is one of the High Availability solutions. But it is not usually used as a High Availability solution. We would use SQL Server Always …

  Script to monitor Mongo DB processes across a cluster. [crayon-692d042fb9ae2063768102/]   Log file result: [crayon-692d042fb9ae7722734485/] Note: Requires ssh passwordless login and cluster configuration file.

  GTID replication is a simple High Availability solution (HA) offered in MySQL and MariaDB though the implementation technique is unique but compared to MySQL …

  You can use the following command to see the list of tablespaces created. [crayon-692d042fbadb4633180262/]   You can also use the following script to list …