Srini

CICS CEMT SET – How to Use Correctly

CEMT is Master Terminal Transaction in CICS. With the CEMT transaction, you can change the status for various resources such as Program, Mapset, File, Queue, Task, Terminal, and Transaction. CICS CEMT Command Examples You can use CEMT to set the File. Program, Queue, Task, Terminal, and Transaction. CEMT SET FILE(name) { ENABLED | DISABLED }…

AWS EC2 Instance STOP Vs Terminate

AWS instance Stop and Terminate options are not the same. Here’re the reasons with an explanation.

DB2 5 Effective Ways to Tune SQL Queries

DB2 SQL query performance tuning ideas. Here’re the ways that you can use.

SQL Query How to get Datediff in MySQL

Here’s SQL Query you can get Year from two DATEs. You can achieve this with DATEDIFF() function in MySQL.

Linux How To Understand These BOOT, START, SHUTDOWN

Here are ideas on how to use STOP, START, SHUTDOWN, BOOT mindfully on internal processes of Linux operating systems.

How to Define Various VSAM Clusters with IDCAMS

IDCAMS DEFINE Utility you can use to define VSAM files. Here are the parameters to consider while creating them.

How to Join 3 Tables—Without Join Keyword

Sample SQL Query to Join three tables with WHERE clause. It is Tricky SQL query helpful for interviews.

SQL Query: How to Use LOCATE and Substring Correctly

Here are SQL queries to use the SUBSTRING function along with LOCATE function. LOCATE gives position, and SUBSTRING uses that for the start position.

6 Beginner’s Python Interview Questions

Here are the python technical interview questions helpful for your next interview.

Python Logic to use tell() and seek()

In Python, both tell and seek functions help you get the data from a file. How to use these explained on how to use in your current project.

11 Kafka Admin Interview Questions

You can learn interview questions for the Kafka administrator role here. The questions covered prime points of the Kafka server.

Understanding SQL Set Operators: UNION, INTERSECT, MINUS

Here are top rules of set operators in SQL with examples