gpcheckcat - Part 2

  1. What is gpchectkcat?
  2. When should gpcheckcat be run?
  • In-Short: The gpcheckcat script is used to test tables for inconsistencies.
  • Better Explanation :
  1. This script executes multiple tests to check database catalog inconsistencies. 
  2. Few tests are recommended to be run only when the system is not available to users. 
  3. Such tests are called has Off-line tests. 
  4. These cannot be run concurrently with other workload or the results wil not be usable. So how to run such tests? its always better to start the database in restricted mode when running gpcheckcat, restricted mode helps in preventing users connections reaching database. 
  5. There is a trick to run gpcheckcat without putting database in restricted mode, just set database connection to 0. 
  6. Then terminate all existing users connections. When we run this script, it checks for and removes orphaned, temporary database schemas in the specified database. 
  7. The same will also be reported in command line and logs.
  8. Catalog inconsistencies are inconsistencies that occur between database system tables. 
  9. There are 3 types of inconsistencies:
  • Inconsistencies in system tables at the segment level. 
  • Inconsistencies between same system table across segments.
  • Persistent table inconsistencies are inconsistencies in persistence object state and file system objects on a segments.
  1. It is always better to run Online gpcheckcat on daily bases. (-O option). This is nowhere related to database size. 
  2. It is a best partice to run Offline gpchechcat on all databases at least once in a Month. Most preferred method is to run once in a week (depending on maintenance window).

Comments

Post a Comment

Popular posts from this blog

IPMI Tool | IPMI Cheatsheet

To have a better understanding about IPMI Explanation: The Intelligent Platform Management Interface (IPMI) is a standardized computer system interface used by System Administrators for out-of-band management of computer systems and monitoring of their operation. Out-of-band is also referred to the LOM (Lights-Out Management) involves the use of a dedicated management channel for device maintenance. A numbers of options are available to manage the device remotely. There are vendor-specific server management technologies available. HP’s Integrated Lights-out or iLO, Dell’s Dell Remote Access Controller or DRAC and IBM’s Remote Supervisor Adapter (RSA) are a few to list. The above listed modules are vendor specific and proprietary. IPMI whereas is vendor-neutral and cross-platform. It is available on Linux distros. The functionality of IPMI can be accessed via IPMItool. IPMItool is a command prompt, which is used to manage IPMI-enabled devices. IPMItool helps in managing the ...
Read more

GP - SQL Joins

Image
Available Join Types? Row Elimination Minimize Data Movement Join Implementation Seen in Query Plans Join Types: Inner Join Resulting data set is obtained from joining two tables on a common column Each row in left table is compared with each row in right table Matching rows will be present in result set Most commonly used Also know has Simple Join or EQUI-Join Left Outer Join Returns all rows from the left table even if there is no matching rows in right table. Will also get the matching rows Rows that are not matched in the right table will not be included in the result set Right Outer Join This is similar to left outer join, just need to flip the join Full Outer Join Will return all rows from both the tables where there is a match We will receive a NULL for rows which don’t match Cross Join Which is also called has Cartesian products Result set will have all rows on the left table paired with all rows on the right table Exam...
Read more

Greenplum Architecture - Brief

Image
Pivotal Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads. MPP (also known as a shared nothing architecture) refers to systems with two or more processors that cooperate to carry out an operation, each processor with its own memory, operating system and disks. Greenplum uses this high-performance system architecture to distribute the load of multi-terabyte data warehouses, and can use all of a system's resources in parallel to process a query. Greenplum Database is based on PostgreSQL open-source technology. It is essentially several PostgreSQL database instances acting together as one cohesive database management system (DBMS). It is based on PostgreSQL 8.2.15, and in most cases is very similar to PostgreSQL with regard to SQL support, features, configuration options, and end-user functionality. Database users interact with ...
Read more