Srini

Srinimf

Blog: https://srinimf.com/
Blog: https://srinimf.com/
Profile: https://srinimf.com/author/moonrobot/
Profile: https://srinimf.com/author/moonrobot/
Homepage: https://srinimf.com
Homepage: https://srinimf.com

How to Increase Sort Performance with SORTWKxx Dataset

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, SORTWK#5, SORTWKA, SORTWKXY and so on). Limit of number of input datasets for sort JCL…
Why Not to Use COUNT(*) in Production Top Reasons

Here are the top reasons why you cannot use count all in production boxes.
SQL DB2: Error codes -204, -205, -206 Resolution

SQL error resolutions for -204, -205 and -206
Hierarchical file system (HFS) in Mainframe UNIX (1 of 2)

HFS Files tutorial mainframe and UNIX
Here’s a List of Basic ISPF Editor Commands

Here are useful ISPF editor commands for your daily use. 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 specified…
5 Top Rules of COBOL Redefines Clause

You can storage of one variable using Redefines in COBOL. Read the complete redefines rules in COBOL
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 key and press enter .Your TSO session will be…
Mainframe COBOL Debugging mode ‘D’ in 7th Column

The purpose of COBOL column 7 and how you can use it for debugging. Read more on this.
Frequently asked Informatica Interview Questions

The Informatica general interview questions asked in many interviews. These really good questions are highly suitable for production supports ETL developers working on Informatica tool.
How to Fix Member in Use error in Mainframe

ISPF resolution for ‘Member in use’. Read more.
Mainframe tip to cut first 10 lines, last 10 lines from 10000 lines dataset

Command to cut first 10 lines and last 10 lines in Mainframe
Ideas: How to Edit IMS DB Segments Using FileAid

Explained ideas to edit IMS DB segments using FileAid.