What is filter factor ?
One divided by the number of distinct values of a column. Read more »
Archive for March, 2008
What are simple, segmented and partitioned table spaces ?
Simple Tablespace: Can contain one or more tables. Rows from multiple tables can be interleaved on a page under the DBA’s control and maintenance Segmented... Read more »
What is FREEPAGE and PCTFREE in TABLESPACE creation ?
PCTFREE: percentage of each page to be left free FREEPAGE: Number of pages to be loaded with data between each free page Read more »
What is an inner join, and an outer join ?
Inner Join: combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of one table with... Read more »
What are the 4 environments which can access DB2 ?
TSO, CICS, IMS and BATCH Read more »
If I have a view which is a join of two or more tables, can this view be updatable ?
No. Read more »
Are views updatable ?
Not all of them. Some views are updatable e.g. single table view with all the fields or mandatory fields. Examples of non-updatable views are views which are joins,... Read more »
What does the sqlcode of -818 pertain to ?
This is generated when the consistency tokens in the DBRM and the load module are different. Read more »
What is sqlcode -811 ?
SELECT statement has resulted in retrieval of more than one row. Read more »
What is sqlcode -922 ?
Authorization failure Read more »
What is QUIESCE ?
A QUIESCE flushes all DB2 buffers on to the disk. This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency. Read more »
What is CHECK PENDING ?
When a table is LOADed with ENFORCE NO option, then the table is left in CHECK PENDING status. It means that the LOAD utility did not perform constraint checking. Read more »
What is COPY PENDING status ?
A state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove... Read more »
When do you use the IMAGECOPY ?
To take routine backup of tables, After a LOAD with LOG NO and After REORG with LOG NO Read more »