Burnup chart is used to show how many story points are in the product backlog versus how many we’ve completed till date, as well as how much work remaining in the project (Not on Sprint level but at project level). In other words it displays the scope of a project and the work completed. Burnup […]
Burnup Chart – Sprint & Release Tracking Read More »
A Burndown chart is a graphical representation of work left to do versus time. Each point on the chart shows how much work was left to do at the end of that day (or week, month or other time period). In the Daily Scrum the Development Team updates the Sprint Burndown and plots the remaining work of the day. It is a chart
BurnDown Chart – Sprint, Release and Product Tracking Read More »
A Product Owner’s most important word: “No” & Saying No to a stakeholder is very difficult. Stakeholder management is the process of engaging with these people, and maintaining good relationships with them. You’ll likely be working with people in many different roles, with varying levels of influence over your project. Make Stakeholders feel heard and understood
Saying No to Stakeholder by Product Owner Read More »
Figurative constants are reserved words that name and refer to specific constant values. These can be easily used by writing the word itself instead of the value. The figurative constants supported by COBOL are: ZERO, ZEROS, ZEROES SPACE, SPACES HIGH-VALUE, HIGH-VALUES LOW-VALUE, LOW-VALUES QUOTE, QUOTES ALL literal – which means fill the field with ALL
Figurative constants use in COBOL Programs Read More »
Two types of abend codes, user abends and system abends (S0C Abends). User abends format is Unnnn, where nnnn is a decimal user abend code. System abends follow the format of Snnn, where nnn is a hexadecimal abend code. S0C Abends are the abnormal ending of Job & when it happens a message from the JCL or Fault Analyzer will
S0C Abends – S0C1 S0C4 S0C5 S0C7 Read More »
In this tutorial we will learn how the Outlook search function works and how you can use it to quickly search emails you are looking for.The Outlook Instant Search Tool provides a simple and easy to use set of features that will allow you to search through your Email messages. You activate the Outlook Search
Outlook Search Function: Find Emails Quickly Read More »
Database NORMALIZATION is used to reduce data redundancy and eliminate undesirable characteristics like Database Anomalies (Update anomaly, Insertion anomaly, Deletion anomaly). This also divides larger tables into smaller tables and links them using relationships and follows simple data structure design rules to make the data easy to understand, maintain and query. Rule of Clarity –
Database Normalization with Examples Read More »
By default, cursors are moved by 1 row at a time in the result table in sequential order starting from the first row. To remove this limitation SCROLL clause is used to indicate whether the cursor moves sequentially through the result table or can move randomly through the result table. You can declare row-positioned or
SCROLL vs NO SCROLL Cursors in DB2 Read More »
TIME parameter specifies the maximum amount of time that step may use the processor or to find out through messages how much processor time a step used. It is an optional Keyword parameter & this is important to save MIPS(Million Instructions Per Second). This can be used either in JOB or in STEP or in
TIME parameter use & S322 Abend in JCL Read More »
IF THEN ELSE ENDIF construct is used to conditionally execute job steps within a job. A job step execution can be controlled based on the return code of the previous step(s) using the COND parameter and IF-THEN-ELSE-ENDIF construct. The IF statement is always followed by a relational expression and a THEN clause. Optionally, an ELSE
IF THEN ELSE ENDIF construct use in JCL Read More »
COND parameter is used to test return codes from previous job steps and determine whether to bypass or execute specified job steps. Return code is set based on the status of execution of a job. The return code can be a number between 0 (successful execution) to 4095 (non-zero shows error condition). 0 = Normal
COND Parameter – Evaluate Return Code in JCL Read More »
Space ABEND generally occurs when your system encounters the end of volume condition occurs. There are three types of Space ABEND as mentioned below. SB37: There are not enough space or no more extents available on the current volume. The system gave all the primary space and as much secondary space as it could. Disk
Space ABEND – SB37, SD37, SE37 & Resolution Read More »
SQL Error Code is used on a day to day basis for the diagnosis of programming failures as a result of SQL calls by DB2 computer programs. An important feature of DB2 programs is the error processing. The error diagnostic containing the SQL Error Code are held in the field SQLCODE within the DB2 SQLCA block. This Instant
SQL Error Code with Explanation & Resolution Read More »
The OPTION control statement allows you to override some of the options available at installation time (such as EQUALS and CHECK) and to supply other optional information (such as DYNALLOC, COPY, and SKIPREC). Some of the options available on the OPTION statement are also available on the SORT or MERGE statement (such as FILSZ and
OPTION control statement in SORT JCL Read More »
The LISTCAT command is used to list and view the attributes and characteristics like space allocation information, password and security-related information, usage characteristics, creation, and expiration date, etc of VSAM or non-VSAM entries. It stands for LISTing of CATalog entry. The LISTCAT line command allows access to IDCAMS and displays the tablespace or indexspace space usage
LISTCAT use in retrieving GDG or VSAM Information Read More »
SPS Practice Exam (SPS) – Scaled Professional Scrum with Nexus helps you to gain an understanding of how to scale Scrum using the Nexus Framework and launch structure, staff, and manage large Agile projects using Scrum. The SPS Practice Exam questions are designed to help you prepare and practice for the Scrum.org Scaled Professional Scrum Assessment.
SPS Practice Exam Practice Mode Questions Read More »
You can use one of the numeric test capabilities of the INCLUDE OMIT Numeric test statement to collect the records you want. You can use one of the numeric test capabilities of the INCLUDE OMIT Alphanumeric test statement to collect the records you want. You can use the INCLUDE OMIT Substring Comparison statement in conjunction
INCLUDE OMIT Numeric Test Alphanumeric Test Read More »
You can use the INCLUDE OMIT Substring Comparison statement in conjunction with other options to select/omit the number of records to be processed, which can reduce processor and data transfer time. There are two types of INCLUDE OMIT Substring Comparison tests: Find a constant within a field value: For example, search the value in a
INCLUDE OMIT Substring Comparison using SORT Read More »
Velocity is used for measuring the rate at which scrum development teams consistently deliver business value in other words quantity of work a team can accomplish within a sprint. In simple terms, velocity is the sum of the story points that a team can deliver in an iteration. It can be measured in terms of
Velocity vs Capacity in Sprint Planning Read More »
Outlook Rules evaluate your incoming or outgoing email messages and take various actions with them based on sets of instructions you set up, called . You can create outlook rules based on different message criteria, such as the message sender, message recipients, message content, attachments, and importance. Server-based outlook rules vs client-only outlook rules There
Outlook Rules : Manage Email messages using Rules Read More »
The Agile Coach is someone who is experienced in implementing agile projects and can share that experience with a project team. An Agile Coach helps to define what is to be done, how, who does it, when, why, how it fits in with the organization, change management, people management and interactions between agile teams and other parts of the organization
Agile Coach Interview Questions and Answers – I Read More »
SQL Query optimization is a process of writing optimized SQL queries to improve database performance. It is one of the factors that affect application performance. When working with large-scale data, even the most minor change can have a dramatic impact on performance. Top 10 ways to improve performance Indexing: Proper indexing ensures optimal access to
SQL Query Optimization: Tips & Tricks Read More »
The DB2 Predicates affect how DB2 selects the access path for the statement. Predicates are found in the WHERE, HAVING, or ON clauses of SQL statements; they describe attributes of data. Most DB2 predicates are based on the columns of a table. They either qualify rows (through an index) or reject rows (returned by a
DB2 Predicates : Performance Tuning of DB2 Queries Read More »
SQL predicates, also referred to as conditional expressions, specify a condition of a row or group that has one of three possible states: TRUE, FALSE NULL (or unknown). SQL Predicates are found on the tail end of clauses, functions, and SQL expressions inside of existing query statements SQL Predicates Categories Basic Predicate – A basic
SQL Predicates: use in COBOL DB2 Queries Read More »
XSUM Control Statement captures the dropped duplicate records which are eliminated out of DFSORT in a separate file. The SUM Control Statement deletes records with equal control fields and optionally summarizes specified numeric fields on those records. The SUM control statement specifies that, whenever two records are found with equal sort or merge control fields, the
XSUM – Remove Duplicate Records using SORT Read More »
