On the create tablespace, what does the CLOSE parameter do?

Question Posted / guest

1 Answers
5166 Views
I also Faced
E-Mail Answers

On the create tablespace, what does the CLOSE parameter do?..

CLOSE YES parameter tells DB2 that when DB2 needs to close
datasets when DSMAX is reached, DB2 will choose this
tablespace to be closed.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More DB2 Interview Questions

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers Deloitte,

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

List out the data types available.

0 Answers

How can you split a table in to exactly half?

7 Answers HSBC,

What is the purpose of using commit?

0 Answers

Which catalog table stores referential constraints?

1 Answers

What is the maximum number of columns in a db2 table?

0 Answers IBM,

Mention the length of physical storage of the given data types of db2 – date, timestamp, time