• 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

  • How to Connect CICS to DB2 Top Ideas

    Connect CICS to DB2 top ideas you need

  • DB2 Distributed Systems in Zo/S

    Distributed the term is very big and a lot of information needs to be considered. Although there are many other ways that distributed clients can access DB2, they are entering through other attach types, such as CICS, IMS, MQ, and RRS.  Distributed Systems These are beyond the scope of this presentation since they are subject…

  • How Autoinstall Works In CICS Without PPT Entry

    In CICS with AUTO INSTALL option we no need to define each program/map to PPT entry. If Autoinstall is yes, CICS will dynamically install the definition for program/map when requested. If AUTOINSTALL is active, whenever those programs/maps requested, the definitions will be installed by CICS dynamically. The following scenarios AUTOINSTALL works: EXEC CICS LINK EXEC…

  • CICS: GETMAIN Vs. Load Top Differences

    LOAD vs GETMAIN differences you must read before you start your program