-
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 ⇢
-
DB2 Catalog Tables List
DB2 most important catalog tables to your reference. Read More ⇢
-
S0C1- Error From DB2 Sub program
In my recent development I got S0c1 error from my sub program. I checked all the program, but no clue. The reason for S0c1 is DD name missing or Load not found. In our case, we forgot to give correct Load in the JCL. Then we changed Load. Program executed… Read More ⇢
Srinimf 
You must be logged in to post a comment.