With the flashback database feature, the hours-long restore-recover process can be completed in a few minutes. You can roll back and open your database …
Read More »Database Mirroring On SQL Server
Microsoft has announced that it will remove Database Mirroring in the future because it has developed the Always On technology. But since SQL Server …
Read More »Restore Operations With rman
RMAN is a tool also recommended by Oracle for backup and recovery. There are many recovery scenarios. The main ones are: Recovering a database …
Read More »How To Move a Table On PostgreSQL
Sometimes we may want to create the same table in a database without the data in it by using a different name or we …
Read More »DB2 Remote to Client connectivity via port
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 …
Read More »DB2 license activation
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 …
Read More »The SYSIBM.SYSSTATFEEDBACK table introduced in Db2 for z/OS V11
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 …
Read More »Running an Operating System Command while Connected to Postgres
You are processing in psql, but you need to look at something on the operating system side, so you must exit from the psql …
Read More »SQL Server Replication Types
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 …
Read More »Monitoring MongoDB Process
Script to monitor Mongo DB processes across a cluster. [crayon-673f28481e166275261663/] Log file result: [crayon-673f28481e16a065693609/] Note: Requires ssh passwordless login and cluster configuration file.
Read More »