Rollback the transaction in both applications.

Rollback the transaction in one of the two applications.

Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

COL1 will accept NULL values and can be referenced in another table's foreign key specification.

COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.

COL1 will not accept NULL values and can be referenced in another tables foreign key specification.

COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.

Define the column MAINID as NOT UPDATABLE

Define the column MAINID as a PRIMARY KEY

Define the column MAINID as a FOREIGN KEY

Define an UPDATE trigger on table TABLEX

Summarized queries

Granular transactions

Voluminous historical data

Heterogeneous data sources

Application B will read the row.

Applications A and B will cause a deadlock situation.

Application B will wait until application A releases the Update lock.

Application A will be terminated so that application B can read the row.

Foreign key references cannot cross schema boundaries.

A DB2 user must be created before a schema with the same name can be created.

If no schema is specified when an object is created, the default schema PUBLIC is used.

A schema enables the creation of multiple objects in a database without encountering namespace collisions.

What is this customers address?

Does this customer have any unpaid bills?

What is the balance in this customers account?

What are the total sales for each of the last 6 months?

The cursor is only protected from updates and deletes by concurrent applications.

The row is only protected from positioned updates and deletes that reference another cursor of the same application.

The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

A sequence will never generate duplicate values

The MAXVALUE of a sequence can be equal to the MINVALUE

It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

DB2 for i5/OS

DB2 Runtime Client

DB2 Connect Enterprise Edition

DB2 for i5/OS SQL Development Kit