- Blog
- Blog
- Homepage
- Homepage
-
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.
-
Here’s Hash Index Real Purpose in DB2
We all know that, in DB2, there are different data access methods present. Either by using index are scanning methods. Hash index is a new technique in DB2 V10. The concept is not new this is already being used in Teradata RDBMS and an IMS database. What is the Hash index? When creating a Table…
-
How to Use CEMT in CICS to Close a File
Here is sample code to close a file in CICS using CEMT
-
Top Approaches to Modernize Mainframe
Coming year 2015 will be the year for legacy modernization. What are the things we need to consider for modernization? Best strategies in modernization. Once a company realizes the potential benefits of modernizing mainframe applications to the cloud, and moves beyond the fear of modernization, there are several modernization strategies to consider. And while the…
-
A career in Cloud Security
Career opportunities in Cloud Security
-
Teradata Unique Secondary Index USI
In Teradata the Unique secondary indexes can thus improve performance by avoiding the overhead of scanning all AMPs. Read more.
-
DB2 Catalog Tables List
DB2 most important catalog tables to your reference.