Dear Readers, Teradata provides views/functions that can help us in finding out the sessions running on the system and additional information about them like : User who is running the session Default database for the session Mode of the session Client Operating system Calendar name… Read More
Dear Readers, In this article, we will see Teradata Logical Operators. Operators are symbols or words that cause an ‘operation’ to occur on one or more elements called ‘operands’. Logical expressions combine operands and operators to produce a Boolean (True/False) result. These expressions can be… Read More
Dear Readers, Let’s understand what the date/time functions in teradata are and different operations associated with them. How is the date stored in Teradata ? Dates are stored as integer internally using the following formula. ((YEAR – 1900) * 10000) + (MONTH * 100) +… Read More
Dear Readers, In this article, we will see BTEQ TIPS Question :How to display more than 100 columns in BTEQ ? Answer: BTEQ Export defaults to a maximum of 100 columns to be SELECTED in the SELECT statement. Hence, when we try to run… Read More
SHOWLOCKS UTILITY Dear Readers. In this article ,we will see SHOWLOCKS UTILITY The Show Locks utility, showlocks, provides information about Host Utility (HUT) locks placed on databases and tables by the Archive/Recovery (ARC) utility during database operations. These locks might interfere with application processing and… Read More
VARIOUS TABLES IN TERADATA Dear Readers. In this article ,we will see VARIOUS TABLES IN TERADATA Teradata supports the following table types to hold temporary data. Derived Table Volatile Table Global Temporary Table Derived Table Derived tables are created, used and dropped within a query.… Read More
STATISTICS COLLECTIONS AND RECOMMENDATIONS Dear Readers. In this article ,we will see STATISTICS COLLECTIONS AND RECOMMENDATIONS Statistical information is vital for the optimizer when it builds query plans. But collecting statistics can involve time and resources. By understanding and combining several different statistics gathering techniques,… Read More
RESOURCE USAGE DATA/TABLES IN TERADATA Dear Readers. In this article ,we will see RESOURCE USAGE DATA/TABLES IN TERADATA Overview Resource usage data is stored in system tables and views in the DBC database. Macros installed with Teradata Database generate reports that display the data. To… Read More
ROW_NUMBER FUNCTION IN TERADATA Dear Readers. In this article ,we will see ROW_NUMBER FUNCTION IN TERADATA Purpose Returns the sequential row number, where the first row is number one, of the row within its window partition according to the window ordering of the window. Type… Read More
SECURE ZONES ADMINISTRATION IN TERADATA Dear Readers. In this article ,we will see SECURE ZONES ADMINISTRATION IN TERADATA A “Secure Zone” on a Teradata system typically contains multiple databases and users under a single database or user (referred to as the ‘root’ of that zone).… Read More
REGEXP_SUBSTR IN TERADATA Dear Readers. In this article ,we will see REGEXP_SUBSTR IN TERADATA Purpose Extracts a substring from source_string that matches a regular expression specified by regexp_string. REGEXP_SUBSTR supports 2, 3, 4, or 5 parameters. Syntax Where, TD_SYSFNLIB : the name of the database… Read More
REG_REPLACE IN TERADATA Dear Readers. In this article ,we will see REG_REPLACE IN TERADATA Purpose Replaces portions of source_string that match regexp_string with the replace_string. REGEXP_REPLACE supports 2, 3, 4, 5, or 6 parameters. Syntax Where, TD_SYSFNLIB : the name of the database where the… Read More
REGEXP_INSTR IN TERADATA In this article you will get to know the REGEXP_INSTR IN TERADATA Purpose Searches source_string for a match to regexp_string. REGEXP_INSTR supports 2, 3, 4, 5, or 6 parameters. Syntax Where, TD_SYSFNLIB : the name of the database where the function is… Read More
RECOVERY MANAGER IN TERADATA Dear Readers, In this article ,we will see RECOVERY MANAGER IN TERADATA The Recovery Manager utility, rcvmanager, monitors and provides information about the progress of a Teradata Database system in recovery, including transaction rollbacks, because of a Teradata Database system crash… Read More
LEFT OVER SPOOL IN TERADATA In this article you will get to know the LEFT OVER SPOOL IN TERADATA Spool tables are temporary work tables which are created and dropped as queries are executed. It is the job of the database software – not the… Read More
PROFILES IN TERADATA In this article you will get to know the PROFILES IN TERADATA About Profiles You can create profiles to define resource parameters for groups of users with similar needs instead of defining them for each individual user. Then list the profile in… Read More
Network issue during Oracle 12c RAC installation In this article, I will share the two issues which I have faced during the time of cloning machine in Oracle 12c RAC Installation. Issue 1)When the clone has been completed then I was tried to power on… Read More
RANK FUNCTION IN TERADATA In this article you will get to know the RANK FUNCTION IN TERADATA Purpose Returns the rank (1 … n) of all the rows in the group by the value of sort_expression list, with the same sort_expression values receiving the same… Read More
In this article, we will see the step by step SSH Connectivity methods in Oracle RAC. We will look at the below methods to do the SSH connectivity across the cluster. Manual User Equivalence (Manual Method) sh (Oracle Method) Automatic User Equivalence (GUI Method) Manual… Read More
IPE ( INCREMENTAL PLANNING EXECUTION ) In this article, we will see the IPE ( INCREMENTAL PLANNING EXECUTION ) The data that the Optimizer acquires from base statistics and demographics, derived statistics, cost formulas, entropy‑based algorithms, and other advanced techniques is referred to as static… Read More
