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

Top DB2 Concurrency Issues 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. For example: Transaction 1 and Transaction 2 read the same row of data and…
COBOL: How to Initialize Pointer Variable an Example

COBOL pointer variable is one kind of data type. Initialization and how to use them you will know in this post.
How to find a member in list of datasets

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 PDS with RF01.pp258c.* Now issue, MEMBER RG57TDLT on…
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 method the make the command entered not to disappear…
DB2 Bind Option ACQUIRE – The Real Purpose

ACQUIRE bind tetrameter real usages
How to know Your Version of DB2 in Mainframe

DB2 Version in Mainframe
DB2 CHECK DATA Utility, Here’re Top Features

Utilities in DB2 checks data consistency while loading data into Tables. CHECKDATA utility has two top functionalities. It checks for referential integrity and Data validation constraints. Features of CHECKDATA Utility 2 Top Features The CHECK DATA option checks the violation of the referential integrity rules between two tables. It also checks whether data values conform…
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 by logging on to SAS directly and bypassing the TSO…
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