Srini

JCL – How to Execute Only Even Steps

Here’s a resolution to execute only even steps in the JCL job. The resolution is explained in detail.

Encrypted Vs Vaultless Vs Vault-Based Tokenization

Here’re differences between Vaultless, Vault-based and Encryption tokenization methods for PCI, PII and PHI.

AWS Security group Vs Network ACL – Top Differences

Here’re the differences between the Security group and Network ACL. It’s useful for your interviews and projects.

How to Check Your [DB2 Utility] Job is Completed

Here’s a way you can use to check DB2 utility job completion status in mainframe Z/Os.

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.