BRSPACE Structure Change Log

Definition

The structure change log contains a history of all database structure changes that you perform with BRSPACE. Structure changes consist of the following functions:

·        Extend tablespace

·        Create tablespace

·        Drop tablespace

·        Alter datafile (changes to file size attributes)

·        Rename tablespace

·        Move datafile

Use

The file helps you to keep track of database structure changes.

Structure

The file is called struc<DBSID>.logand is located in the $SAPDATA_HOME/sapreorg directory.

The first line is standard but the following lines vary according to the function.

·        Standard first line

Line

Entry

Example

#BRSRUN

Timestamp (date, time) for when you start BRSPACE for the structure change

2003-08-01 14.47.18

BRSPACE action id (encoded timespace)

sdlfavte

BRSPACE function ID

tse

Function name

tsextend

Effective and real user name

user=oragc2/oragc2

The combination of action id and function id – in the above example, sdlfavte.tse – represents the name of the BRSPACE detail log.

·        Extend tablespace

Line

Entry

Example

#TSPEXT

Timestamp (date, time) for when the structure change finished

2003-08-01 14.47.27

Tablespace name

PSAP2222

#FILEADD

New datafile name

/oracle/GC2/sapdata4/2222_6/2222.data6

Parameters for new datafile

size=1M  autoext=yes  maxsize=10M incrsize=1M 

·        Create tablespace

Line

Entry

Example

#TSPCRT

Timestamp (date, time) for when the structure change finished

2003-08-01 14.50.35

Tablespace name

PSAP3333D

Parameters for new tablespace

conts=data  assm=auto  data=table

#FILEADD

New datafile name

/oracle/GC2/sapdata4/3333d/3333d.data1 

Parameters for new datafile

size=1M  autoext=yes  maxsize=10M incrsize=1M 

·        Drop tablespace

#TSPDROP

Timestamp (date, time) for when the structure change finished

2003-08-01 14.52.41

Tablespace name

PSAP4444I

Attributes of deleted tablespace

files=2  size=2M

#FILEDEL

Deleted datafile name

/oracle/GC2/sapdata4/4444i_1/4444i.data1 

Datafile parameters

size=1M

·        Rename tablespace

#TSPREN

Timestamp (date, time) for when the structure change finished

2003-08-01 14.52.41

Old tablespace name

PSAP4444I

New tablespace name

newname=PSAP5555I

·        Alter datafile

Ў        Switch on autoextend

#FILEAUTO

Datafile name

/oracle/GC2/sapdata4/2222_1/2222.data1

Datafile parameters

size=1M  autoext=yes  maxsize=22M incrsize=2M 

Ў        Switch off autoextend

#FILEFIX

Datafile name

/oracle/GC2/sapdata1/testd_5/ttttd.data5

Parameters to specify the affected datafile

size=2M  autoext=no

Ў        Resize datafile

#FILESIZE

Datafile name

/oracle/GC2/sapdata6/testd_1/testd.data1 

Parameters for new and old size of datafile

size=8M  oldsize=4M

·        Move datafile

#TSP

Timestamp (date, time) for the move

2003-08-01 17.55.14 

Tablespace

PSAP1111D

#FILEMOVE

New datafile name

/oracle/GC2/sapdata5/1111d_2/1111d.data2 

 

Old datafile name

oldfile=/oracle/GC2/sapdata2/1111d_3/1111d.data3 

Datafile size

size=3M

Example

This is an example of part of a structure change log showing each of the functions described above:

#BRSRUN... 2003-08-01 14.47.18 sdlfavte tse func=tsextend user=oragc2/oragc2

#TSPEXT... 2003-08-01 14.47.27  PSAP2222

#FILEADD.. /oracle/GC2/sapdata4/2222_6/2222.data6  size=1M  autoext=yes  maxsize=10M incrsize=1M 

#

#BRSRUN... 2003-08-01 14.48.31  sdlfavvz tsc  func=tscreate  user=oragc2/oragc2

#TSPCRT... 2003-08-01 14.50.35  PSAP3333D  conts=data  assm=auto  data=table

#FILEADD.. /oracle/GC2/sapdata4/3333d_1/3333d.data1  size=1M  autoext=yes  maxsize=10M incrsize=1M 

#

#BRSRUN... 2003-08-01 14.52.29  sdlfawfd tsd  func=tsdrop  user=oragc2/oragc2

#TSPDROP.. 2003-08-01 14.52.41  PSAP4444I  files=2  size=2M

#FILEDEL.. /oracle/GC2/sapdata4/4444i_1/4444i.data1  size=1M

#FILEDEL.. /oracle/GC2/sapdata4/4444i_2/4444i.data2  size=1M

#

#BRSRUN... 2003-08-01 16.37.36  sdlfbfns dfa  func=dfalter  user=oragc2/oragc2

#FILEAUTO. /oracle/GC2/sapdata4/2222_1/2222.data1  size=2M  autoext=yes  maxsize=22M incrsize=2M 

#FILEAUTO. /oracle/GC2/sapdata4/2222_2/2222.data2  size=1M  autoext=yes  maxsize=22M incrsize=2M 

#

#BRSRUN... 2003-08-01 16.48.18  sdlfbgmk dfa  func=dfalter  user=oragc2/oragc2

#FILEFIX.. /oracle/GC2/sapdata1/testd_5/ttttd.data5  size=2M  autoext=no

#FILEFIX.. /oracle/GC2/sapdata3/ttttd_1/ttttd.data1  size=4M  autoext=no

#

#BRSRUN... 2003-08-01 21.06.20  sdlfcdjw dfa  func=dfalter  user=oragc2/oragc2

#TSP...... 2003-08-01 21.06.49  PSAPTESTD

#FILESIZE. /oracle/GC2/sapdata6/testd_1/testd.data1  size=8M  oldsize=4M

#FILESIZE. /oracle/GC2/sapdata6/testd_2/testd.data2  size=8M  oldsize=4M

#

#BRSRUN... 2003-08-01 17.54.03  sdlfbmid dfm  func=dfmove  user=oragc2/oragc2

#TSP...... 2003-08-01 17.55.14  PSAP1111D

#FILEMOVE. /oracle/GC2/sapdata5/1111d_2/1111d.data2  oldfile=/oracle/GC2/sapdata2/1111d_2/1111d.data2  size=3M

#FILEMOVE. /oracle/GC2/sapdata5/1111d_3/1111d.data3  oldfile=/oracle/GC2/sapdata2/1111d_3/1111d.data3  size=3M