Table Space concept in DB2: Table space is a database object where actually the table data gets stored. It is a like child of the database, where there can be multiple table spaces within a database. Each table space contains the ‘containers’. There can be one or more containers per table space. Containers can be
ESCAPE in DB2 Mainframes: In SQL the percent sign(%) and the under score(_) has special meaning. %’ – represents any set of characters _ – under score represents any single character. Ex: select * from emp where email like 'reddy_%'; This will display all the email ids starting with reddy like reddy123,reddy_34 etc. But here
ORDER BY DB2 Order by clause is used to sort the result table values by the sort Key order. Here, sort key can be the column name or column number. Results can be sorted either by Ascending (ASC) or by Descending (DESC) order. ASC is the default order by clause. If you do not specify
DB2 Isolation Levels: How Isolation Levels are useful, what are the different Isolation Level types(CS, RR, RS & UR), how it controls the concurrency, What is Concurrency?, which one is better to use among the four types? What are the advantages and disadvantages ?These are the questions we often encounter. So this topic explains these queries
What is a DB2 Lock? It is a Mechanism provided by DB2 to maintain the access to different database objects. What is Concurrency in DB2? Concurrency is a way which enables more than one application to access the same database object at the same time. Locks and Concurrency control is the most important aspect in
