what is main use of table space and index object?
please its urgent
Answer Posted / venu
Table Spaces are phsysical spaces where the tables are
created. Index spacesa are automatically created when
indexes are created, indexes are stored in index spaces.
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
What is the use of db2 optimizer?
Can we update view in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is dbrm? What it contains?
What is buffer pool and list some of them?
How to find schema of a table in db2?
Is the primary key a clustered index?
What is the syntax for FETCH in DB2 ?
Define predicate?
B37 abend during spufi?
Comment whether the cursor is closed during commit or not.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is node in db2?
Why select is not preferred in embedded sql programs?
How do you concatenate the firstname and lastname from emp table to give a complete name?