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 |
/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