Monday, June 11, 2012

DB2-3

Q.  What is a row?
A       A row is a single occurrence of columns (of data) described by the table definition.

Q.  Describe what a storage group (STOGROUP) is?
A       A STOGROUP is a named collection of DASD volumes to be used by tablespace and index space of databases. The volumes of a STOGROUP must be of the same device type.

Q.  What is meant by synonym?
A       A synonym is an alternate name for a table or view which is stored in the SYSIBM.SYSSYNONYMS table.

Q.  Describe what a table is?
A       A table is a DB2 structure in which column names are used to specify the information that is being stored by row.

Q.  What is a tablespace?
A       A tablespace is a VSAM dataset which is used to store one or more tables. The physical page can consist of 4K or 32K pages.

Q.  How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
A       1. If the tablespace used is only allocated to that STOGROUP :
·                    ALTER STOGROUP-add volume (new) delete volume (old)
·                    REORG TABLESPACE or RECOVER TABLESPACE
2. Create a new stogroup that points to the new volume. ALTER the tablespace and REORG or RECOVER the tablespace.

Q.  What is the format (internal layout) of 'TIMESTAMP'?
A       This is a seven-part value that consists of a date (yymmdd) and time (hhmmss and microseconds).

Q.  What is a unique index?
A       An index specified as unique is an index for which no duplicates are allowed.

Q.  What is meant by a unit of recovery?
A       This is a sequence of operations within a unit of work (i.e., work done between commit points).

Q.  What is a view?
A       A view is an alternative representation of data contained in one or more tables.  A view can include all or some of the columns contained in the table or tables.

Q.  What does a view do?
A       A view restricts access to specific columns and rows.
  
Q.  What is a data model?
A       A data model is a way of representing entities, attributes and relationships.

Q.  When a transaction issues a commit, to what is the commit writing?
A       A commit triggers a write to a log record.

Q.  Can DASD types assigned to storage groups by intermixed (i.e., 3350s and 3380s)?
A       No.

Q.  What type of information is contained on the BSDS?
A       The BSDS contains information about active and archive logs, their dataset names and volumes on which they reside.

Q.  What are the three types of page locks that can be "held"?
A       Exclusive, update, and share.

Q.  Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
A       DB2 can be invoked by TSO users by using the DSN RUN command.

Q.  What are the names of the different types of DB2 tablespaces?
A       Simple, segmented and partitioned.

Q.  What is the maximum number of partitions allowed in a partitioned tablespace?
A       The maximum is 64.

Q.  How are write I/Os from the buffer pool executed?
A       Asynchronously.

Q.  After a table has been recovered, which flag is turned on?
A       The Copy Pending flag is turned on.

Q.    What is the DB2 catalog?
A       The DB2 catalog is a set of tables that contain information about all the DB2 objects (tables, views, plans, etc.).

Q.    In which column of which DB2 catalog would you find the length of rows for all tables?
A       In the RECLENGTH column of SYSIBM.SYSTABLES.

Q.    What information is held in SYSIBM.SYSCOPY?
A       The SYSIBM.SYSCOPY table contains information about image copies made of the tablespaces. 

Q.    What information is contained in a SYSCOPY "entry"?
A       It includes the name of database, tablespace name, and the image copy type (full, incremental, etc.), as well as the date and time each copy was made.

Q.    What information can you find in SYSIBM.SYSLINKS table?
A       The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints.


Q.    Where would you find information about the type of database authority held by a user?
A       SYSIBM.SYSDBAUTH.

Q.    Where could you look if you had a question about whether a column has been defined as an index?
A       This information can be found in SYSIBM.SYSINDEXES.

Q.    Once you create a view, where would information about the view be stored?
A       When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS.

No comments:

Post a Comment