Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • 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.

  • 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 success fully without S0c1 error.…

  • How to Purge CICS Failed Transaction

    CEMT I TA(*) It will list all the task and you have to give fpg(force purge) against the transaction… Tas(0001230) Tra(CEDA)           Sus Tas Pri( 255 )        fpg Sta(TO) Use(A251806 ) Uow(C7357B70963BF140) Hty(ZC      ) Related Posts Mainframe|CICS -Tips CICS Admin commands