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

  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-662a5c399489c139912235/]   Log file result: [crayon-662a5c39948a1025204356/] 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-662a5c39952e0132225703/]   You can also use the following script to list …

  There are countless ways of understanding how long PostgreSQL has been turned on. In this article we will talk about 3 methods.   1)Using …

  Page is the most basic unit of SQL Server on storage. Each page consists of 8 KB. The mdf or ndf files that allocate …