Recent Updates: Tech.Jobs.Biz.Success

Visit http://srinimf.com For Recent Updates.

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

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

We can use this in both main and subqueries: SELECT LASTNAME, FIRSTNAME, EMPNO, SALARY FROM EMP ORDER BY SALARY DESC FETCH FIRST 20 ROWS ONLY; You can also use FETCH FIRST n ROWS ONLY within a subquery. SELECT * FROM EMP WHERE EMPNO IN ( SELECT RESPE > read more

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

RESTART LOGIC IN COBOL DB2 Program

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

Srinimf.Jobthread

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 ,www.biganalytics.me, 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

DB2-SQL DISTINCT and Group By

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

http://www.sysed.com/tech_assessments/leader/mainframe_legacy_systems.aspFiled 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

1. Question //URMISPLT EXEC PGM=SORT //SORTIN DD DSN=MYDATA.URMI.FILEIN,DISP=SHR //SORTOF01 DD DSN=MYDATA.URMI.FILEOUT1, // DISP=(NEW,CATLG,DELETE), // RECFM=FB,LRECL=50 //SORTOF02 DD DSN=MYDATA.URMI.FILEOUT2, // DISP=(NEW,CATLG,DELETE), // RECFM=FB, > read more

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://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html http://solutions.devx.com/ibm/skillbuilding/archives/walkthrough-creating-stored-procedures-in-db2.html 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 [http://www.ictlounge.com/work/practical_workbooks/data_analysis_step_by_step_booklet.pdf] Excel for data analysis [http://www.sagepub.com/bachmanfrccj2e/study/resources/Appendix_f.pdf] 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

http://sriniforum.bestfreeforum.ca/f5-bigdata-discussion-forumFiled 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

20 DFSORT Tricks For Interviews

07/10/2014 02:12:08 AM

Filed under: CICS, Easytrive, Mainframe, Quiz, Self-development Tagged: 20 DFSORT Tricks For Interviews > read more

Icebreakers For Meetings And Trainings

07/09/2014 21:12:46 PM

These 40 icebreakers are simple to use and suitable for a wide age range. They are great with a small youth group and can be used in a small space! They require very few props and can easily be used in a home without feeling a hurricane just came  > read more

4 Traits in DB2 Cursor WITH HOLD

07/09/2014 03:46:07 AM

Point 1 - The best example for cursor WITH HOLD is, just imagine, you are processing Master table and Detail table in DB2, you need to retrieve a row from Master table and process the row data, and you need to update it in Detail table. To perform UP > read more

Advanced SQL in DB2 – Part 2

07/08/2014 09:41:05 AM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Advanced SQL, db2 sql, DB2 Tuning, SQl Tuning > read more

IBM BMC Remedy – a Guide

07/08/2014 02:43:00 AM

The below guide provides a conceptual overview of the applications that make up the BMC Remedy IT Service Management (BMC Remedy ITSM) Suite of applications. ITIL process                         BMC Remedy ITSM application: Change managem > read more

10 Killer Tips For COBOL-DB2 Developers

07/08/2014 00:50:06 AM

The SQLCODE must be checked after every SQL statement Every program must include SQLCA(only once), and DCLGEN for each table Every program must have abend routine. In this routine make sure to use,SQLCODE and SQLSTATE to display Never code SELECT * i > read more

Teradata Utilities Quiz

07/07/2014 00:54:53 AM

Hello, Teradata guys, I have given my quiz here. I will give more in future. Find best links: > read more

Advanced SQL in DB2 – Part 1

07/06/2014 22:09:52 PM

Before going into advanced SOL, I want to give some information on data modelling : > read more

USA-Cross Cultural Sensitivity

07/05/2014 22:03:17 PM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: USA-Cross Cultural Sensitivity > read more

JCL Cataloged and In stream Procedures (proc)

07/05/2014 03:47:38 AM

In JCL there are two different procedures. One is Cataloged and the other one is in-stream. JCL procedures like any other languages are routines, we can reuse any no of times. So that we can avoid errors. The below points we can consider as tough JCL > read more

DB2 V10.5 An Overview

07/03/2014 08:42:01 AM

Filed under: Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, Mainframe, Mobile Apps, Quiz, Self-development Tagged: DB2 V10.5 An Overview > read more



© 2006-2014 OnToplist.com, All Rights Reserved