on 12-20-2007 1:39 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Refresh the statistics of DB02, and check for current sizes, there as well and post the details.
With regards
Sudha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
59 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.