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 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
Dear Readers, In this article, we will learn about MULTILOAD UTILITY in Teradata MultiLoad can load multiple tables at a time and it can also perform different types of tasks such as INSERT, DELETE, UPDATE and UPSERT. It can load up to 5 tables at… Read More
PRIMARY INDEX IN TERADATA Dear Readers, In this article, we will learn about PRIMARY INDEX IN TERADATA In Teradata, Parallelism is one of the main feature. As we already know AMPs are the one which perform the actual operation of the query. So, to maintain… Read More
ETL and Data Transfer utilities in Teradata Dear Readers, In this article, we will learn about ETL and Data Transfer utilities in Teradata Teradata database has various techniques to load the data into tables. Below are the 5 commonly used load utilities. Fast load Multi… Read More
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 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 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
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 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
Hi Readers, In this article,we will see Migrating Table data from MySQL to Oracle Using SQL* LOADER. Step 1 : Connect to Mysql DB and create a table [root@ip-172-31-46-32 ~]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or… Read More
Dear Readers, in this article , we will see, Connecting to MySQL without entering the password using mysql_config_editor The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named.mylogin.cnf. The file location is the %APPDATA%\MySQL directory on Windows and the… Read More
Dear Readers, In this article, we will understand the step by step Migration from Oracle to SQL Server. To complete this configuration we need to follow below steps. I am using MSSQL Server 2012 and Oracle 12c R1 for this activity. You can use any… Read More
There is no excerpt because this is a protected post.
Invoke Linux GUI On windows using Xming software Today we will understand how to invoke Linux GUI on windows using Xming software. To complete this configuration we need to follow the below steps and I will also share the issue and its resolution which I… Read More
Hello Readers, The Volunteers contributing to our website are expertized in several various technologies. The blend of our Volunteers is so impressive as to how they collaborate with the team and produce immense quality content. Their experience is quite an asset to the success that… Read More
Hello Readers, In this article, we will learn Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes Step 1 : Check GoldenGate processes GGSCI (ktexperts_AWS1) 1> Info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING… Read More
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
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
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
