An application plan or package is generated by the bind to define an access path.
Latest Answer : DB2 plan is executable form of sql staements(DBRM).you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths. ...
Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy.
A view is a virtual table made up of data from base tables and other views, but not stored separately.
Latest Answer : View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating ...
Tables are stored in tablespaces (hence the name)! There are three types of tablespaces: simple, segmented and partitioned.
Latest Answer : Any database contain one or more Table spaces. Each Table space is devided into pages of size 4kb or 32kb. Each table psace can have one or more tables. TABLE SPACE SPACE IS UNIT OF RECOVERY OR REORGANIZATION.
There are 3 types of Table Spaces
a) ...
To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously.
A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly
Latest Answer : A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a column has a NULL value, Oracle ignores any UNIQUE, ...
A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities
Latest Answer : Also, a Synonym is specific to the DB2 subsystem. Synonym can only access the table or view in the subsystem in which it is defined. A synonym is dropped when the table is dropped.An Alias is yet another name for a table or view. But ...
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.
The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.
Latest Answer : keep it simple. The DB2 catalog is under the schema SYSIBM (along with a whole lotta other stuff as well). ...
