A QUIESCE is used to flushes all DB2 buffers on to the disk. This will give you a correct snapshot of the database.To maintain consistency it should be used before and after any IMAGECOPY.
Cluster Index Causes the data rows to be stored in the order specified in the index. A mandatory index defined on a partitioned table space.
Primary Key: Primary key is a relational database constraint, Primary key consists of one or more columns that uniquely identify a row in the table For a normalized relation, there is one designated primary key.
Unique index: A physical object that stores only unique values There can be one or more unique indexes on a table.
SQLCODE -922 is Authorization failure
The result of an embedded select statement or a subselect in the set clause of an update statement is a table of more than one row, or the result of a subquery of a basic predicate is more than value..
|
|
||||||||||||||||||||||||||||
