Recent Updates: Srinimf|Tech.Jobs.Biz.Success

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

This Blog Posts All Posts Directory Listings Articles

Top Data virtualization Techniques for BI projects (1 of 5)

08/01/2015 00:23:00 AM

The term data virtualization is based on the word virtualization. Virtualization is not a new concept in the IT industry. Probably the first application of virtualization was in the 1960s when IBM used this concept to split mainframes into separate v > read more

Mainframe: MQSeries for Senior Software Developers(1 of 3)

07/31/2015 01:06:09 AM

These posts specially for mainframe programmers, they can use these tips for development as well as for maintenance projects. Integrate your mainframe applications to different distributed applications using MQseries. A message queue, known simply as > read more

Mainframe: 10 Powerful Points for COBOL and SQL programs

07/30/2015 00:59:26 AM

In Mainframe it is possible to run a SQL query without writing a COBOL program. By using, SPUFI, QMF and IBM Studio SQL query must begin with EXEC SQL and end with END-EXEC. Second, your SQL query usually uses COBOL host variables. Host variables in > read more

CICS: CEMT, CECI, CEBR Commands Part(2 of 3)

07/29/2015 07:42:01 AM

#Cloud Computing Middleware an approach- Virtualization http://t.co/tZ325ktkGd #biganalytics #bigdata — ApplyBigAnalytics (@applyanalytics) July 27, 2015 CEMT lets you display and change the status of resources, including programs, transactions > read more

Mainframe: Top IMS DC Interview Questions (2 of 2)

07/28/2015 07:41:27 AM

Different kinds of NoSQL Databases in the age of Big data | Apply Big Analytics http://t.co/9YNFCZW1iG — Srinimf (@srinimf) July 26, 2015 1) Which block MFS uses for input message? DIF- Device input format 2) What is second block it uses? MID- > read more

Mainframe:COBOL Strings, INSPECT,Concatenation, Splitting (2 of 2)

07/27/2015 00:23:53 AM

What is String concatenation in COBOL. Read my previous post on COBOL Strings-INSPECT VERB. String concatenation involves joining the contents of two or more source strings or partial source strings to create a single destination string. In COBOL, st > read more

Mainframe-COBOL Occurs, Indexed By,USAGE is Index (2 of 2)

07/23/2015 21:44:32 PM

Read my previous post-1. This post is an advanced topic for Tables/arrays. OCCURS depending ON. Best example to create variable array: 01 ORG-LIMIT PIC 99 COMP VALUE 50. 01 DIVISION-NAME-TABLE. 05 DIVISION-ENTRY OCCURS 1 TO 50 TIMES DEPENDING ON ORG > read more

Easytrieve Guide for Mainframe Programmers (6 of 20)

07/22/2015 06:18:48 AM

VARIOUS I/O COMMANDS: This section will cover a wide variety of commands that will be essential to the EZT+ programmer in organizing the logic that is necessary to construct an EZT+ program. The statements to be covered are . . . . .   PRINT     > read more

5 Key differences of INDEX and Subscript for COBOL programmers

07/21/2015 00:06:37 AM

You can refer my posts on INDEXED BY and KEY IS of a Table. Subscript: Subscript should be an integer. It should have working storage definition Subscript can be passed to a sub-program Subscript varies from 1 to size of OCCURS Subscript references > read more

Mainframe-COBOL Occurs, Indexed By,USAGE is Index (1 of 2)

07/20/2015 00:53:47 AM

I want to share very important points on COBOL index. First point is Index cannot passed into SUB-PROGRAM and why. Second, is Index is not an Integer. Most mainframe COBOL programmers confused much here of how to use OCCURS clause with KEY phrase > read more

Mainframe: Reduce your Coding lines using OUTPUT statement in JCL (1 of 2)

07/19/2015 07:39:40 AM

Tricky SYSOUT statement in JCL(Job control Language), and ignore it many times by programmers to understand it correctly. Why SYSOUT is coded in JCL SYSOUT data sets are output files that are designed to be printed rather than stored on DASD or tape. > read more

Mainframe: DB2 LOCATE Built-in Function-Best examples

07/17/2015 07:47:26 AM

You already enjoyed with my earlier post on built-in functions. LOCATE is a Scalar function. Syntax for LOCATE function is as follows: SELECT LOCATE(‘String to be searched’, Source string’, Start position) FROM SYSIBM.SYSDUMMY1; Key > read more

Mainframe: DB2 Tutorial For Software Developers (3 of 5)

07/17/2015 00:30:16 AM

Data Definition Language(DDL) CREATE: –This statement is used to create objects Syntax : For Creating a Table CREATE TABLE (Col Definitions) PRIMARY KEY(Columns) / FOREIGN KEY UNIQUE (Colname) (referential constraint) [LIKE Table name / View n > read more

Informatica: Top Data warehousing Interview Questions(Part 1 of 2)

07/16/2015 00:29:20 AM

I hope you enjoyed with my post informatica transformations. This is big post on interview questions. What is data warehouse? A data warehouse is a electronic storage of an Organization’s historical data for the purpose of analysis and reportin > read more

Mainframe: Simplify Your DB2 SQL Query with these Built-in Functions

07/15/2015 00:53:37 AM

DB2 built-in functions are great to use to simplify your SQL query. There are different functions available. Alternative functions improve the understanding of SQL query. Use Left side functions (alternative functions) instead of Right side function > read more

Mainframe: CICS ATI, START an Example

07/14/2015 07:32:51 AM

Life cycle of START Command: START command executes through ATI (Automatic time ordered transaction initiation) A user task issues a START command that’s processed by interval control. Interval control creates an ICE that indicates the trans-id > read more

Easytrieve Guide for Mainframe Programmers (5 of 20)

07/14/2015 00:30:16 AM

HEADING Report headings can be supplied in the field definition of a data item. When NOT coded with the data item, the actual field name is used as a heading. The heading can be specified by simply using the HEADING parameter of the field definition. > read more

Mainframe: DB2 Tutorial For Software Developers (2 of 5)

07/13/2015 01:01:42 AM

What is SQL? SQL – all data object manipulation, creation and use, involve SQL’s. DB2 objects – Database, Tablespaces & Indexspaces – creation & use, and other terminology’s associated with databases. SQL or Structured Query > read more

These IMS DB, IMS DC Error Codes asked in Many Mainframe Interviews

07/12/2015 11:30:01 AM

IMS DB, IMS DC error codes for mainframe interviews. How to prepare for IMS DB interviews is a big challenge. I made here simplified. AM – Proc option ‘P’ is not defined for command code VI – Variable segment size is crossing > read more

Mainframe : Advanced CICS for Senior Software Developers(1 of 5)

07/12/2015 06:24:44 AM

Many CICS-Mainframe programmers do not know exact difference between ATI and START. Understanding these concepts is little tricky. That is why I am posting these concepts for Senior software developers. Since CICS has multitasking capability, let us > read more

COBOL MOVE, Alphanumeric Move, Numeric Move, Decimal Move

07/10/2015 01:39:04 AM

MOVE is such a crucial COBOL reserved word. Simple syntax for MOVE is: MOVE {identifier-1 | literal-1} TO identifier-2 .. We can move smaller field to bigger field We cannot move bigger field to smaller field. If so, value will be truncated. Alphanum > read more

Mainframe: Top DB2 DBA Interview Questions (1 of 5)

07/08/2015 22:45:24 PM

1) What are the different address spaces used in DB2? System services address space (SSAS) Database services address space (DSAS) Internal resource lock manager (IRLM) Distributed Database Facility (DDF) Stored procedure address space (SPAS) Allied > read more

These DB2 SQL Errors asked in Many Mainframe Interviews

07/08/2015 04:31:53 AM

Below is the list of frequently asked DB2 SQL errors in Mainframe+job interviews. 000- Successful 100-Row not found -205-Column name is not a column of the table -305-Null value cannot be assigned to a host variable -313-Number of host variables dec > read more

DB2 DATE,UNPACK and TRIM Functions

07/07/2015 22:17:56 PM

TRIM TRIM is a scalar function in DB2. As of DB2 V11 we will see how this function will work. Example: Initial value in :HELLO1 = HELLO1 SELECT TRIM(:HELLO1), TRIM(TRAILING FROM :HELLO1) FROM SYSIBM.SYSDUMMY1 Result: HELLO1,HELLO1 – Both are sa > read more

Project Manager Responsibilities in Software Company (2 of 2)

07/07/2015 11:30:57 AM

Roles and responsibilities: The Project Manager has the authority to run the project on a day-to-day basis on behalf of the Project Board . Responsibility: The Project Manager’s prime responsibility is to ensure that the project produces the > read more

DB2 WITH HOLD Close and Open of Cursors in COMMIT or ROLLBACK

07/06/2015 21:34:12 PM

A cursor in an application programming plays crucial role. With cursor, we can retrieve bunch of rows matching to criteria of WHERE clause. Cursor life cycle: Declare => OPEN => Fetch => CLOSE Declare-It is nothing but declaration, like working stora > read more

Easytrieve Guide for Mainframe Programmers (4 of 20)

07/06/2015 11:30:44 AM

DECIMAL POSITIONS For numeric data items, you can indicate the number of decimal places  (0 – 18)      by adding the appropriate numeric value AFTER the data format value. The use of the DECIMAL indicator also informs EZT+ that this data i > read more

Mainframe: How to Debug CICS Abend Code

07/05/2015 11:28:05 AM

When CICS encounters an error it can’t recover from, it ends in an abnormal termination, or abend. There are many utilities we can use to trace out CICS abends.  Usually, in CICS, when running a transaction, due to logic problem in a program, > read more

Mainframe: Top IMS DC Interview Questions (1 of 2)

07/03/2015 21:52:38 PM

1) What is IMS DC? It is IBM IMS data communication 2)How IMS DC program works? It takes input from terminal, and IMS DC program, interacts with database/files, send back information to the terminal 3)What is a message? Message is a unit of data pass > read more

DB2 SQL Quiz for Mainframe Programmers

07/02/2015 01:05:19 AM

Check your SQL knowledge. SQL Quiz for mainframe programmers. 1)SQL was first developed: A)In the 1970s B)In 1982 C)By IBM D)By ANSI E)NONE 2)A SELECT without a WHERE clause: A) Always outputs results to a log file B) Results in an error message C) > read more

Mainframe: Top IDMS Interview Questions (1 of 5)

06/30/2015 11:30:05 AM

What is the difference between a schema and a sub schema? The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program. What is a region? Region > read more

Mainframe: JES2 and JES3 Control ‘/*’ Statements in Job Card

06/29/2015 12:11:02 PM

JES2,JES3 and JES statements: Under JES2 and JES3, a job stream can also include JES2 or JES3 control statements that influence the way the Job Entry Subsystem processes your job. In old projects, you may come across JES control statements in older j > read more

Mainframe: 3 Simple Ideas to Handle Cursor Position in CICS

06/28/2015 21:46:21 PM

These 3 techniques are so helpful for CICS-Mainframe programmers to implement handling cursor position. Using IC: First, if a map contains a single entry field, you can specify the IC option in the DFHMDF macro for that field. For maps with more than > read more

These COBOL File Status Codes Asked in Many Mainframe Interviews

06/25/2015 21:53:21 PM

The below COBOL errors frequently being asked in many interviews, and occurring in day to day development of COBOL programs. COBOL File Status Codes: 00- Successful 02-Duplicate alternate key 22-Duplicate Key 23-Record not found 24-Space not found to > read more

Project Manager Responsibilities in Software Company (1 of 2)

06/24/2015 21:31:17 PM

Project Manager-Software Project managers run the projects. Their role differs from that of technical managers, whose primary responsibility is maintaining the integrity of the systems. How project managers learn skills These managers have taken clas > read more

Easytrieve Guide for Mainframe Programmers(3 of 20)

06/23/2015 21:57:22 PM

EZT+ LIBRARY FILE STATEMENT All files and their associated fields (including any Working Storage items) used in your EZT+ program MUST be described in the library section BEFORE they are used in your program. The FILE STATEMENT is used to define the > read more

COBOL Data Division Clauses (1 of 3)

06/22/2015 21:09:59 PM

Many mainframe programmers not so clear about COBOL data division clauses. The below clauses extensively used in COBOL programmes. Also, the below are top COBOL interview questions. The Data Division clauses are used to describe elementary and group > read more

Sample COBOL DATE Program for Mainframe Projects

06/21/2015 22:25:27 PM

IDENTIFICATION DIVISION. PROGRAM-ID. DAYS-BETWEEN. ENVIRONMENT DIVISION. DATA DIVISION. WORKING-STORAGE SECTION. 01 DIFF-DAYS    PIC +++,+++,++9. 01 TOTAL-DAYS1  PIC S9(8) BINARY. 01 EDITED-DATE1 PIC X(20). 01 DATE1. 03 YY     PIC 99. 03 MM  > read more

Endevor Presentation for Mainframe Programmers

06/20/2015 22:44:59 PM

Endevor is a source code management and release management tool for mainframe computers running z/OS .It is part of a family of administration tools by CA Technologies (formerly Computer Associates), which is used to maintain software applications an > read more

Easytrieve Guide for Mainframe Programmers (2 of 20)

06/19/2015 21:45:57 PM

EZT+ SYNTAX EZT+ and its free-form ENGLISH language structure make it easy for you to develop an efficient and flexible style of programming. To avoid fundamental programming errors you should follow these simple EZT+ syntax rules.  STATEMENT AREA > read more

DB2- Use of ‘COALESCE’ Function (2 of 2)

06/18/2015 21:25:39 PM

Usage of COALESCE function, and detailed explanation. SELECT bird_name, AVG(COALESCE(found_tally, 0)) FROM Samples AS SA LEFT OUTER JOIN SampleGroups AS SG ON SA.sample_id = SG.sample_id AND SA.bird_name = :my_bird_name AND group_id = :my_group GROUP > read more

Eazytrive+ Material for Mainframe Programmers (1of 20)

06/17/2015 23:54:51 PM

What is EZT+?  EZT+ is an information retrieval and data management system. It provides the NEW USER the tools to produce comprehensive reports. The experienced programmer is given the tools to create more complex reports.  EZT+ is an ENGLISH style > read more

TPPCB Structure in IMSDB/DC

06/15/2015 19:37:07 PM

TPPCB Structure: 01  TPPCB. 05  TP-LTERM                    PIC  X(08). 05  FILLER                      PIC S9(04)   COMP. 05  TP-STS-CODE                 PIC  X(02). 88  TP-BB-GOOD   > read more

PLI Presentation for Mainframe Programmers

06/14/2015 00:46:10 AM

Filed under: IMDB/DC, Mainframe, PL/I Tagged: Mainframe PLI, PLI > read more

QMF Commands for Senior Mainframe Programmers

06/13/2015 21:46:39 PM

QMF is an excellent tool for mainframe programmers to increase productivity. QMF for windows a solution,we can query on multiple data sources. Database management system implementations within a single company are no longer restricted to a single dat > read more

DB2 SQL Query to Find Salary Dept wise

06/11/2015 22:52:10 PM

Good SQL query example. It is asked in many interviews. Suppose, that you want to know how much salary is paid to employees for each of the department codes listed in the SAMPLE database’s employee table. Take a look at this table in the Contr > read more

LOAD and UNLOAD with SHRLEVEL PARALLEL in DB2 V11

06/10/2015 21:25:18 PM

DB2 V11 LOAD and UNLOAD Enhancements: LOAD SHRLEVEL NONE with PARALLEL option LOAD SHRLEVEL CHANGE with PARALLEL option The best way to LOAD is split your input data set into part and load individual data set into part of partition table space. Howev > read more

2 More things on Advanced COBOL Programming

06/10/2015 00:26:34 AM

A great opportunity for mainframe programmers to implement these advanced concepts into their development projects. As you gain experience you need to show some performance improvement in your day to day coding. These, you can tell, that you did in y > read more

Sorting Multiple Fields in DFSORT

06/08/2015 21:00:03 PM

Let us sort records in the bookstore data set by specifying multiple control fields. When you specify two or more control fields, you specify them in the order of greater to lesser priority. Note that control fields might overlap or be contained w > read more

DB2 NULLIF Scalar Function

06/08/2015 01:30:40 AM

NULLIF returns a null value if the two arguments of the function are equal. If the arguments are not equal, NULLIF returns the value of the first argument. DB2+Mainframe+CICS+Updated+JOBS [If your from INDIA please search here ] Example: NULLIF: Sup > read more

3 Thoughts on Modernization of Mainframe Online Applications

06/07/2015 22:12:36 PM

Mainframe modernization using Web services/SOA has, in recent years, become one of the most effective, efficient, and economical means to reach these goals. In manufacturing, telecommunications, energy, high tech, insurance, government, health care, > read more

How COBOL Sharing Data Between Main and Subprograms

06/06/2015 22:06:21 PM

These are interesting things on COBOL. Surely if you implement these in your development projects your productivity will increase. Within a main program and each of its contained subprograms, data and files are normally private, which means that they > read more

Sweet Spots of DB2 V11 with Hadoop

06/04/2015 21:00:00 PM

Big data and business analytics represent the new IT battleground. Here is some stats: IDC estimates the big data market will reach $16.9 billion by 2015, and that enterprises will invest more than $120 billion to capture IDC estimates the big data m > read more

SQL Tuning Refresher for Data warehousing Programmers

06/03/2015 21:38:52 PM

SQL tuning is very critical in the context of data ware housing. Before tuning, the following factors we need to consider to take decision. Isolating the Problem The first challenge is to isolate exactly where the performance problem lies. For exampl > read more

IMSDB Refresher for Mainframe Programmers

06/02/2015 21:25:32 PM

I am giving here IMSDB refresher for your super success in interviews. This tutorial contains all key points in IMSDB. Many interviewers follow or touch these questions in selecting IMSDB programmers. Few points on IMSDB: [You can read my other arti > read more

ROLLUP or Sub Total in DB2 V11 SQL

06/01/2015 22:37:40 PM

A ROLLUP grouping is an extension to the GROUP BY clause that produces a result set containing sub-total rows in addition to the “regular” grouped rows. Subtotal rows are “super-aggregate” rows that contain further aggregates > read more

Python the Most Powerful Language

05/31/2015 21:20:06 PM

According to 2014 statistics Python became one of the powerful language, after Java, C++ in series. Python is free downloadable language. You can start practice today. Tools for Python-Downloads: Anaconda Python http://continuum.io/downloads Both eas > read more

Top UNIX Job Scheduling Interview Questions

05/30/2015 22:49:05 PM

 What is the difference between invoking a job serially and in parallel? A) In UNIX/Linux, the invocation of a program is also called a job or task. To distinguish between a job (task) and process, consider the invocation of a program as a single jo > read more

Highest Paying Jobs in USA

05/30/2015 08:22:18 AM

1. Software Architect Average base salary: $131,000 Number of job openings: 3,200 software+architect+jobs 2. Software Development Manager Average base salary: $124,000 Number of job openings: 2,200 software+development+manager+jobs 3. Solutions Arch > read more

ISPF-Commands For Senior Software Developers (5 Of 5)

05/29/2015 21:15:13 PM

How do I make columns 1-6 disappear from my ISPF editor screen? > read more

2 More Ideas on COBOL Debugging

05/29/2015 00:39:51 AM

COBOL debugging: is a concept used in COBOL programs. Let us go into details of this concept. Many COBOL programmers have a question, if debugging tools are there, why we need to go for COBOL debugging. Yes, it is true, but it has some advantages. H > read more

ISPF-Commands For Senior Software Developers (4 Of 5)

05/27/2015 20:39:54 PM

How do I find for any non-numeric character? A. Use picture string ‘-’. 32. How do I find for any alphabetic character? A. Use picture string ‘@’. 33. How do I find for any uppercase alphabetic character? A. Use picture string ‘>’. 3 > read more

Reduce SQL Complexity With Grouping Sets in DB2 V11

05/26/2015 21:38:25 PM

DB2V11,Grouping Sets-Mainframe. The GROUPING SETS option can be thought of as the union of two or more groups of rows into a single result set. It is logically equivalent to the union of multiple subselects with the group by clause in each subselect > read more

What is EIB Storage Area in CICS

05/25/2015 22:43:27 PM

Execute Interface Block (EIB) is a CICS area that contains information related to the current task. I’ll explain how to use some of the other fields. For a complete explanation of these fields and their possible values, you can refer to the IBM > read more

Writing Transaction File to Master File in COBOL- 8 Tips

05/23/2015 23:07:39 PM

COBOL-Master file-Transaction file. Many interviews these questions are asked in COBOL,transaction file and master file. Easy ideas I have given for your sure success in your interviews. Master files contain the entire data of a particular applicatio > read more

ALTER TABLE table_name DROP COLUMN column_name

05/23/2015 03:32:49 AM

ALTER statement we can use in DB2 SQL query to drop a column. ALTER TABLE table_name DROP COLUMN column_name But, there are lot other conditions involved, which column we can drop or not. The containing table space is not a universal table space. The > read more

1 More Addition Of Global Variables in DB2 V11

05/21/2015 23:43:39 PM

Traditionally within a relational database system, most interactions between an application and the DBMS are in the form of SQL statements within a connection. To share information between SQL statements within the same application context, the appli > read more

Cashback In Credit Or Debit Cards

05/20/2015 22:27:41 PM

A Cashback reward program is an incentive program operated by credit card companies where a percentage of the amount spent is paid back to the card holder. Many credit card issuers, particularly those in the United Kingdom and United States, run prog > read more

Start Tuning Your DB2 SQL Query (Part-1)

05/19/2015 21:41:04 PM

Check the predicates. Whether it is one query or multiple queries in a program, check every predicate in every query to ensure that they are indexable, stage 1, and as simple and straightforward as possible. If there is a Distinct or Group By in the > read more

1 More Addition to Improve DB2 Insert Performance

05/18/2015 23:26:04 PM

1 More Addition in DB2 V11 to improve insert performance: Having to index every data row affects performance and the size of the index. When creating an index, it is useful to exclude one or more values from being indexed, such as values that will n > read more

DB2-New Built-in Functions In Version 11

05/17/2015 22:14:39 PM

ARRAY_AGG The ARRAY_AGG function returns an array in which each value of the input set is assigned to an element of the array. ARRAY_AGG can be invoked in the following situations: Select list of a SELECT INTO statement Select list of a fullselect in > read more

ISPF-Commands For Senior Software Developers (3 Of 5)

05/16/2015 20:55:56 PM

21) I am not able to delete a dataset that resides on a tape. A. Yes. You cannot delete/rename a tape dataset. Only you can uncatalog it. ISPF Editor 22) How do I see only those lines that contain a particular string? A. Type ‘X all’ then ‘F > read more

IMSDB Interview Questions ( Part-2 )

05/15/2015 20:55:55 PM

1) How CICS access IMS DB database? A. Access through CICS command level interface 2) How REXX Exec access IMS DB? A. REXX EXECs can invoke IMS functions by using the IMS adapter for REXX 3) What is ICAL call in IMSDB? A. The IMS Call (ICAL) call i > read more

5 More Frequently Asked DB2 SQL Queries

05/14/2015 21:02:01 PM

I collected from my friends, for DB2 interviews these SQL queries you need to practice more times. Query#1 1) What are the different SELECT statements? A. select clause: Enumerates the column names and related constructs from clause: Describes the ta > read more

ISPF-Commands For Senior Software Developers (2 Of 5)

05/13/2015 21:03:20 PM

In my series of posts, I am giving best ISPF tips to improve productivity. Across the companies following these tips.Mainframe+cobol+db2+jobs+USA+India+UK+ . Read my part-1 tips, if you missed. 11) How do I find out which base cluster does an altern > read more

Top 15 Bangalore IT Jobs

05/13/2015 01:27:28 AM

Daily updated jobs. Experience level: 0 to 10 years. Access all your dream jobs from your Android/Windows/IOS/Blackberry mobile phone. Bangalore+IT+Jobs > SAP+HANA Jobs > Mainframe+DB2+CICS+Jobs > Hadoop+Jobs > ControlM+Mainframe+Jobs > Teradata > read more

IMSDC Interview Questions(Part-1)

05/12/2015 21:07:53 PM

I am giving here some of the top IMSDC interview questions asked in Altimetric, HCL, Tech Mahindra and IBM. 1) What is IMS TM region? A. The IMS TM control region is a z/OS address space that can be initiated as a z/OS started task or as a job by sub > read more

JCL- INCLUDE And OMIT With Examples

05/12/2015 12:45:21 PM

The best way to improve the efficiency of a sort or a merge is to reduce the number of records that are sorted or merged. To do that, you can use the INCLUDE and OMIT statements to identify the records that should be included or omitted from the sort > read more

ISPF-Commands For Senior Software Developers (Part 1 Of 5)

05/10/2015 21:49:33 PM

Advanced ISPF commands. Many mainframe developers do not use these. So I categorized these for Senior Mainframe developers. How do I create multiple instances of ISPF sessions? A. Use PDF command from the TSO panel, which will initiate a new ISPF s > read more

Top DB2 Frequently Asked Questions-Part1

05/09/2015 20:39:04 PM

1) How would you find out the total number of rows in a table? A. Use SELECT COUNT(*) … Allstate uses DB2v6. and QMF V3.3. 2) How do you eliminate duplicate values in SELECT? A. Use SELECT DISTINCT … 3) How do you select a row using i > read more

7 Strategies Of Batch Modernization In ZOS

05/08/2015 21:20:20 PM

The following 7 strategies improve batch performance, that in turn reduce cycle time. Ensuring the system is properly configured Ensuring a properly configured system means making sure there are generally adequate system resources, so work flow is no > read more

DB2-Optimizer Interview Questions

05/08/2015 11:56:44 AM

I want to share some interview questions that were asked in big companies like Dell, HCL, Infosys, CTS etc.. 1) What is optimizer? A. The DB2 optimizer, is the brain of DB2. The optimizer is a sophisticated and complex set of algorithms whose main o > read more

IMSDB-Database Manager Interview Questions

05/07/2015 21:01:57 PM

1) What is database management system(DBMS)? A. Allow access to the data for multiple users from a single instance of the data. Control concurrent access to the data to maintain integrity for all updates. Minimize hardware device and operating system > read more

IMSDB- Application Calls And System Service Calls

05/06/2015 21:51:06 PM

Application Calls get unique (GU) The GU (get unique) call retrieves a specific segment or path of segments from a database. At the same time, the GU call establishes a position in a database from which additional segments can be processed in a forwa > read more

DB2-Concurrency And Locking Interview Questions

05/05/2015 22:49:21 PM

I am giving here some challenging interview questions in concurrency and Locking. These questions are asked in many big companies like IBM, Dell, L&T, Allstate, Infosys, Wipro etc. 1). What is concurrency in database environment? A.  Database syste > read more

Credit Cards Tokenization

05/03/2015 20:32:36 PM

As you whip out your credit card this holiday season, you may wonder how secure your data are at the stores where you’re shopping. After all, it’s almost the one-year anniversary of the massive Target credit card breach, and high-profile > read more

Difference Between Multi-tired Application And Stored Procedures

05/02/2015 22:18:18 PM

Tired Applications: The concept of tiered applications presents a solution to design architects that uses distributed resources dynamically with the ability to insert software and hardware when and where they are needed. Two-tiered client/server appl > read more

CICS-Performance Interview Questions

05/01/2015 21:49:43 PM

Filed under: CICS, COBOL, Mainframe Tagged: CICS, CICS Performance, Top CICS Interview Questions > read more

ZOS-How DFSORT Works In Simple Way

04/30/2015 21:34:23 PM

DFSORT has very sophisticated record selection capabilities, whether before any sort (INCLUDE / OMIT) or after the sort (OUTFIL INCLUDE / OMIT). With OUTFIL INCLUDE / OMIT, you can use different criteria to send records to multiple output destinati > read more

PL/SQL-Syntax Rules

04/29/2015 23:48:58 PM

PL/SQL is a case-independent language, unless you specifically set up Oracle to be case-sensitive or explicitly define object names within the “” marks. In our careers, we have seen the use of camelBack, all_lower_case, crammedupvariabl > read more

JCL-Conditional Include In OUTFIL Statement

04/29/2015 08:39:55 AM

The below JCL Sort example best tells conditional include in OUTFIL of OUT1 outfile: //MATCH EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD DSN=… input File1 (FB/10) //IN2 DD DSN=… input File2 (FB/10) //OUT12 DD SYSOUT=* keys in File > read more

JCL-Sort Interview Questions

04/28/2015 22:32:57 PM

Filed under: JCL, Mainframe Tagged: JCL, JCL Sort Interview Questions > read more

Oracle-Shared Pool Concept

04/26/2015 21:36:23 PM

Oracle interview question on shared pool: The shared pool is one of the most critical memory components particularly when it comes to how SQL executes. The way you write SQL doesn’t just effect the individual SQL statement itself. The combina > read more

Stratus- Architecture Of Fault Tolerant System

04/24/2015 10:13:10 AM

Modularity- The hardware and software are constructed of modules of fine granularity. These modules constitute units of failure, diagnosis, service, and repair. Keeping the modules as decoupled as possible reduces the probability that a fault in one > read more

PL/SQL Interview Questions – Part-1

04/22/2015 09:02:23 AM

Filed under: Oracle, PL/SQL Tagged: Oracle, PL/SQL Interview Questions > read more

COBOL Features Not Allowed In CICS

04/21/2015 08:08:28 AM

Many features of command level features not allowed in CICS program. Under CICS, all terminal I/O is handled by the terminal control module, whose services are typically requested by issuing SEND MAP and RECEIVE MAP commands. Because of that, COBOL > read more

Ultra Basic Unix Commands – Part-1

04/20/2015 21:30:05 PM

Below are basic UNIX commands: cat – display or concatenate files cd – change directory chmod – change the permissions on a file or directory compress – compress a file cp – copy a file date – display the current d > read more

PL/SQL Architecture

04/20/2015 10:32:53 AM

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 execution at a later time. Or > read more

UNIX- Sed And AWK Commands

04/19/2015 07:11:43 AM

Sed Command: The sed command does much the same thing as ed. The main difference is that sed performs these actions in a noninteractive way. Sed is a stream editor (thus the name), and it is designed to work on a specified stream of text according to > read more

PL/I- Compile JCL And Run JCL

04/18/2015 21:05:08 PM

Compile JCL for PL/1 00001 //PL1COMP JOB IBMMFS,’MAC’,CLASS=A,NOTIFY=&SYSUID 000002 //STEP1 EXEC PLIXCL,PARM.PLI=’LIST,MAP,FLOW,GOSTMT’ 000003 //* PARM.PLI=’O=0,NED,NM,LD,ND,NS2,NE,NL,C60′   > read more



© 2006-2015 OnToplist.com, All Rights Reserved