TERADATA DBA Articles

Share via:
Dear Readers,

Please check below articles to get good knowledge on TERADATA DBA.

S.No
ARTICLE LINK DESCRIPTION
1 https://www.ktexperts.com/csv-function-in-teradata/ CSV FUNCTION IN TERADATA
2 https://www.ktexperts.com/chr-function-in-teradata/ CHR FUNCTION IN TERADATA
3 https://www.ktexperts.com/aggregate-udf-in-teradata/ AGGREGATE UDF IN TERADATA
4 https://www.ktexperts.com/backup-types-in-teradata/ BACKUP TYPES IN TERADATA
5 https://www.ktexperts.com/char2hexint-function-in-teradata/ CHAR2HEXINT FUNCTION IN TERADATA
6 https://www.ktexperts.com/csvld-function-in-teradata/ CSVLD FUNCTION IN TERADATA
7 https://www.ktexperts.com/dsa-incremental-restore-in-teradata/ DSA INCREMENTAL RESTORE IN TERADATA
8 https://www.ktexperts.com/editdistance-function-in-teradata/ EDITDISTANCE FUNCTION IN TERADATA
9 https://www.ktexperts.com/index-function-in-teradata/ INDEX FUNCTION IN TERADATA
10 https://www.ktexperts.com/upper-function-in-teradata/ UPPER FUNCTION IN TERADATA
11 https://www.ktexperts.com/trim-function-in-teradata/ TRIM FUNCTION IN TERADATA
12 https://www.ktexperts.com/translate_chk-in-teradata/ TRANSLATE_CHK IN TERADATA
13 https://www.ktexperts.com/translate-function-in-teradata/ TRANSLATE FUNCTION IN TERADATA
14 https://www.ktexperts.com/td_unpivot-in-teradata/ TD_UNPIVOT IN TERADATA
15 https://www.ktexperts.com/substring-substr-in-teradata/ SUBSTRING/SUBSTR IN TERADATA
16 https://www.ktexperts.com/strok_split_to_table-in-teradata/ STROK_SPLIT_TO_TABLE IN TERADATA
17 https://www.ktexperts.com/strok-function-in-teradata/ STROK FUNCTION IN TERADATA
18 https://www.ktexperts.com/string_cs-function-in-teradata/ STRING_CS FUNCTION IN TERADATA
19 https://www.ktexperts.com/soundex-function-in-teradata/ SOUNDEX FUNCTION IN TERADATA
20 https://www.ktexperts.com/scalar-udf-in-teradata/ SCALAR UDF IN TERADATA
21 https://www.ktexperts.com/rtrim-function-in-teradata/ RTRIM FUNCTION IN TERADATA
22 https://www.ktexperts.com/rpad-function-in-teradata/ RPAD FUNCTION IN TERADATA
23 https://www.ktexperts.com/regexp_split_to_table-in-teradata/ REGEXP_SPLIT_TO_TABLE IN TERADATA
24 https://www.ktexperts.com/regexp_similar-in-teradata/ REGEXP_SIMILAR IN TERADATA
25 https://www.ktexperts.com/position-function-in-teradata/ POSITION FUNCTION IN TERADATA
26 https://www.ktexperts.com/otranslate-function-in-teradata/ OTRANSLATE FUNCTION IN TERADATA
27 https://www.ktexperts.com/oreplace-function-in-teradata/ OREPLACE FUNCTION IN TERADATA
28 https://www.ktexperts.com/ltrim-function-in-teradata/ LTRIM FUNCTION IN TERADATA
29 https://www.ktexperts.com/length-function-in-teradata/ LENGTH FUNCTION IN TERADATA
30 https://www.ktexperts.com/instr-function-in-teradata/ INSTR FUNCTION IN TERADATA
31 https://www.ktexperts.com/initcap-function-in-teradata/ INITCAP FUNCTION IN TERADATA
32 https://www.ktexperts.com/coalesce-expression-in-teradata/ COALESCE EXPRESSION IN TERADATA
33 https://www.ktexperts.com/tbblc-temperature-based-block-level-compression-in-teradata/

TBBLC ( TEMPERATURE BASED BLOCK LEVEL COMPRESSION )IN TERADATA

34 https://www.ktexperts.com/teradata-16-20-dbscontrol-compression-fields/ TERADATA 16.20 DBSCONTROL COMPRESSION FIELDS
35 https://www.ktexperts.com/%e2%80%8bhow-to-create-a-new-contiguous-map-which-is-subset-of-an-existing-contiguous-map/ ​HOW TO CREATE A NEW CONTIGUOUS MAP WHICH IS SUBSET OF AN EXISTING CONTIGUOUS MAP
36 https://www.ktexperts.com/queue-tables/ QUEUE TABLES
37 https://www.ktexperts.com/restricted-words-in-teradata/ RESTRICTED WORDS IN TERADATA
38 https://www.ktexperts.com/teradata-16-20-dbscontrol-general-fields/ TERADATA 16.20 DBSCONTROL GENERAL FIELDS
39 https://www.ktexperts.com/teradata-16-20-dbscontrol-checksum-fields/ TERADATA 16.20 DBSCONTROL CHECKSUM FIELDS
40 https://www.ktexperts.com/teradata-15-10-dbscontrol-general-fields/ TERADATA 15.10 DBSCONTROL GENERAL FIELDS
41 https://www.ktexperts.com/teradata-16-20-dbscontrol-statistics-fields/ TERADATA 16.20 DBSCONTROL STATISTICS FIELDS
42 https://www.ktexperts.com/performance-fields-in-teradata-15-10/ PERFORMANCE FIELDS IN TERADATA 15.10
43 https://www.ktexperts.com/pde-state-down-tdmaint/ PDE STATE – DOWN/TDMAINT
44 https://www.ktexperts.com/password-expiration-in-teradata/ PASSWORD EXPIRATION IN TERADATA
45 https://www.ktexperts.com/optimizer-statistics-fields-in-td-14-10-and-15-0/ OPTIMIZER STATISTICS FIELDS IN TD 14.10 AND 15.0
46 https://www.ktexperts.com/optimizer-statistics-fields-in-15-10-16-0-16-10/ OPTIMIZER STATISTICS FIELDS IN 15.10, 16.0, 16.10
47 https://www.ktexperts.com/new-features-introduced-in-teradata-different-versions/ NEW FEATURES INTRODUCED IN TERADATA DIFFERENT VERSIONS
48 https://www.ktexperts.com/lob-functions-in-teradata/ LOB FUNCTIONS IN TERADATA
49 https://www.ktexperts.com/information-on-maps/ INFORMATION ON MAPS
50 https://www.ktexperts.com/get-blc-compression-ratio-using-sql/ GET BLC COMPRESSION RATIO USING SQL
51 https://www.ktexperts.com/how-to-identify-primary-amp-on-table-using-mhm-feature/ HOW TO IDENTIFY PRIMARY AMP ON TABLE USING MHM FEATURE?
52 https://www.ktexperts.com/gtwcontrol-utility/ GTWCONTROL UTILITY
53 https://www.ktexperts.com/dbs-control-record-compression-block-level-fields/ DBS CONTROL RECORD – COMPRESSION (BLOCK LEVEL) FIELDS
54 https://www.ktexperts.com/find-and-delete-duplicates-from-a-table/ FIND AND DELETE DUPLICATES FROM A TABLE
55 https://www.ktexperts.com/dbs-control-record-file-system-fields/ DBS CONTROL RECORD – FILE SYSTEM FIELDS
56 https://www.ktexperts.com/dbs-control-record-disk-i-o-integrity-checksum-fields/ DBS CONTROL RECORD – DISK I/O INTEGRITY (CHECKSUM) FIELDS
57 https://www.ktexperts.com/top-function-in-teradata/ TOP FUNCTION IN TERADATA
58 https://www.ktexperts.com/teradata-calendar-overview/ TERADATA CALENDAR OVERVIEW
59 https://www.ktexperts.com/teradata-calendar-functions/ TERADATA CALENDAR FUNCTIONS
60 https://www.ktexperts.com/teradata-abort-codes-and-meaning/ TERADATA ABORT CODES AND MEANING
61 https://www.ktexperts.com/roles-in-teradata/ ROLES IN TERADATA
62 https://www.ktexperts.com/queries-to-check-current-sessions-in-teradata/ QUERIES TO CHECK CURRENT SESSIONS IN TERADATA
63 https://www.ktexperts.com/teradata-logical-operators/ TERADATA LOGICAL OPERATORS
64 https://www.ktexperts.com/date-time-functions-in-teradata/ DATE/TIME FUNCTIONS IN TERADATA
65 https://www.ktexperts.com/bteq-tips-in-teradata/ BTEQ TIPS IN TERADATA
66 https://www.ktexperts.com/showlocks-utility/ SHOWLOCKS UTILITY
67 https://www.ktexperts.com/various-tables-in-teradata/ VARIOUS TABLES IN TERADATA
68 https://www.ktexperts.com/statistics-collections-and-recommendations/ STATISTICS COLLECTIONS AND RECOMMENDATIONS
69 https://www.ktexperts.com/resource-usage-data-tables-in-teradata/ RESOURCE USAGE DATA/TABLES IN TERADATA
70 https://www.ktexperts.com/row_number-function-in-teradata/ ROW_NUMBER FUNCTION IN TERADATA
71 https://www.ktexperts.com/secure-zones-administration-in-teradata/ SECURE ZONES ADMINISTRATION IN TERADATA
72 https://www.ktexperts.com/regexp_substr-in-teradata/ REGEXP_SUBSTR IN TERADATA
73 https://www.ktexperts.com/reg_replace-in-teradata/ REG_REPLACE IN TERADATA
74 https://www.ktexperts.com/regexp_instr-in-teradata/ REGEXP_INSTR IN TERADATA
75 https://www.ktexperts.com/recovery-manager-in-teradata/ RECOVERY MANAGER IN TERADATA
76 https://www.ktexperts.com/left-over-spool-in-teradata/ LEFT OVER SPOOL IN TERADATA
77 https://www.ktexperts.com/profiles-in-teradata/ PROFILES IN TERADATA
78 https://www.ktexperts.com/rank-function-in-teradata/ RANK FUNCTION IN TERADATA
79 https://www.ktexperts.com/ipe-incremental-planning-execution/ IPE ( INCREMENTAL PLANNING EXECUTION )
80 https://www.ktexperts.com/packdisk-in-teradata/ PACKDISK IN TERADATA
81 https://www.ktexperts.com/bteq-in-teradata/ BTEQ IN TERADATA
82 https://www.ktexperts.com/explain-plan-in-teradata/ EXPLAIN PLAN IN TERADATA
83 https://www.ktexperts.com/difference-between-arc-and-dsa/ DIFFERENCE BETWEEN ARC AND DSA
84 https://www.ktexperts.com/teradata-space-concepts-and-space-utilities/ TERADATA SPACE CONCEPTS AND SPACE UTILITIES
85 https://www.ktexperts.com/join-index-in-teradata/ JOIN INDEX IN TERADATA
86 https://www.ktexperts.com/transient-journaling/ TRANSIENT JOURNALING
87 https://www.ktexperts.com/hash-index-in-teradata/ HASH INDEX IN TERADATA
88 https://www.ktexperts.com/show-locks-utility/ SHOW LOCKS UTILITY
89 https://www.ktexperts.com/tdwm-throttle-statistics/ TDWM Throttle Statistics
90 https://www.ktexperts.com/access-rights-in-teradata/ ACCESS RIGHTS IN TERADATA
91 https://www.ktexperts.com/partitioned-primary-index-in-teradata/ PARTITIONED PRIMARY INDEX IN TERADATA
92 https://www.ktexperts.com/compression-in-teradata/ COMPRESSION IN TERADATA
93 https://www.ktexperts.com/block-level-compression-in-teradata/ BLOCK LEVEL COMPRESSION IN TERADATA
94 https://www.ktexperts.com/permanent-journal/ PERMANENT JOURNAL
95 https://www.ktexperts.com/nopi-no-primary-index-table-in-teradata/ NOPI( NO PRIMARY INDEX) TABLE IN TERADATA
96 https://www.ktexperts.com/secondary-index-in-teradata/ SECONDARY INDEX IN TERADATA
97 https://www.ktexperts.com/check-table-in-teradata/ CHECK TABLE IN TERADATA
98 https://www.ktexperts.com/multiload-utility-in-teradata/ MULTILOAD UTILITY IN TERADATA
99 https://www.ktexperts.com/primary-index-in-teradata/ PRIMARY INDEX IN TERADATA
100 https://www.ktexperts.com/etl-and-data-transfer-utilities-in-teradata/ ETL AND DATA TRANSFER UTILITIES IN TERADATA
101 https://www.ktexperts.com/fast-export-utility-in-teradata/ FAST EXPORT UTILITY IN TERADATA
102 https://www.ktexperts.com/teradata-dba-useful-sqls/ TERADATA DBA – USEFUL SQLS
103 https://www.ktexperts.com/types-of-locks-in-teradata/ TYPES OF LOCKS IN TERADATA
104 https://www.ktexperts.com/tset/ TSET
105 https://www.ktexperts.com/how-to-collect-tset/ HOW TO COLLECT TSET
106 https://www.ktexperts.com/features-and-high-level-architecture-of-teradata/ FEATURES AND HIGH LEVEL ARCHITECTURE OF TERADATA
107 https://www.ktexperts.com/teradata-snapshot-dumps-down-region-and-down-table/ TERADATA SNAPSHOT DUMPS, DOWN REGION AND DOWN TABLE
108 https://www.ktexperts.com/teradata-dbscontrol-parameters-and-system-level-tunables/ TERADATA: DBSCONTROL PARAMETERS AND SYSTEM LEVEL TUNABLES
109 https://www.ktexperts.com/teradata-secondary-indexes-in-teradata/ TERADATA: SECONDARY INDEXES IN TERADATA
110 https://www.ktexperts.com/journals-and-recovery-in-teradata/ TERADATA JOURNALS AND RECOVERY IN TERADATA
111 https://www.ktexperts.com/teradata-table-skewness/ TERADATA TERADATA TABLE SKEWNESS
112 https://www.ktexperts.com/teradata-types-of-primary-indexes-upi-and-nupi/ TERADATA TYPES OF PRIMARY INDEXES (UPI AND NUPI)
113 https://www.ktexperts.com/teradata-data-distribution-and-primary-index/ TERADATA DATA DISTRIBUTION AND PRIMARY INDEX
114 https://www.ktexperts.com/teradata-finding-the-health-of-vprocs-and-the-number-of-amps-in-a-teradata-system-and-other-basic-commands/ TERADATA FINDING THE HEALTH OF VPROCS AND THE NUMBER OF AMPS IN A TERADATA SYSTEM AND OTHER BASIC COMMANDS
115 https://www.ktexperts.com/teradata-teradata-basic-terminologies-and-space-allocation/ TERADATA TERADATA BASIC TERMINOLOGIES AND SPACE ALLOCATION
116 https://www.ktexperts.com/teradata-detailed-teradata-architecture-and-query-flow/ TERADATA DETAILED TERADATA ARCHITECTURE AND QUERY FLOW
117 https://www.ktexperts.com/teradata-introduction-to-teradata-and-its-offerings/ TERADATA INTRODUCTION TO TERADATA AND ITS OFFERINGS

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment