Blog Posts - Mainframe



MQSeries Tutorial for Mainframe Programmers (1 of 5)

Middleware : “Middleware is software that is used to move data from one program to another, shielding the developer from dependencies on communications protocols, operating systems and hardware platforms.” Middleware products tend to fall in one...

Top DB2 concurrency features Lost Updates, Dirty Reads, Phantoms

When transactions are not serializable (which is often the case in multi-user environments): Lost Updates: This event occurs when two transactions read the same data and both attempt to update that data, resulting in the loss of one of the updates. F...

COBOL Usage is Pointer data item

Another extension of the USAGE clause is to define data items that contain addresses of data or procedures. These are POINTER items: POINTER A four-byte data item that holds the address of another data item. PROCEDURE-POINTER A four- or eight-byte da...

Mainframe TSO, how to get all the PDS to which a member belongs to

If you want to find a member but you don’t know the PDS to which it belongs and you only know the High level qualifier of the PDS. For example: Let’s consider High level qualifier as RF01.pp258c.* and member as RG57TDLT. Go to 3.4 and list all PD...

How to keep command does not disappear in TSO command line

Any command entered in the COMMAND LINE disappears after the successful execution of its intended function. If you want to repeat the same command , you got to re-type it or use some PF key to retrieve the last command entered. But here is a cool met...

3 Key points of Acquire BIND option in DB2

Acquires is one of the BIND options in DB2. Continue reading →...

2 Top features of IBM DB2 CHECK DATA utility

The CHECK DATA option checks the violation of the referential integrity rules between two tables. It also checks whether data values conform to the data validation constraints applied to the table space that is specified with the utility command. For...

How to know your version of DB2 in Mainframe

A tricky question for Mainframe DB2 programmers. Question is where I get information about DB2 version of sub system. The below post answers to this question. Secondly, each DB2 sub system can have different version of DB2. AS DB2 goes through V8, V9...

Mainframe: How SORTWKxx datasets increases sort performance in JCL

The use of more work data sets increases the maximum amount of data DFSORT can process in a single sort application. Any valid ddname of the form SORTWKdd or SORTWKd can now be used for DASD work data sets (for example, SORTWK01, SORTWKC3, SORTWK2...

Top features of SAS 9.2 for Mainframe projects ( 1 of 5)

How many ways you can invoke SAS in Mainframe: You can invoke SAS with any of the following methods: in interactive mode under TSO using the SAS CLIST in interactive mode under TSO using the SASRX exec in batch mode with the SAS cataloged procedure b...

Why to avoid SELECT COUNT(*) in your SQL query

Many queries in programs execute SQL Select Count(*) statements just to see if any rows exist for particular data. Many times it doesn’t matter whether there is one row or one million rows; it just matters if any rows exist. When this is the ca...

DB2 Error codes -204, -205, -206

The error code -204 says: The object name is undefined. Resolution is need to check if the DB2 object name is correct. The error code -205 says: Invalid column name. In other way, the column name is not defined on that table. Resolution is check if t...

Hierarchical file system (HFS) in Mainframe UNIX (1 of 2)

Files in a UNIX environment are organized into a hierarchical structure, If this looks familiar to you, that’s because both the DOS and Windows operating systems use a hierarchical file organization too. As you can see, all files within a hierarchi...

How a record in a KSDS is randomly accessed by primary key

As you’ve already learned, a KSDS consists of a data component and an index component. The primary purpose of the index component is to locate the records in the data component by their key values. To increase the efficiency of this process, the in...

ISPF basic editor commands for Software developers

COMMAND FUNCTION <  Data shift left Shifts a single line of program source code to the left without affecting the program labels or comment i.e. Data from column one to the first blank and data following several blanks are not moved. May be spec...

Mainframe COBOL Debugging mode ‘D’ in 7th Column

To get Display for each PARA instead of using 2-3 lines code we can do it by single line code. If you are writing a new code then it will be useful to use this tip. *SOURCE-COMPUTER.  IBM-370.   SOURCE COMPUTER IBM370.  WITH DEBUGGING MODE. And gi...

Mainframe tip- Resolution TSO session not allowing to do anything

If by mistake you try to browse the migrated dataset then your TSO session will not allow you to do anything and you will get below error. So to come out of this press  cntrl+shift+A  twice  then below message will appear- Press Y, then press any...

Mainframe tip- Resolution for ‘Member in Use’ error

Sometimes while opening the member of PDS in edit mode we see the message ‘Member in Use’ in that if you want to know who else is using that member then you press F1 twice or you can type WHOHAS in front of that member then it will show y...

Informatica Interview Questions- Part( 1 of 2 )

The following are the interview questions asked at CGI for informatica developers. What type of testing will do in project? A). Unit testing, System testing, Integration testing How many ways we can do performance tuning in informatica? A) – Op...

Mainframe tip to cut first 10 lines, last 10 lines from 10000 lines dataset

I have a dataset with 10,000 lines. I want to cut the first 10 lines and last 10 lines and paste into another dataset. When I cut the first 10 lines and then again the last 10 lines, only the last 10 lines are pasted into the new dataset. Is there an...


Trending Topics

Close