- Blog
- Blog
- Homepage
- Homepage
-
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
-
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 under the schema name JENNIFER,…
-
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 of UDF output table. Doing…
-
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 most important for complex queries,…
-
DB2 PLAN_Bind Real Concept
DB2 PLAN bind to execute DB2 programs in more than one sub system
-
DB2 Sub-system Vs. Instance: Top Differences
DB2 Subsystem In DB2 S/390, a DB2 subsystem provides a separate DB2 environment similar to a DB2 ULWO instance. Several DB2 S/390 subsystems can be installed in the same machine logical partition (LPAR), and they can only communicate with each other through the Distributed Data Facility (DDF). (Data sharing provides another way that DB2 subsystems…
-
SQL: Truncate Vs Delete in DB2
These 5 key differences in DB2 for TRUNCATE and DELETE help to understand much better of their functionality. A good refresher for DB2 developers.
Srinimf 
You must be logged in to post a comment.