Blog Posts - Db2



Use of REBALANCE in REORG Utility

An always used utilty-REORG, which improves performance as overall.

DB2 Express Edition for Transaction Processing. Read More!

An entry-level budget friendly database system, designed for small and medium businesses IBM® DB2® Express Server Edition is an entry level database system designed for transaction processing and handling complex query workloads. It provides enter...

DB2 Express Edition for Transaction Processing. Read More!

An entry-level budget friendly database system, designed for small and medium businesses IBM® DB2® Express Server Edition is an entry level database system designed for transaction processing and handling complex query workloads. It provides enter...

How to get SQLCODE in DB2 COBOL Program without SQLCA

Below are the best techniques either ways you can use: Declare SQLCODE and SQLSTATE (SQLCOD and SQLSTA in Fortran) as stand-alone host variables. If you specify the STDSQL(YES) precompiler or SQL statement coprocessor option, these host variables rec...

Understanding The Background Of Data Modelling Cordinality.

When performing data modeling in preparation for designing a database, knowing that two entities are related to each other is not sufficient. In addition to knowing that they are related, the cardinality of the relationship must also be documented. C...

DB2 LOAD And UNLOAD JCL Is Not Rocket Science! Here’s Why

DB2 UNLOAD sample JCL. //UNLOAD JOB (ACCOUNT),’NAME’ //* //* THIS JCL HAS BEEN REWRITTEN IN ORDER //* TO PROPERLY UNLOAD THE DATA FROM DB2 TABLES. //* DSNTIAUL IS USED FOR UNLOAD INSTEAD OF DSNUPROC //* UTILITY. //* THEREFORE, PLEASE, NOT...

How the Multiple versions of Package is useful in DB2

The below are the reasons, apart from our regular development, you need to keep multiple package versions in DB2. Sometimes we would like to keep multiple VERSIONs of the same PACKAGE. For example, in a fallback situation, it would be nice to have bo...

How to run COBOL program with different versions of Db2 Package

Creating a package version: If you want to run different versions of a program without needing to make changes to the associated application plan, use package versions. This technique is useful if you need to make changes to your program without cau...

Increase DB2 performance through data redundancy

It does not matter to a user why his or her database request failed. Whether a transaction timed out because of bad performance, or a component of the solution failed, or an administrator has taken the database offline to perform maintenance, the res...

How you can use ‘DISPLAY UTILITY’ in DB2

The DB2® command DISPLAY UTILITY displays the status of utility jobs, including utility jobs in a data sharing group. The output from the command consists of informational messages only. One set of messages is returned for each job identified by the...

NVL and COALESCE functions basic differences in DB2

The NVL function returns the first argument that is not null. ==>NVL(expression1, expression2) The arguments are evaluated in the order in which they are specified, and the result of the function is the first argument that is not null. The result...

Why DB/DC does not support for Batch programs

The interesting point is DB/DC does contain both transaction manager and database manager. So this region supports to CICS to access IMS database. Except BATCH it supports for all kinds of transactions. Note: Pure BATCH runs under MVS address space.

Five Facts About Db2 Cursors That Will Blow Your Mind

These are some of the interesting points on DB2 Cursors. The Cursor WITH HOLD does not impact on IMS DC programs. In CICS, the WITH HOLD does maintains Cursor position till end of the unit of work Cursors will not be closed by ROLLBACK operation, eve...

How to Declare Read-Only Cursors in DB2

I am very cool today reading Db2 magazine. I have got an idea why can’t I write a post on DB2 Read-only cursors. So I have written this excellent post. There are so many rules to say a cursors is Read-only. Below are the list of rules, that sa...

DB2 Cursors Tricky interview Question

Q) Can we open the same cursor multiple times, when you use more than one DB2 subsystem ? A) The answer is ‘Yes”. Many programmers said ‘No’ to this question. But this is a tricky interview question. Recently my friend faced s...

How “SYSIBM.SYSDUMMY1” different from other catalog tables

The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required. You can read here how many ways we can use SYSDUMMY1 table in DB2. Continue reading →...

Differences of DB2 SELECT, Sub-SELECT and Full SELECT

SELECT -The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement or FOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause. It can...

MQSeries Tutorial for Mainframe Programmers (5 of 5)

A  queue manager is that part of an MQSeries product that provides the messaging and queuing services to application programs, through the Message Queue Interface (MQI) program calls.  It controls access to queues and serves as transaction (syncpoi...

Frequently happen COBOL compilation errors

The following are the list compilation errors occurred during compilation of COBOL programs: Misspelling the name of a DIVISION. In Micro Focus Personal COBOL, misspelling IDENTIFICATION DIVISION produces an error of PROCEDURE DIVISION MISSING. This...

How to write ‘COBOL Program’ in DB2 stored procedure Zo/s

I want to add more points on how to write COBOL program in DB2 stored procedures. The functionality of below stored procedures is: Searches the catalog table SYSROUTINES for a row matching the input parameters from the client program. The two input p...


Trending Topics

Close