The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between
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, ...
For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently.
Latest Answer : Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index ...
The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing
Latest Answer : 3 types of locks are SHARE EXCLUSIVE UPDATE ...
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.
Latest Answer : To explain it let us take an example....Suppose we have a query that updates a table once the task is complete the table gets updated(commit), and all the relevant resources acquired by the task is released..With hold option does not release the resouces ...
A54. The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program.
Latest Answer : IT IS USED TO PERFORM THE SPECIFIC USER DIFINED FUCNTION FOR THE PARTICULAR SQL RETURN CODE..For Ex ,Whenever sqlcode = 100 Display "whenever condition returncode is 100"whenever sqlcode = 811 Display 'whenever condition ...
The FREE command can be used to delete plans and/or packages no longer needed.
Latest Answer : PCTFREE : It allows for insertion of new records and for expansion of variable length fields.
FREEPAGE : The number of pages to be loaded between each page left free. It is useful for finding a near page for inserting a new record. ...
Latest Answer : User ALTER command to change the PRIQTY and SECQTY of the Tablespace.Eg. ALTER TABLESPACE db.ts PRIQTY 50 SECQTY 50.Here PRIQTY => primary quantity in 50 KB and SECQTY => Secondary quantitly ...
What is a collection ID? What is its significance? How to execute the different versions of a Cobol-DB2 programs (different regions) from a single jcl?
In DB2, table space is an LDS which does not support index concept. But index is an back bone of DB2. How DB2 supports index? Explain?
