PSAPSR3701: tablespace not empty after SRM 7.0 EHP2

[Former Member]

Dear all

I'm experiencing an non severe oracle issue during EHP upgrade of SRM 7.0 from EHP1 SPS08 to EHP2 SPS07, based on Oracle 11.2.0.3 SBP May 2013 - HPUX 11.3

Now, we are going to complete le follow up activities, so the deletion of old tablespace too.

But the TS PSAPSR3701 is NOT empty as expected.

I've just take a look into the some oss/KBA and threads on SDN, and I found:

KBA1715052 - tablespace cannot be deleted after upgrade

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...

and SDn

http://scn.sap.com/thread/3294166

Owner Object Type Tablespace

KBytes

Blocks Extents MaxExtents Next (K)

SAPSR3 TTREE_APPL TABLE PSAPSR3701

64 8 1 1- 160

SAPSR3 TTREE TABLE PSAPSR3701

192 24 3 1- 160

SAPSR3 TTREEI TABLE PSAPSR3701

448 56 7 1- 2.560

SAPSR3 TTREEP TABLE PSAPSR3701

320 40 5 1- 640

SAPSR3 TTREET TABLE PSAPSR3701

256 32 4 1- 640

SAPSR3 TTREE_FLNK TABLE PSAPSR3701

512 64 8 1- 2.560

Total

1.792 224 28

Seems that in order to fix this error, I should perform a reorg of the old TS to the new one.

brspace -p init<SID>.sap -s 20 -l E -f tbreorg -a reorg -mode online -s PSAPSR3701 -o SAPSR3 -t TTREE_APPL -n PSAPSR3731

brspace -p init<SID>.sap -s 20 -l E -f tbreorg -a reorg -mode online -s PSAPSR3701 -o SAPSR3 -t TTREE -n PSAPSR3731

brspace -p init<SID>.sap -s 20 -l E -f tbreorg -a reorg -mode online -s PSAPSR3701 -o SAPSR3 -t TTREEI -n PSAPSR3731

brspace -p init<SID>.sap -s 20 -l E -f tbreorg -a reorg -mode online -s PSAPSR3701 -o SAPSR3 -t TTREEP -n PSAPSR3731

brspace -p init<SID>.sap -s 20 -l E -f tbreorg -a reorg -mode online -s PSAPSR3701 -o SAPSR3 -t TTREET -n PSAPSR3731

brspace -p init<SID>.sap -s 20 -l E -f tbreorg -a reorg -mode online -s PSAPSR3701 -o SAPSR3 -t TTREE_FLNK -n PSAPSR3731

Could you please confirm is this is the right solution? Or maybe I should fix it in a different ways?

Regards,

Cristian

[Former Member · Accepted solution]

Hi Cristian

that's the solution and I would add a check to SE11 in technical settings of the same tables to see if parameters regarding tablespace are correct after the reorg

...and  this is the note that confirm my answer Note 1819182 - Tables (TTREE*) remain in old exchange tablespace

Let me know if you need further details

a

[Former Member · Accepted solution]

Grazie Andrea,

it was just the information I was looking for!

Best regards

Cristian

[Reagan]

Hello

You may execute this

brspace -c force -o process,time -u / -f tbreorg -a reorg -tablespace PSAPSR3701 -t "*" -parallel 3 -degree 3 -newts PSAPSR3731

Good Luck

RB