What is pagespace ?
Pagespace refers to either to an
unpartitioned table, to an index space, or
to a single partition of a partitioned table
of index space.
What is a page ?
This is the unit of storage within a table
space or indexspace that is accessed by
DB2.
What will the DB2 optimizer do ?
The optimizer is a DB2 component that
processes SQL statements and selects
the access paths.
What is a host variable ?
This is a data item that is used in an SQL
statement to receive a value or to supply
a value. It must be preceded by a colon
(:) to tell DB2 that the variable is not a
column name.
What will the FREE command do
to a plan ?
It will drop(delete) that existing plan.
What does DSNDB07 database
do ?
DSNDB07 is where DB2 does its sorting.
It includes DB2’s sort work area and
external storage.
What is Declaration Generator (DCLGEN)
DCLGEN is a facility that is used to
generate SQL statements that describe a
table or view. These table or view
descriptions are then used to check the
validity of other SQL statements at
precompile time. The table or view
declares are used by the DB2I utility
DCLGEN to build a host language
structure, which [...]
What are data types?
They are attributes of columns, literals,
and host variables. The data types are
SMALLINT, INTEGER, FLOAT,
DECIMAL, CHAR, VARCHAR, DATE
and TIME.
What is a data page?
A data page is a unit of retrievable data,
either 4K or 32K (depending on how the
table is defined), containing user or
catalog information.
What is a Database Request Module(DBRM)?
A DBRM is a DB2 component created by
the DB2 pre-compiler containing the SQL
source statements extracted from the
application program. DBRMs are input to
the bind process.
0 comments:
Post a Comment