issue with brspace running against EDI40

[Former Member]

I have 6.40 SAP system and I am running BRTools version 6.40 with patch level 40.

Database version is 9.2.0.6 and when I run brspace against EDI40 table to show table info I receive following output:

ethp5000:ad4254 21> g11brspace -f dbshow -c tbinfo -o "sapr3" -t "edi40"

BR1001I BRSPACE 6.40 (40)

BR1002I Start of BRSPACE processing: sdvmyyjb.dbw 2007-06-18 16.50.19

BR0280I BRSPACE time stamp: 2007-06-18 16.50.28

BR1009I Name of database instance: G11

BR1010I BRSPACE action ID: sdvmyyjb

BR1011I BRSPACE function ID: dbw

BR1012I BRSPACE function: dbshow

BR1036I Class of information to be shown: tbinfo

BR0280I BRSPACE time stamp: 2007-06-18 16.50.40

BR0692I Display menu 270 # no input possible

-

---

Information about table SAPR3.EDI40

1 - Partitioned table (partitioned) ..... NO

2 - Number of partitions (partitions) ...

3 - Monitoring attribut (monitoring) .... NO

4 - Parallel degree (degree) ............ 1

5 - Number of indexes (indexes) ......... 1

6 - Tablespace name (tablespace) ........ PSAPCLU2D

7 - Last analyzed (analyzed) ............

8 - Sample size (sample) ................

9 - Number of rows (rows) ............... -1

10 - Allocated space in KB (space) ....... -1

11 - Used space in KB / % (used) ......... -1 / 0.00

12 - Pure data in KB / % (data) .......... -1 / 0.00

13 - Number of chained rows (chained) .... -1

14 - Next extend size in KB (next) ....... 512000

15 - Maximum number of extents (maxexts) . 900

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

I assume it is related to the fact that in DB02 in detail analysis for table edi40 I

see that there is no SAPDBA storage analysis performed:

. . : :00 SAPDBA Storage analysis

Data from DBSTATTORA

No data from SAPDBA Storage analysis availible

How to perform SAPDBA storage analysis and is it something that is recommended to be performed on edi40 table (this is very big table 200GB and it has LONG ROW data type).

[Former Member]

n/a

[Former Member]

Hi Andrija,

Brspace output makes me think the table EDI40 does not have any statistics in the database. You can doublecheck by querying directly on sqlplus:

%sqlplus "/ as sysdba"

%SQL> select last_analyzed from dba_tables where table_name='EDI40';

there should be a null result to that query.

About statistics creation I do recommend you to read SAP notes 588668 and 122718.

Good luck.

Alfonso