-
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 Read More ⇢
-
How to Connect CICS to DB2 Top Ideas
Connect CICS to DB2 top ideas you need Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
CICS: GETMAIN Vs. Load Top Differences
LOAD vs GETMAIN differences you must read before you start your program Read More ⇢
-
RDBMS: Schema Vs Instance Top Differences
Schema in RDBMS A schema is a collection of named database objects. Schemas provide a way to logically classify objects such as tables, views, triggers, routines, or packages. A schema name is used as the first part of a two-part object name. For example, if the EMPLOYEE table is created… Read More ⇢
-
DB2 V11- Analytics and Bigdata Features
DB2 11 also boasts new features for supporting big data and analytical processing. Probably the biggest is the ability to support Hadoop access. DB2 11 can be used to enable applications to easily and efficiently access Hadoop data sources using the generic table UDF capability to create a variable shape… Read More ⇢
-
How to Use Fetch First ‘n’ Rows Best Examples
SQL Query On How to Use Fetch SELECT LASTNAME, FIRSTNAME, EMPNO, SALARYFROM EMPORDER BY SALARY DESCFETCH FIRST 20 ROWS ONLY; How To use FETCH FIRST n ROWS ONLY within a subquery. SELECT * FROM EMPWHERE EMPNO IN (SELECT RESPEMP FROM PROJECTORDER BY PROJNO FETCH FIRST 3 ROWS ONLY) Query transformations become… Read More ⇢
-
DB2 PLAN_Bind Real Concept
DB2 PLAN bind to execute DB2 programs in more than one sub system Read More ⇢
Srinimf 