what is main use of table space and index object?
please its urgent
- 5 Answers
- 14980 Views
- CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro, I also Faced
- E-Mail Answers
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
How to check last update on table in db2?
What is a storage group (stogroup)?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is runstats db2?
What is the difference between nvl and coalesce?
What is a cursor in programming?
What is release/acquire in bind?
How to rename a table in DB2 ?
How does db2 sample database connect?
What is the function of logging in the db2 database?
How can record locking be achieved in those DB2 versions which do not support it?
Explain how can you do the explain of a dynamic sql statement?
What is the use of dclgen in db2?
Which component is responsible for processing sql statements and selecting access paths?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
