Srini

DB2: Performance Tuning A Quick Tutorial

Useful Db2 performance tuning interviews questions

DB2 Architecture: An Overview

DB2 Architecture explanation and its key features.

10 Techniques to Keep Ahead of Your Competition

Tips to beat competition at work. Read more.

How to Migrate DB2 to EC2 Cloud

How DB2 works from Cloud a real story.

6 Top Mainframe Vs. Cloud Differences

The top differences between Cloud computing and Mainframe explained in this post for your quick reference.

CICS: QUEUE Vs ITEM Top Differences

Item vs Queue top differences in CICS.

CICS-Map Splitting And Text Splitting Logic

Resources on Coding CICS-BMS Advanced mapping: Recently in our workshop we came an occassion to write complex CICS program. There are two options. One is Map splitting and another one is Text Splitting. Map Splitting: We have only one map, and data has to be displayed till end of the file. This is our requirement Logic is…

How to Add New VSAM File to CICS – DADM Utility

Here is a way to add new VSAM file to CICS using DADM utility.

13 Phases DB2 Load Utility

DB2 Load utility once execution starts it completes in 13 stages.

How to Check Trigger Details in SYSIBM Tables

When a trigger is created, DB2 creates a trigger package for the statements in the triggered action. The trigger package is recorded in SYSIBM.SYSPACKAGE and has the same name as the trigger. Before a trigger is created, it is good practice to ensure that there are no packages with the same name as the trigger being…

DB2: Index Rebuilt Error and Resolution

Recently in our workshop after submitting Load job we are getting error Index re-built. The reason is Load job is failed twice. And Table sapce went to recovery pending status. The below is an issue and resolution happened during DB2 LOAD process. How to do index rebuild? The REBUILD INDEX online utility reconstructs indexes or index partitions…

How to Resolve SQL-904 Error Quickly

Resolution to fix DB2 SQL error -904 in mainframe projects.