XPED Quick Tip

In Xped a DB2 query is replaced by a PERFORM until and a call like this: *****         CLM_GEN =                         *****          :DCLCLIAM.CL-CL-ID AND*****         CL_STATUS = :DCLCL

Caution while adding maps to Endevor

A special care needs to be taken while adding the maps to Endevor. A map has three types: - SDFIIPNL, SDFCOPY and SDFGRP. While adding a new map to Endevor, the SDFIIPNL is only added to it with correct processor group. The SDFCOPY is a

Recovery of a deleted dataset

There can be an instance when somebody unknowingly deletes your data set or by mistake you have deleted it but now you need it. HMS takes the back up of the dataset on each night. You can check whether your data set is backed up or not w

Basics of UMDT - User Maintained Data table

In February 1989, CICS announced enhancements for the CICS/MVS product and CICS/MVS 2.1. Most notable was the introduction of CICS Data Tables support, either as CICS Maintained Data Tables (CMDT) or User Maintained Data Tables (UMDT). ‘D

SDSF commands - Quick tips

BASIC SDSF COMMANDS Go to SDSF and then type I or H (for input or output queue respectively). The following commands can be executed only from the SDSF panel. 1) To see jobs submitted with a specific Job name :Type  â€œPre <Jo

5 SQL tuning Strategies - DB2

Tuning Strategies:   Ø       Tuning Strategy 1: ü       Adjust the COLCARD, FIRSTKEYCARD and FULLKEYCARD columns to an artificially high value. Reason: ü&nbs

Tuning of SQL queries in DB2 when RUNSTAT is not feasible

Updating the DB2 Catalog Statistics: Ø       This method of tuning is chosen whenever standard methods (RUNSTATS) of influencing the DB2’s access path selection are not satisfactory.  Ø 

Tweaking of SQL queries in DB2 - Use of Filter factor

Tweaking the SQL statements:  Ã˜       Tweaking is the process of changing a SQL statement without changing its functionality Ø       Filter Factor is a ratio that DB2

Tuning and optimisation of SQL in DB2 - Tips and Tricks

Most SQL queries are written with little importance to performance tuning. Often, this is not a problem when programs are tested in test environment, where performance is not an issue. But, production environments calls for lesser execution