Configure Db2 Data Server Driver to communicate with the Db2 server via SSL connection and how to use it in Toad for DB2 version 6.3.
Configure Db2 Data Server Driver to communicate with the Db2 server via SSL connection and how to use it in Toad for DB2 version 6.3.
In this post, we will go through the configuration of Db2 Data Server Driver v11.1 to communicate with the Db2 server via SSL. The pre-requirement for this post is to have a Db2 server configured for ...
Common misconception about how Oracle handles deadlocks
Common misconception about how Oracle handles deadlocks
Introduction In today's blog post, I'd like to uncover a common misconception about how Oracle handles deadlocks, but first let's talk about what deadlock is. Deadlock is a locking scenario that occur...
Db2 12 for z/OS SQL Enhancements: Advanced Triggers
Db2 12 for z/OS SQL Enhancements: Advanced Triggers
In this, the fourth of a set of four entries covering SQL enhancements introduced with Db2 12 for z/OS, I will describe new trigger capabilities delivered by way of what are called "advanced triggers"...
Background Processes in Oracle ASM
Background Processes in Oracle ASM
Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas ...
PostgreSQL/EnterpriseDB Inside Linux Containers (LXC)
PostgreSQL/EnterpriseDB Inside Linux Containers (LXC)
Introduction Virtualization is one of the core assets of today’s data center infrastructure. The benefits and capabilities of virtualization are driving organizations towards virtualization technologi...
Toad Code Analysis
Toad Code Analysis
Hi, Code Analysis has been in Toad for a while now. If you are using a slightly older version of Toad, it might be called Code Review, found under the same menu path. Code Analysis gives you or your...
Oracle Database 12.2 Statement-level Refresh for Materialized Views
Oracle Database 12.2 Statement-level Refresh for Materialized Views
Introduction Materialized views have been used for several years and they are being improved by Oracle with every database version or release. Up to Oracle Database 12cR1 Oracle Materialized Views sup...
How to speed up your Oracle Data Mining with in-memory and parallel
How to speed up your Oracle Data Mining with in-memory and parallel
Have you have found running a workflow in Oracle Data Miner slow or running the scripts in the database slow ? No. Good, because I haven't found it slow. But (there is always a but) it really depends...
Run Oracle Scripts (Even against Multiple Databases) in the Toad Script Manager
Run Oracle Scripts (Even against Multiple Databases) in the Toad Script Manager
If your IT department or development team is like a lot of those I talk with (and have worked in), you have a lot of scripts that do all sorts of things. They are important to you, and that’s why yo...
Oracle EM 13c Database’s historic data without DBA_HIST*
Oracle EM 13c Database’s historic data without DBA_HIST*
Introduction Data changes frequently in OLTP environments and Oracle has to be aware of those changes or at least to try detect these changes in order to adjust the optimizer and execute sentences in ...
Toad Data Point – How to work with results in Toad Data Point Query Builder
Toad Data Point – How to work with results in Toad Data Point Query Builder
The Query Builder enables you to create a query without writing or editing SQL statements. Even if you are familiar with SQL, the graphical interface makes it easier to create relationships and visual...