cancel
Showing results for 
Search instead for 
Did you mean: 

PSAPTEMP Tablespace in ECC6.0

Former Member
0 Kudos

Dear all,

After upgrading from 4.6c to ECC6.0, we found that the tablespace PSAPTEMP is quite different from the other tablespaces.

Given below is the brtools output of the tablespaces:

Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]

.

.

.

45 - PSAPSTABI DATA ONLINE LOCAL MANUAL NO 2/0

16777216 85.04 2509248 16777216 0 264 664576:656384:262080:262080:109568

46 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 1/0

9216000 0.00 9216000 9216000 0 0 0:0:0:0:0

47 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 5/0

6725632 0.00 6725312 6725632 0 842 290816:287744:142336:139200:95232

PSAPTEMP alone has the last field as 0:0:0:0:0.

1. Do we need to modify/alter the psaptemp tablespace to be normal?

2. How do we assign the correct size of the PSAPTEMP tablespace to our environment?

Thanks & Regards

Senthil

Accepted Solutions (0)

Answers (2)

Answers (2)

stefan_koehler
Active Contributor
0 Kudos

Hello Senthil,

>> 1. Do we need to modify/alter the psaptemp tablespace to be normal?

No. PSAPTEMP should be a temporary tablespace... it is correct and has "only" advantages.

>> 2. How do we assign the correct size of the PSAPTEMP tablespace to our environment?

This really depends on your users and your selects. If you don't get any error that a segment can not be extended in PSAPTEMP you don't need to increase.

Regards

Stefan

Former Member
0 Kudos

Hi,

Refresh the statistics of DB02, and check for current sizes, there as well and post the details.

With regards

Sudha

Former Member
0 Kudos

Thanks Sudha for replying:

I tryed to refresh the db02 and it schedules a background job:

Job log overview for job: REFRESH SPACE STATISTIC:DEFAULT / 08532100

Date Time Message text Message class Message no. Message type

12/20/2007 08:53:22 Job started 00 516 S

12/20/2007 08:53:22 Step 001 started (program RSORACOLR, variant &0000000000000, user ID LDING) 00 550 S

12/20/2007 08:53:22 Job finished 00 517 S

But the background job finished successfully, but without collecting statistics

Regards

Senthil