export-import in 9.7

[Former Member]

Hello DB6 experts!

I've made an export-import in a 9.7 database.

The problem is that after this clean process, I can't use the statement:

db2 alter tablespace tbs_name reduce MAX

it gives me an error:

SQL1763N Invalid ALTER TABLESPACE statement for table space

It's an error expected if the tablespace was created in a db version previous that 9.7.

Although, sin I have made an export-import, I think that tablespace was created in 9.7 version.

Do you know how can I get rid of this error?

regards,

Filipe Vasconcelos

[Former Member]

I was able to check the log sapinst_dev.log and there is the following statement:

function createTablespaceCreateStatement <done>, return <create tablespace PR8#BTABD

in nodegroup SAPNODEGRP_PR8 pagesize 16k extentsize 2 prefetchsize automatic

no file system caching

dropped table recovery off;

So these tablespaces were created in 9.7 during the import.

thanks.

regards,

Filipe

[donald_voorhees]

Is this a SAP system?

If so, user the program DB6CONV via se38, it does an online table move/reorg and reclaims all free space.

There is a SAP note that has the program as a transport attachment.

[Former Member]

Hi Joachim,

It's weird!!!

I've made export-import using database independent procedure with sapinst. Since this system was already in version 9.7 (during export) it should create tablespaces correctly in import.

I have created database with autostorage and autoresize options in sapinst.

Any idea why this is like this?

regards,

Filipe Vasconcelos

[Former Member]

Hi Filipe,

Sorry, but I have no idea. Never seen this before. All of our databases are created with 9.7 and no problem...

I suggest you open an message for this behaviour.

Best regards,

Joachim

[Former Member]

Hello Joachim,

In fact these tablespaces have column RECLAIMABLE_SPACE_ENABLED is 0 in these tablespaces.

As I've done an export-import, shouldn't these tablespaces be with RECLAIMABLE_SPACE_ENABLED as 1?

thanks.

regards,

Filipe

[Former Member]

Hello Filipe,

creating a new DB2 v9.7 database with automatic storage the default for the tablespace is "reclaimable".

I can't believe that this is a DB2 V9.7 database. How do you create the database?

Best regards,

Joachim

[Former Member]

Hello Filipe,

is the tablespaces really "reclaimable":

SELECT MEMBER, TBSP_NAME, TBSP_TYPE, RECLAIMABLE_SPACE_ENABLED,

TBSP_USING_AUTO_STORAGE, TBSP_AUTO_RESIZE_ENABLED

FROM TABLE (MON_GET_TABLESPACE('', -2));

Run the sql the see the status of RECLAIMABLE_SPACE_ENABLED column.

Best regards,

Joachim

[Frank-Martin]

Hi Filipe,

what is the reason code of the error?

Regards

Frank