Complete Notes on DB2

There are three reasons for not using SELECT * in embedded SQL programs: If you change the table structure i.e. adding a field, the program will have to be modified. Program can retrieve the columns which it might not use, leading an I/O overhead. The chance of an index only scan is lost. In Embedded … Read more

Cursor stability ensures that any row that has been changed by activation group with a dissimilar commitment definition cannot be read before committing. In IBM Db2, cursor stability is one of the isolation levels that can be set for transactions. Isolation levels determine the visibility of changes made by one transaction to other transactions. Cursor … Read more

In DB2, a role is an object of database that group various privileges together and can be assigned to groups or user by GRANT statement. In the context of DB2, a “role” refers to a database object that is used to group together a collection of privileges or permissions. Roles provide a way to simplify … Read more

SPUFI stands for SQL Processor Using File Input. In the context of IBM Db2, SPUFI stands for SQL Processing Using File Input. It is a utility provided by IBM to interactively execute SQL queries and commands against a Db2 database. SPUFI allows users to submit SQL statements and receive the results interactively, making it a … Read more

The maximum size of a VARCHAR data type in DB2 is 4046 bytes. As of my last knowledge update in January 2022, the maximum size of the VARCHAR data type in IBM Db2 depends on the version and platform. In general, Db2 supports VARCHAR sizes up to 32,672 bytes. However, it’s important to note that … Read more