Recent Updates: Tech.Jobs.Biz.Success

Visit For Recent Updates.

Already a Member? Log In to Your Account
This Blog Posts All Posts Directory Listings Articles

CICS-Map Splitting And Text Splitting Logic

12/21/2014 01:41:35 AM

Resources on Coding CICS-BMS Advanced mapping: Recently in our workshop we came an occassion to write complex CICS program. There are two options. One is Map splitting and another one is Text Splitting. Map Splitting: We have only one map, and data > read more

Adding New VSAM File in CICS – DADM Utility

12/19/2014 08:52:48 AM

The File Allocation Definition Add menu below can be used to add a file to the CA DADS Plus for CICS control file. APPLID A11IC4S6 CA-DADS/PLUS 4.0 DATE TIME FILE ALLOCATION DEFINITION ADD COMMAND ===> A TYPE ===> F NAME ===> FILE001 DSORG => UNAV PR > read more

Db2-Load Utility Executes in 13 Phases

12/18/2014 10:16:31 AM

UTILINIT -Performs initialization.RELOADLoads record types and writes temporary file records for indexes and foreign keys. RELOAD makes one pass through the sequential input data set. Check constraints are checked for each row. Internal commits provi > read more

Cobol-DB2 Trigger Package

12/17/2014 11:01:04 AM

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 ensur > read more

DB2- Index Rebuilt Error and Resolution

12/16/2014 09:58:57 AM

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. How to do index revuild? The REBUILD INDEX online utility reconstructs > read more

DB2 Load – Error -904 And Resolution

12/11/2014 09:38:37 AM

UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name. Suggestion: -904 is usually caused because a database utility job has started the desired DB2 object in uti > read more

DB2-Hash Index Functionality

12/04/2014 22:59:28 PM

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 in IMS datab > read more

CEMT – Use for Closing File

12/01/2014 19:03:07 PM

We can use CEMT to close file in CICS CEMT S File(file-name) CLOSE CEDA Commands: The CEDA CHECK command Use the CEDA CHECK command to check the consistency of a set of resource definitions on the CSD. The CEDA COPY command Use the CEDA COPY command > read more

Legacy Modernization – Mainframe

11/29/2014 01:01:13 AM

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 > read more

Best Salaries for Cloud Security

11/28/2014 23:42:41 PM

IT spending for security technologies will increase 46% in 2015, with cloud computing increasing 42% and business analytics investments up 38%. . Enterprise investments in storage will increase 36%, and for wireless & mobile, 35%. Cloud computing in > read more

Teradata – Unique Secondary Index(USI)

11/27/2014 19:32:17 PM

Syntax: CREATE UNIQUE INDEX (department) ON tbl_employee; If a Teradata SQL request uses secondary index values in a WHERE constraint, the optimizer may use the rowID in a secondary index subtable to access the qualifying rows in the data table. > read more

DB2 Catalog Tables

11/23/2014 09:05:01 AM

SYSIBM.SYSCONTROLS table The SYSIBM.SYSCONTROLS table contains one row for each row permission and column mask. SYSIBM.SYSCOPY table The SYSIBM.SYSCOPY table contains information needed for recovery. SYSIBM.SYSCTXTTRUSTATTRS table The SYSIBM.SYSCTXTT > read more

S0C1- Error From DB2 Sub program

11/19/2014 11:06:18 AM

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 exe > read more

CICS Purge Failed Transaction – Tops

11/13/2014 10:44:58 AM

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      ) > read more

Connecting CICS Region to Multiple DB2 Subsystems

11/11/2014 11:09:04 AM

Using the DB2 group attach facility When you are defining the connection between CICS® and DB2®, you can choose to have CICS connect to a specific DB2 subsystem. You can specify the name of this DB2 subsystem using the DB2ID attribute of the DB2CON > read more

DB2 ZO/S – Distributed Systems

11/02/2014 07:39:50 AM

Distributed the term is very big and lot of information need 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.  These are beyond > read more

CICS – Auto Install and No PPT Entry Needed

11/02/2014 01:05:09 AM

In CICS with AUTO INSTALL option we  no need to define each program/map to PPT entry. If Auto install is yes, CICS will dynamically installs definition for program/map when requested. If AUTOINSTALL is active, whenever those programs/maps requested, > read more

CICS – Getmain and Load

11/01/2014 09:36:58 AM

Coming to most important part of CICS architecture, there are two kinds of storage used: Storing data within transaction:  Transaction Work Area (TWA) – User storage acquired by EXEC CICS GETMAIN without SHARED option – COMMAREA in an EXEC CICS > read more

DBMS- Database Schema and Instance

11/01/2014 00:44:24 AM

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 EMP > read more

DB2 V11- Analytics and Bigdata Features

10/27/2014 20:26:36 PM

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 > read more

DB2- Fetch First N Rows Only

10/26/2014 08:43:16 AM


DB2 – PLAN Bind Same Program in Two Subsystems

10/24/2014 11:13:51 AM

> read more

Confusing SQL Queries With Dates

10/23/2014 02:01:47 AM

Query to get latest date: Select item, max(inventorydate) from table where inventorydate is < ‘6/30/2011′ Query to retrieve not more than 6 years from application date: Select item from table where appl_date >= (Currentdate – 6 Year > read more

DB2-Subsystem and Instance

10/22/2014 22:47:58 PM

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 > read more

Truncate and Delete in DB2

10/19/2014 07:49:06 AM

Truncate in DB2: It deletes all the rows from a table TRUNCATE TABLE INVENTORY DROP STORAGE IGNORE DELETE TRIGGERS; Delete in DB2: DELETE FROM TABLE TABLE_ONE; It also deletes rows from a table Difference between TRUNCATE and DELETE you can use follo > read more

Browse Tape File in Mainframe

10/17/2014 21:05:10 PM

We can use IEBGENER to copy tape file to Sequential file: //STEP01   EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=A //SYSUT1   DD DSN=J.TAPE.UST.A, //            DISP=SHR //SYSUT2   DD DSN=PQHL.DASD.UST.A, //         DISP=(NEW,CATLG,DELETE > read more

DB2-Identity Column

10/14/2014 10:44:12 AM

Defining an identity column on a new table: An identity column provides a way for DB2 to automatically generate a unique numeric value for each row that is added to the table. When creating a table where you know that you need to uniquely identify ea > read more


10/13/2014 11:37:56 AM

Originally posted on F1 for mainframes:RESTART LOGIC IN COBOL DB2 Program   Suppose you have a COBOL DB2 program, in which you are reading data from input file which has thousands of records and updating a DB2 table one record at a time.   Now you > read more

DB2 – SQL With Joins – Performance

10/12/2014 05:42:18 AM

Make sure there is an understanding of inner vs. outer joins. Many times SQL is written with Table1 outer joined to Table2, and then inner joined to Table3. The inner join being coded last can offset the exceptions that took place in the outer  join > read more

Super Package, Complex Package and Participating Package

10/10/2014 20:09:05 PM

Super Package: It can hold multiple participating packages. Both local and remote packages Complex Package: It can hold multiple participating packages. Both local and remote packages. Even it can hold super packages. Participating Package: A package > read more


10/05/2014 05:46:55 AM

Srinimf.Jobthread.Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: srinimf.jobthread > read more

Database Challenge – Show Your Knowledge |DB2, Oracle, Sybase

10/04/2014 01:26:33 AM

Databases are becoming more popular, and today’s ,, data world, analytics playing critical role. There are many databases in the market. Only few of them so popular. Every database, we can query it with SQL. It is a popular l > read more

DB2- Revolving Tablespaces|Rotating Partitions

10/03/2014 00:08:18 AM

DB2 naming standards These naming standards apply to DB2 running on a z/OS mainframe. Probably the first thing you notice about DB2 is the naming convention. DB2 names rarely fit in with the rest of the naming conventions in your site! They look like > read more

Intertest – CICS Programs Debugger

10/01/2014 10:41:45 AM

CICS INTERTEST GUIDE CICS ITST COMMANDSFiled under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: Intertest - CICS Programs Debug > read more

DB2 – Timestamp and Sysdummy1

09/29/2014 10:17:17 AM

SYSIBM.SYSDUMMY1 is an EBCDIC table, provided by DB2. It is used when we need to fetch data that is not in a table, For e.g. Current Date, Current Time etc.. Example >DB2 SELECT 2+3 FROM SYSIBM.SYSDUMMY1 Output: 1 ———– 5 1 rec > read more

IBM – Debugger Tool Setup And Commands

09/24/2014 10:25:27 AM

The following links will help: IBM Debugger Tool Setup Debugger Commands Filed under: Analytics, CICS, Data Warehousing & Tools, Easytrive, IMDB/DC, Mainframe, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: IBM - Debugger Tool Setup And Comma > read more

DB2-Performance Tuning | Explain Plan

09/22/2014 20:36:33 PM

DB2 EXPLAIN The primary function of the explain is to provide access path information for select statements. Information regarding delete, update, and insert statements are somewhat limited in information. For SQL statements referencing a single tabl > read more

Teradata – Online Practice

09/21/2014 03:58:39 AM

The following are good resources to start your Teradata. Practice Test Teradata knowledge Teradata Practice dumps Teradata QUIZ Teradata top 50 questions Teradata Mock certification Test Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing > read more


09/18/2014 10:31:36 AM

We should not use DISTINCT in SQL query, it takes more io. Select distict ename,enum from emp where ename=’krishna’ and enum=1000 The alternative way is: Select ename,enum from emp where ename=’krishna’ and enum=1000 group by > read more

DB2 V11 – New Technique Duplicate Removal

09/16/2014 21:32:13 PM

Enhanced duplicate removal: – Lots of queries require duplicate removal: e.g. DISTINCT, GROUP BY, etc. – Dup elimination via sorting can be expensive – New techniques: Index duplicate removal, early out Index duplicate removal: One feature that > read more

DB2- Joins Performance Tuning

09/15/2014 08:57:09 AM

Response time Response time is determined mostly by the number of rows participating in the join number of rows participating in the join Provide accurate join predicates Provide accurate join predicates ?? Never use a JOIN without a predicate Neve > read more

Teradata – Active Load

09/14/2014 05:57:55 AM

Active Load Teradata is able to load data actively and in a non-disruptive manner and, at the same time, process other workloads.Teradata delivers Active Load through methods that support continuous data loading. These include streaming from a queue, > read more

M204 – Model 204 Database

09/11/2014 10:38:43 AM

Model 204 is a database management system for IBM and compatible mainframe computers, “born” 1965 October 13, and first deployed in 1972. It incorporates a programming language and an environment for application development. Implemented in assemb > read more

How to Use Multiple Joins in DB2

09/10/2014 08:19:34 AM

The below is the best example to go ahead on multiple joins: SELECT m.f1, o.f1, s.f1 FROM Material m LEFT OUTER JOIN Catalog c ON m.MaterialName = c.MaterialName AND m.EffectiveDate = c.EffectiveDate AND c.MaterialType = ‘X1′ AND (c.Mater > read more

COBOL – SQLCA is Not Mandatory- Why

09/07/2014 23:47:42 PM

SQLCA –  Also called SQL communication is area, is not mandatory in COBOL Program. 01 SQLCA. 05 SQLCAID PIC X(8). 05 SQLCABC PIC S9(9) BINARY. 05 SQLCODE PIC S9(9) BINARY. 05 SQLERRM. 49 SQLERRML PIC S9(4) BINARY. 49 SQLERRMC PIC X(70). 05 SQL > read more

List of Mainframe User Companies Worldwide

09/06/2014 02:12:13 AM under: CICS, Mainframe, Quiz > read more

DB2- Partition By SQL Query

09/05/2014 22:24:21 PM

SQL> select * from Employee   2  / ID   FIRST_NAME LAST_NAME  START_DAT END_DATE      SALARY CITY       DESCRIPTION —- ———- ———- ——— ——— & > read more

Best JCL Interview Questions – Splitting Input File

09/04/2014 06:06:23 AM


DB2 – Functions POSSTR and LOCATE

09/03/2014 19:40:03 PM

POSSTR – DB2 Function Similar to the LOCATE function, but with the arguments reversed.POSSTR returns the position of the first occurrence of the second argument within the first argument. For example SELECT POSSTR(‘DATABASE ADMINISTRATION > read more

Maximum Limits On DB2

09/01/2014 10:41:04 AM

 Item  Limite  Longest alias, synonym, collection ID, correlation  name, statement name, or name of a column, cursor,  index, table, view, or table check constraint  18 bytes  Longest authorization name, package name, or name of  a plan, data > read more

Micro Focus COBOL With UNIX

08/27/2014 00:10:32 AM

The main functions of Object COBOL are presented to you through a menu displayed by the Object COBOL Development Environment. The menu is displayed at the bottom of the screen, and shows you which key to press to invoke the function you want. Central > read more

SQL – What Is An Index

08/26/2014 21:14:45 PM

This is a basic topic on SQL performance tuning: Simply put, an index is a pointer to data in a table. An index in a database is similar to an index in the back of a book. For example, if you want to reference all pages in a book that discuss a cer > read more

IMSDB – User (System) Abend Codes

08/26/2014 00:44:46 AM

0002 Explanation: When the IMS control region abnormally terminates, it forces this abend for active dependent regions. This abend can also occur after normal shutdown of the control region if a new dependent region attempts to start. System action: > read more

Srinimf.Jobthread | India,USA,World IT Jobs

08/25/2014 12:53:37 PM

http://srinimf.jobthread.comFiled under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Srinimf.Jobthread | India, USA, World IT Jobs > read more

SQL – Commit Keeps DBA Away

08/24/2014 21:56:42 PM

When performing batch transactions, you must know how often to perform a “commit.” “Controlling Transactions,” a COMMIT statement finalizes a transaction. A COMMIT saves a transaction or writes any changes to the applicable ta > read more

ResumesIndia Jobs | India IT Jobs

08/24/2014 09:54:16 AM

ResumesIndia Jobs > read more

5 Powerful Thoughts on SQL NULLs

08/24/2014 02:04:21 AM

NULL BASICS: An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero. A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL’s three-valued l > read more

CICS – Function Shipping

08/20/2014 22:10:34 PM

The following information contains guidance about parameters that are important in the definition of remote data resources that are to be accessed by function shipping. Those data resources are: Remote files Remote transient data queues Remote tempor > read more

Mainframe – SQL Challenge -1

08/19/2014 21:55:13 PM

Question 1: Get maximum salaries department wise? Sol: SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY DeptID Question 2: Write COBOL logic to get nth prime number? IDENTIFICATION DIVISION. PROGRAM-ID. PRIME. AUTHOR. XYZ. DATE-WRITTEN. JULY 2014. > read more

10 Points – Instream and Cataloged Procedures of JCL

08/18/2014 20:49:01 PM

There are many rules to modify a Instream or Cataloged procedures: I have given here important rules. In-stream Procedures : Do not place any JCL statements (other than the ones listed in this topic) or any JES2 or JES3 control statements in the proc > read more

3 Different Types of HINT in DB2

08/18/2014 05:52:28 AM

PLAN_TABLE hints This type of hint to tries to enforce a particular access path for an SQL statement that is issued by a specific single authorization ID. It uses rows in a PLAN_TABLE instance that owned by the same authorization ID to apply hints ba > read more

8 Ways to Become Expert in SQL

08/17/2014 01:18:23 AM

verview Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If eve > read more

SQL Queries 30 Days Challenge – Day 1

08/16/2014 01:04:06 AM

I am posting 30 difficult SQL queries in 30 days. Follow me on “Srinimf” to grab these queries. Query:1 How to select employee name who does not have supervisor? Solution: SELECT ENAME,EMPNO FROM EMP WHERE ESUPER IS NULL; The above result > read more

DB2- LOCATE Scalar Function

08/15/2014 06:22:24 AM

SCALAR – Function returns first occurrence position in first string, second string: Example1: SELECT LOCATE(‘I’,’MINE STRING’) FROM SYSIBM.SYDUMMY1 It returns value 2. Since first occurrence is 2. Example2: SELECT LOCATE > read more

3 Ways to Handle DB2 VARCHAR Field in COBOL

08/13/2014 22:18:59 PM

The below example shows, how COBOL handles VARCHAR field at 49 level. 01 SNAME. 49 SNAME-LENGTH PIC S9(4) COMP. 49 SNAME-TEXT PIC X(100). :SNAME-LENGTH contains the number of bytes in :SNAME-TEXT when selecting SNAME. SNAME-TEXT should be the same le > read more

5 ways to deal with a difficult team member

08/13/2014 00:29:22 AM

1.Spot Signs Early Observe signs early on. ” Procrastination, blaming others and not trying for self improvement are signs of a non-cooperative team member,” says Sudhir Dhar, associate director and head — human resources and administra > read more

Oracle PLSQL Step By Step Guide

08/12/2014 00:39:17 AM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Oracle PLSQL Step By Step Guide > read more

UNIX and Shell Scripting Programming – A to Z PPT

08/11/2014 05:08:22 AM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: UNIX and Shell Scripting Programming > read more

6 Ways to People Management in the Office

08/11/2014 00:39:48 AM

It may take a few months to several years to build your brand in the organisation. But once you are viewed as a smart, hardworking employee, you can be more comfortable discussing your other priorities. As you grow in the organisation, it is extremel > read more

Web server Basics For Dummies

08/10/2014 01:01:16 AM

Server plays prominent role in running applications. Many people false understand that OS is the same as Server. OS and Server both are different The main job of a Web server is to respond to requests from Web client computers There are 3 components > read more

Jig Saw Pizzle- Improve Your Brain Power

08/09/2014 10:17:40 AM

Carousel in Albert Dock, Liverpool puzzle on TheJigsawPuzzles.comFiled under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Jig Saw Pizzle- Improve Your > read more

Oracle – PL/SQL Architecture

08/08/2014 21:32:33 PM

Oracle PL/SQL Architecture When a PL/SQL program unit is passed to Oracle, it gets processed through a compiler. The compiler creates a syntax tree, passes it through an optimizer, and generates machine code that’s stored in the database for ex > read more

DB2- Advanced Programming With Cursors Part (2 of 2)

08/07/2014 21:16:38 PM

Why DB2 is becoming such a popular database? Yes, there are many reasons. Time to time it is upgrading with latest features. We know CURSORS is DB2 object. There are some advanced concepts, we need to learn. Some Key words: SENSITIVE- Latest updated > read more

UNIX Daily 5 Commands

08/07/2014 06:49:25 AM

File navigating commands: cat Concatenate: displays a file. cd Change directory: moves you to the directory identified. cp Copy: copies one file/directory to specified location. file Identifies the file type (binary, text, etc). find Finds a file/dir > read more

5 Best COBOL Questions and Solutions

08/06/2014 21:44:52 PM

I wake up in the morning,I just started reading a book on How to win in office politics, during that time I have got an Idea, why many people in mainframe still unable to answer some tough COBOL questions. I decided to write 5 best COBOL questions. > read more

COBOL – Tricky Interview Question

08/05/2014 09:12:09 AM

This question you may come across in many interviews. This scenario usually comes in Banking projects/Insurance/Finance projects. Question: There are 2 files, you need to compare key field in each files, and process it. Solution -1 : - First file y > read more

DB2- Programming With Cursors – Part(1 of 2)

08/04/2014 22:22:39 PM

What is cursor? CURSOR is a DB2 object. It deals with a set of rows. Why we need to go for CURSOR- since we have already SELECT statement . The answer is – if  SELECT statement retrieves more than one row, COBOL program may not handle it. So w > read more

Change the Way You Start Your Day

08/04/2014 03:16:32 AM

Change the Way You Start Your Day What’s the first thing you do when you get to your desk? Check email and listen to voicemails? This is the worst way to start the workday. Instead of automatically going into reactive mode and focusing on other > read more

Mainframe – TSO, CLIST and REXX

08/03/2014 21:07:19 PM

TSO - is time sharing option. We can execute TSO commands through ISPF interface. Commonly used TSO commands: Session mangagement LOGON None Start a terminal session. LOGOFF X, then LOGOFF End a terminal session. HELP T (Tutorial) or PF1/13 Display h > read more

3 COBOL Features Not Allowed in CICS

08/02/2014 23:14:01 PM

Designing a COBOL program is a skill, if we write it effectively it reduces CPU time. The following COBOL feature are not allowed in CICS program. ACCEPT – There is no question of accepting data from screen. So we can not use it DISPLAY – > read more

Analytics – How to make mid career change

08/02/2014 00:02:55 AM

After researching in internet and asking my friends I have found some guidelines, who want to make change into analytics. It is never too late to join in analytics SAS certification would be a plus point to start your career Initially, we should not > read more

DB2-Stored Procedures – Examples

07/31/2014 20:57:05 PM

Complete resources on DB2 stored procedures: http: > read more

MVS Abend Codes

07/31/2014 09:58:25 AM

Very common abends in mainframe. The below list is frequently occurred system abends. ABEND CODE 013 ABEND CODE 0C1 ABEND CODE 0C4 ABEND CODE 0C5 ABEND CODE 0C7 ABEND CODE 106 ABEND CODE 213 ABEND CODE 222 ABEND CODE 2F3 ABEND CODE 322 ABEND CODE 613 > read more

DB2- Remote Binding a Package

07/30/2014 22:57:16 PM

Local Binding a Package/Plan BIND PLAN(IMSONLY) - PKLIST(DSN8IC91.*) - ACTION(ADD) - ISOLATION(CS) - OWNER(DEPTM92) - QUALIFIER(PRODUCTN) - CACHESIZE - ENABLE(IMS) Remote Binding a Package/Plan To BIND the DBRM PROGA at the location PARIS and in the > read more

JCL – Mainframe Advanced Tips on Procedures

07/28/2014 21:47:32 PM

Procedure we also call it as PROC. Usually PROC acts as routine. It will reduce coding the same logic multiple times. With this we can override parameters, like DD data set names, PARM parameters(using symbolic parameters). Important Points: Restart > read more

5 Tips to Become Expert in SQL

07/27/2014 09:44:36 AM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: 5 Tips to Become Expert in SQL > read more

Analytics in Different Areas

07/24/2014 23:40:42 PM

Customer Analytics: Understand what your customers really think about you and your products and interact with them more effectively to raise customer satisfaction levels Marketing Analytics: Make your marketing more targeted and effective through cam > read more

Excel Tutorials for Business Analytics

07/23/2014 22:09:10 PM

Microsoft Excel analytics of step-by-step guide [] Excel for data analysis [] Data analysis us > read more

JCL – Mandatory Details in JOB

07/23/2014 03:25:46 AM

//jobname job (acctinfo),programmer-name Because the above are Positional parameters, they must be coded in the sequence. //Stepname Exec PGM=abcd or Proc-name //Stepname DD DSN=ABCD //Stepname DD SYSOUT=* Additional Points:- More than one job can be > read more

DB2 – 5 Frequently Asked Questions

07/21/2014 03:36:02 AM

There are few confusing things in DB2. Almost all people, both experienced and freshers will confuse during interviews. PLAN -  Is an executable DB2 object. A DBRM we can bind directly to a PLAN or a PACKAGE we can bind it to a plan. In the BIND ca > read more

Themis Inc – Advanced DB2 Training

07/19/2014 21:15:40 PM

About Themis Inc Themis Top 25 DB2 Tuning Presentation Across the board, Themis instructors excel at programming, design and systems support. They were early adopters of new releases of software.  ====> DB2 Training Courses > read more

Three Tips for Responding to Failure

07/18/2014 20:56:00 PM

Everyone reacts differently to failure: some immediately accuse others while some take the heat themselves, even if undeserved. Next time you and your team fail, resist the temptation to place blame. Take these three steps instead: Think before you a > read more

2 Best Methods Of Choosing Correct Database – IMSDB

07/18/2014 09:26:00 AM

 We have option to choose two databases. One is DL/I database. The second one is DEDB database. DL/I Database - DL/I is a general access database manager, thus it is suitable for a wide variety of applications. It is also called full function data > read more

IMSDB – Backward and Forward Recovery

07/15/2014 21:58:52 PM

Recovery is the term we use in the sense of IMSDB is restoring a database to its point of integrity. Backward Recovery - IMS will do dynamically backout the data in the following scenarios: Online environment: An application program terminates abnorm > read more

IMSDB – Basic DBRC Components

07/15/2014 07:36:05 AM

DBRC includes the following components, which are introduced in this section: “RECON Data Set” “Database Recovery Control Utility (DSPURX00)” “Skeletal JCL” RECON Data Set DBRC stores recovery- related informatio > read more

Hadoop Forum

07/15/2014 02:12:00 AM under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Bigdata forum, Hadoop Discussion Forum, Had > read more

Awareness About Heartbleed Bug

07/14/2014 08:40:48 AM

The Heartbleed bug allows anyone on the Internet to read the memory of the systems protected by the vulnerable versions of the OpenSSL software. This compromises the secret keys used to identify the service providers and to encrypt the traffic, the n > read more

Hierarchical Vs. RDBMS

07/13/2014 05:14:22 AM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: db2, Hierarchical Vs. RDBMS, IMSDB > read more

IMSDB – DL/I, BMP, MPP – Advanced Concepts

07/12/2014 20:38:24 PM

BMP Batch message processing programs (BMPs)Programs that run as batch jobs but access databases that they share with online transactions. In other words, theses share online (message ques) as input, and sends output to database. Transaction-oriented > read more

How SAS Analytics Helps to Address Child Fatalities

07/10/2014 22:02:10 PM

The resulting five-year Child Fatality Trend Analysis is helping investigators better predict the needs of families in crisis. Some of the key findings include: Overall, child deaths within the agency are trending downward. Children who received pr > read more

© 2006-2014, All Rights Reserved