-
DB2: List of Top Table Spaces Quick Tutorial
Revolving Table spaces all information you need to know. Read More ⇢
-
Intertest – CICS Programs Debugger
CA InterTest for CICS is an interactive testing and debugging product for CICS applications written in COBOL, PL/1, and Assembler. You can download free user guides here. Read More ⇢
-
DB2: How to get Timestamp from Sysdummy1
The best SQL query to select Timestamp from sysdummy1 table. Read more with example. Read More ⇢
-
IBM Debugger Complete Tutorial
IBM debugger tool commands and setup for Mainframe projects. You can use it for debugging purpose. Read More ⇢
-
DB2: Here is All About Explain Plan
Tutorial on explain plan in DB2. Covers the use of Explain in tuning the performance. Read More ⇢
-
Teradata Real Database to Practice Online
The best resources that available to learn and practice teradata Quickly. Read More ⇢
-
SQL: GROUP BY Preferable than DISTINCT Why
We should not use DISTINCT in SQL query, it takes more up. Select distict ename,enum from emp where ename=’krishna’ and enum=1000 The alternative way is: Select ename,enum from emp where ename=’krishna’ and enum=1000 group by ename,enum Read More ⇢
-
DB2 v11 SQL: Remove Duplicates Enhancement
Enhanced duplicate removal: – Lots of queries require duplicate removal: e.g. DISTINCT, GROUP BY, etc. – Dup elimination via sorting can be expensive – New techniques: Index duplicate removal, early out Index duplicate removal: One feature that the IDUG team has been investigating is improvements to Unique/DISTINCT and GROUP BY… Read More ⇢
-
DB2 SQL Join: Here are Best Practices
Top performance tuning tips you need to follow while writing SQL queries using JOINS. Read more. Read More ⇢
Srinimf 