Mainframe Interview Questions and Answers

Big iron computer or Mainframes are a type of computer that generally are known for their large size, amount of storage, processing power and high level of reliability. They are primarily used by large organizations for mission-critical applications requiring high volumes of data processing. In general, there are a few characteristics of mainframes that are common among all mainframe vendors: Nearly all mainframes have the ability to run (or host) multiple operating systems. Mainframes can add or hot swap system capacity without disruption. Mainframes are designed to handle very high-volume input and output (I/O) and emphasize throughput computing. A single mainframe can replace dozens or even hundreds of smaller servers.

They are typically utilized by governmental and corporate organizations for added security as well as processing large sums of data; such as consumer statistics, census data or electronic transactions. Their reliability and high stability allow these machines to run for a very long time, even decades.

Distributed Relational Database Architecture (DRDA) is a set of protocols that permits multiple database systems. Any combination of relational database management products that use DRDA can be connected to form a distributed database management system. Which includes both IBM and not IBM systems, as well as application programs, to work together.

DRDA components are:

Application Requester: This is accepting SQL requests from applications and sends them to appropriate application servers for processing. It can access remote data using this function.

Application Server: This is receiving requests from application requesters and processes them. It acts on the portions of requests that can be processed, and forwards remainder to database servers for further processing.

Database Server:  This is receiving requests from the application server and other database servers. This server also supports distributed requests and forwards parts of the request to the database server to fulfill the request.

IBM Z is a family name used by IBM for all of its mainframe computers. In July 2017, with another generation of products, the official family was changed to IBM Z from IBM z Systems; the IBM Z family now includes the newest model the IBM z14, as well as the z13 (released under the IBM z Systems/IBM System z names), the IBM zEnterprise models (in common use the zEC12 and z196), the IBM System z10 models.

Data secured on IBM Z mainframes is locked down with 256-bit AES encryption, which is unbreakable with current technology. So, even if data is stolen, it’s of no use to the attackers. The new mainframes are designed to be compliant with data privacy laws, and they go a step further. Knowing that no security system is perfect, IBM has stored the decryption keys tamper-resistant. If the server detects a data breach, it invalidates all the keys until operators can investigate.

Z/OS is a 64-bit operating system (OS) developed by IBM for its family of z/Architecture enterprise mainframe computers, including the zEnterprise 196 and zEnterprise 114. Mainframes with z/OS are typically used to run large, complex, mission-critical workloads for large enterprise organizations.

The difference between Static and Dynamic Call is that the first has the invoking program name hard coded into the call statement while the second has it in storage in an identifier. Also, in the case of Static the invoking program is link edited with the invoked subroutine and in the case of Dynamic Call we will have a different module for each: the main program and the subroutine. IF we don’t use Initial or make a Cancel when we invoke the statically called subroutine then it will not be found in the default state; dynamically called routine will be forever in the default state.

DBD, short for Database Descriptor, restricts access to the database when objects get altered, created or dropped.

By using IDCAMS, we can say whether a GDG has any generations or not.

Linkage section is used to accept data from outside the program. Either it’s parm part of JCL or Call from any other programs, they pass data into called program thru linkage section only.

Move high values to the key of the VSAM file and the issue Readnext record command. Then give Read prev command. This will read the last record. In VSAM, there is one command HURBA, using that we can read the last record, if you want to know more about go to IBM RED BOOKS. You will get the solution. By using the HURBA we can get the max records by using the CKD count key data we will get the last record

It limits the changes that can be made to the primary key from a foreign key. For this purpose, the foreign key has to define a DELETE CASCADE rule.

Yes, it will work fine and create a +2-generation skipping +1 generation. If the current generation is 10, then the new generation created will be 12. Generation 11 will be skipped.

JOINKEYS helps to compare files and to write a file with matched records.

Start is used for the beginning of new transactions and then the XCTL takes the operations further, transferring the control to a different application but with an equal transaction ID.

File-aid tool is online tool (application) used for processing files using online screens. File-aid utility is used in JCL for processing files in batch.

It is the rule that states that consistency needs to be conserved between the foreign and primary keys. This means that each foreign key entry needs to have a fitting primary key entry.

By using ICETOOL we can find that.

This verb sets Alphanumeric, alphabetic and alphanumeric field items to ““(Space) and Numeric and Numeric edited field items to “0” (Zero). The INITIALIZE verb leaves FILLER items unchanged.

Notcat 2 is a MVS message that shows if two or more entries of the same catalog exist. If an entry is already there the catalog would send us an error message. The issue can be repaired by uncataloging or deleting the primary data set and we must find that volume which contains the new data set and we must catalog it.

COMP SYNC aligns an item to the natural boundaries, it will be synchronized right and left. If we use binary items that are found at the boundaries of words in memory, these ones have a more rapid address resolution. The size of word from mainframe memory is four bytes. So every word has to begin from an address which is divisible by four. When the primary variable is x(3) and the next one is s9(4) comp if the Sync clause is not specified, the second variable will begin from byte 3. When Sync is specified the beginning address will be 4; this more rapid, even if we may notice a little waste of memory.

A Control Area is a set of Control Intervals and it works during allocation. The size of the Control Area depends on the type of allocation (cyl, tracks, and records) and OTS maximum reaches 1 cylinder. The Control Interval is something like a block for QSAM files, its size is ranged between 512 bytes and 32 kilobytes, normally 2 or 4 kilobytes. If the Control Interval is bigger the performance will also increase when it comes to sequential processing.

HIDAM has a separate index file which is based on the root segment. This file has information regarding the pointer that marks the position of the data. On the other hand, HDAM file does not have separate index file, but the key field of every record is passed through a randomizer which places the record to a particular position in the database.

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.

Foreign keys are properties of a particular table having matching entries to a primary key in some another table. This results in the formation of a relation between the two tables.

It is a substitute to a synonym. Aliases are developed for distributed environments so as to avoid the use of location qualifier of a view or table. It is not dropped when the table gets deleted.

SPUFI is the abbreviated form of SQL Processing Using File Input. It is a menu-driven tool which the developers use to make objects in the database.

It is used to access IMS files for CICS Transactions and it is an address space. PSBs, DBDs, IMS files and ACBs are fixed into DBCTL for file access. Now if an IMS call is generated by a CICS program the processing gets transferred to DBCTL to be carried, and the result is sent as reply.

It is a file that makes accessing a file by alternate index possible. The path defines a relation between the base cluster and the AIX.

We can use JOINKEYS in SORT to compare two files based on certain fields.

If the program name is directly referred in the CALL statement then it is considered as Static call and if a working storage variable is referred in the CALL statement then it is considered as Dynamic call

We can do so by using below SORT fields

              Include cond=none

              Sort fields=copy

SQLCA is also a system defined copybook which is required to be used for any COBOL-DB2 program

There are many ways to check whether a file is empty or not and SORT/SELCOPY/IDCAMS can be used to do that

If table is empty then we alter this column to any length, but if some data get inserted into the table then we can also decrease the column length up to largest data size available in that particular column.

INSPECT is used to know number of times a specific character occurs or to replace some portion of data

Goback: returns control to the calling program

Stop Run: stops the current work unit and returns control to OS

Exit Program: It is used to come out of a program that has been called by another program

IEBGENER helps in copying one SAM File to some other Source. It is also used to perform simple data reformatting through the supply of control cards via SYSIN

INREC and OUTREC do the same but the only difference is the way reformatting is done.

When INREC is used, reformatting of records is done BEFORE the sort.

When OUTREC is used, reformatting of records is done AFTER the sort

-811 SQLcode is returned when a select query returns more than one row.

Dead lock timeout error occurs in the following case: If two or more programs acquired exclusive lock on the data, which may be needed for other programs without that data which cannot proceed further. Solution: You can roll back current unit of work for one of the programs after preset time interval for deadlocks and terminate that program.

The size of CI has to depend on the length of the record and the processing type. The normal value is 4 kilobytes but when the length of the record is bigger than 1 kilobyte we have to pick 6 kilobytes or 8 kilobytes. The normal values for FREESPACE are (20 20), when many insertions are made it should be bigger.

The main thing to do is repairing the problematic data, usually the cause for problems with SOC-7 is a numeric item that is un-initialized, and this is the primary concern. Some of the setups give us dumps for run-time abends, this can also be made by invoking OS services or subroutines via the assembly language. The dumps are useful as thei give us the ultimate instruction’s offset where the ABEND occurred. The output XREF listing of the compilation must be verified for obtaining the line number and the verb of this offset’s source code. After that the bug can be found in the source code. For capturing the runtime dumps, we should define datasets like for instance Sysabout in JCL. When these methods are not working we must find the error source with judgement and Display. If the setup has debugging utilities, we should make use of them.

While allocating KSDS Datasets, free space is declared at regular intervals at the time of initial loading. This is done because this free space is utilized for keeping the data arranged in sequence physically, even though inserted randomly.

TYPE 2 index is available for DB2V4. In this type, the data pages get locked, but the index pages are not locked. Therefore, TYPE 2 index are faster.

GDG (GenerationDataGroup) for defining it we will write the command DEFINE GENERATION DATA GROUP. In the IDCAMS step, a different data set has to be defined and its DCB parameters will be used at the time when new generations are made. This is what we call a model dataset, whose ds name has to be similar to the one of the GDG.

Subscript::Can be increment or decrement using arithmetic operations

Index::can be increment or decrement using set verb

Label record is standard means it will use disk files. But tape files can have standard label too. If the label record is omitted it should be the tape file without any begin and end blocks on the tape.

Pros:

• Excessive-level computing: One of many predominant traits of mainframe computer systems is their potential to course of knowledge and run functions at excessive speeds. Enterprise computing requires high-speed enter/output (I/O), greater than uncooked computing velocity. Mainframes successfully ship it. Additional, as enterprise computing additionally calls for broad bandwidth connections, mainframe design balances I/O efficiency and bandwidth.
• Stability: A major advantage of mainframes is that they are very stable compared to other types of computers.
• Mainframe computers also need special operating systems and software to be able to take full advantage of their hardware, which complicates the installation process even more.
• Mainframes are at the heart of our business
• Virtualization: A mainframe system can be divided into logical partitions.
• Reliability, availability, and serviceability.
• IBM z Systems mainframes: It is focused on developing tools that help companies running IBM mainframes get the most out of their investments
• Long lasting performance: Mainframe computers are known for their long-lasting performance.
• Security: As mainframes are designed specifically for large organizations where the confidentiality of data is critical, mainframe computers have extensive capabilities for securely storing and protecting data.
• Disaster recovery capability that meets your specifications at the best possible price.

Cons:

• One of the most noticeable disadvantages of a mainframe computer is its cost, which is significantly higher than the cost of a regular computer Hardware and software for mainframes are clearly expensive.
• Mainframe occupies more room than different computer systems. That enormous house may be a constraint for small institutions. However, that drawback shouldn’t be so extreme because it as soon as was. In comparison with earlier machines, right this moment’s mainframes are small.
• Finally, one needs high-end skills to work with mainframe computers.

(Wikipedia)