recover tablespace

hostname · #1 (**permalink**) 12-11-12, 19:57

Hi All,

Can anyone tell me, at what are all conditions, we can usually go for drop and recreate the tablespce.?

db2girl · #2 (**permalink**) 12-11-12, 22:58

Different reasons - one is to change the page size.

hostname · #3 (**permalink**) 12-12-12, 14:59

Thanks much, is that like we need to change the parameters like PCTFREE AND FREEPAGE while creating tablespace.

Correct me ,if i am wrong.

Marcus_A · #4 (**permalink**) 12-12-12, 16:20

Quote:

Originally Posted by hostname

Thanks much, is that like we need to change the parameters like PCTFREE AND FREEPAGE while creating tablespace.

Correct me ,if i am wrong.

You need to specify which DB2 version and operating system. There are multiple DB2 products for various platforms and they are not the same with regard to tablespaces.

hostname · #5 (**permalink**) 12-12-12, 16:33

Db2 version 9 and Z/OS .

db2girl · #6 (**permalink**) 12-13-12, 13:54

You can specify PCTFREE and FREEPAGE when creating a tablespace and after it has been created. See:

IBM Information Management Software for z/OS Solutions Information Center
IBM Information Management Software for z/OS Solutions Information Center

hostname · #7 (**permalink**) 12-16-12, 09:12

Thanks, it help me lot

Internet Services

Web Development

Digital Marketing

Consumer Tech