Show TOC

Object documentationBRSPACE Structure Change Log Locate this document in the navigation structure

 

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 (rename, drop, change file size attributes)

  • Rename tablespace

  • Move datafile

 

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

Structure

The file is called struc<DBSID>.log and 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

    Note Note

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

    End of the note.

  • 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