Articles

SQL SERVER Articles

SQL SERVER Articles Dear Readers, Please check below articles to get good knowledge on SQL SERVER. SNO DESCRIPTION ARTICLE LINK 1 SQL Server – Issue to view Alwayson Health Events https://www.ktexperts.com/sql-server-issue-to-view-alwayson-health-events/ 2 Script to copy one particular database role from one SQL server to another… Read More

TERADATA DBA Articles

TERADATA DBA Articles Dear Readers, Please check below articles to get good knowledge on TERADATA DBA. SNO DESCRIPTION ARTICLE LINK 1 Teradata dbscontrol parameters and system level tunables https://www.ktexperts.com/multiload-utility-in-teradata/ 2 Teradata Secondary Indexes in Teradata https://www.ktexperts.com/primary-index-in-teradata/ 1 MULTILOAD UTILITY in Teradata https://www.ktexperts.com/multiload-utility-in-teradata/ 2 PRIMARY INDEX… Read More

FAST EXPORT UTILITY IN TERADATA

FAST EXPORT UTILITY IN TERADATA FastExport is a command-driven utility that uses multiple sessions to quickly transfer large amounts of data from tables and views of Teradata Database to a client-based application. Data can be exported from any table or view where the SELECT privilege… Read More

Teradata DBA – USEFUL SQLs

Teradata DBA – USEFUL SQLs This article contains all the basic queries needed by a DBA to collect different kind of information from the database. Table of Contents 1.Disk Space Total disk space Percent of disk space in use Percent of disk space free Percent… Read More

Types of Locks in Teradata

Types of Locks in Teradata  Locks are used to protect data integrity when multiple users try to access or change the same data simultaneously. This can be achieved by locking the target data. Example : Assuming user_1 is updating a table, so if user_2 tries… Read More

TSET

Dear Readers, In this article, we will learn about Tset. What is TSET ? TSET stands for Teradata System Emulation Tool. It is a tool that is used to collect a set of support files that help in troubleshooting issues. It allows you to emulate… Read More

How to collect TSET

How to collect TSET This article will provide instructions on exporting data and collecting TSET step-by-step (export & pack) Note : Please make sure the version of TSET installed on your PC or laptop is compatible with the currently running TDBMS version. TSET is required… Read More

SecureCRT Buttons for Default

Hello Reader In this article , we will cover SecureCRT Buttons for Default. ############Setting up Format (format): To convert invalid timestamp value and to check current date. alter session set nls_date_format=’MM/DD/YYYY HH24:MI:SS’; Session altered. ######### Instance Information (inst_info): This SQL outputs the information of instance… Read More

Shell Script to get EMAIL  alerts for STOPPED Processes in Oracle GoldenGate.

Hi Readers, Below article will help you on  Shell Script to get EMAIL  alerts for STOPPED Processes in Oracle GoldenGate. Script : [oracle@AWS1 ~]# cat GG_Stopped.sh export ORACLE_SID=orcl export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH:. export ORACLE_NET=$ORACLE_HOME/network/admin export GGS_HOME=/u01/app/oracle/product/ogg_src export LD_LIBRARY_PATH=$ORACLE_HOME/lib DBA_EMAIL=ktexperts@gmail.com logpath=”/tmp” cd $logpath logfile=”$logpath/output.txt” #… Read More

Shell Script to get EMAIL alerts for ABENDED PROCESSES in Oracle GoldenGate

Hi Readers, Below article will help you on  Shell Script to get EMAIL  alerts for ABENDED Processes in Oracle GoldenGate. Script :  [oracle@AWS1 ~]# cat GG_Abend.sh export ORACLE_SID=orcl export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH:. export ORACLE_NET=$ORACLE_HOME/network/admin export GGS_HOME=/u01/app/oracle/product/ogg_src export LD_LIBRARY_PATH=$ORACLE_HOME/lib DBA_EMAIL=ktexperts@gmail.com logpath=”/tmp” cd $logpath logfile=”$logpath/output.txt”… Read More

More Latest News »