This script will create a report of the connection rate on your Vertica Database Cluster. If you have connection load balance enabled the report should be showing an even distribution of the connections across all nodes in your Cluster. [crayon-592556876972d771772660/] Here is an example of the generated report: [crayon-5925568769739550500211/] ...

Continue reading

In our last article over AWK "Getting started with AWK" see introduced our self's with AWK, now let`s try to see how we can create AWK scripts and use them. Passing your scripts to awk as a command line argument can be very handy for small one-liners,...

Continue reading

Awk is geared toward text processing and report generation, yet features many well-designed features that allow for serious programming. And, unlike some languages, awk's syntax is familiar, and borrows some of the best parts of languages like C, python, and bash (although, technically, awk was...

Continue reading

To remove a swap file: 1 - At a shell prompt as root, execute the following command to disable the swap file (where /mnt/swapfile01 is the swap file): [crayon-592556876afda692955101/] 2 - Remove its entry from the /etc/fstab file. 3 - Remove the actual file: [crayon-592556876afe2696016220/]  ...

Continue reading
migration sql server to vertica

This is a simple step by step Vertica Management Console upgrade guide. Before you start make sure you download the latest Version or Vertica Management Console from  my.vertica.com website. Here we go ! Stop the Vertica Console: [crayon-592556876ca70802500732/] Take a backup of the existing Vertica Console: [crayon-592556876ca79326705445/] Upgrade the Vertica Console rpm [crayon-592556876ca7d297292481/]   Open...

Continue reading

Starting with Vertica version 7.2.x HP Vertica comes with a great feature called Inheritance, this concept is similar to SQL Server schema roles that will dynamic propagate the privileges across all objects in the schema and associate them with the users that have access to...

Continue reading