-
13 Phases DB2 Load Utility
DB2 Load utility once execution starts it completes in 13 stages. Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
How to Resolve SQL-904 Error Quickly
Resolution to fix DB2 SQL error -904 in mainframe projects. Read More ⇢
-
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… Read More ⇢
-
How to Use CEMT in CICS to Close a File
Here is sample code to close a file in CICS using CEMT Read More ⇢
-
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… Read More ⇢
-
A career in Cloud Security
Career opportunities in Cloud Security Read More ⇢
-
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. Read More ⇢
Srinimf 