Brief Description of SAP Executable

Here is a list of SAP executables that you may find on your SAP systems. If you know of SAP exe files missing in from list, please leave a comment:
R3check                     This is a tool that can check Cluster-Tables for errors.
R3ldctl                        The tool for exporting all table structures to the file system during an OS/DB-Migration.
R3load                        The table import & export tool of SAP during Installation, Upgrade and Migration.
R3szchk                     The tool for determine the sizes of the different tables in the target database during the import in an OS/DB-Migration.
R3ta                             Split large tables for export and import
R3trans                      This is the tool, that does the real work for tp. tp controls the import and export of changes and r3trans does them using scripts, that were generated from tp.
R3trans_164-20000978.SAR     R3trans_164-20000978.SAR’ is a compressed archive with the latest version of R3trans from the SAP Service Marketplace, used when we patched the kernel.
SAPCAR                         SAP Compression and Archiving program
SAPEXEDB_159-20000976.SAR     Compressed file containing DB Dependent executables
SAPEXE_159-20000978.SAR     Compressed file containing the Database Independent executables
cfw                         GUI Control Framework for Abap Objects
cleanipc                     Cleans Inter-Process Communications Memory
db2jcllib.o                 Rsdb/db2jcl_library parameter
db2radm                     Used to configure DB2Connect
dbadaslib.o                 Part of lib_dbsl – database dependent SQL handler
dbdb2pwd                     Create an encrypted DB2 Password File
dbdb2slib.o                 Part of lib_dbsl – database dependent SQL handler – DB2
dbsdbslib.o                 Part of lib_dbsl – database dependent SQL handler
dev_sapstart                 Log file for starting sap
dipgntab                     Activation and adjustment of the nametabs with the ABAP Dictionary.
disp+work                     Dispatcher & Workprocess – “The complete Kernel” – Here the complete ABAP is processed …
Dpj2ee                         Dispatcher for Java
dpmon                         Used to get the process overview of an instance in text mode.
dsrlib.o                     Distributed Statistics Records
Dw_gui.o                     Dependent module for Disp+work
Dw_mdm.o                     Dependent module for Disp+work
Dw_stl.o                     Dependent module for Disp+work
Dw_xml.o                     Dependent module for Disp+work
Dw_xtc.o                     Dependent module for Disp+work
Eg2mon                         Monitor program for Extended Global Memory Segments (only for support)
Em2mon                         Monitor program for Extended Memory management (only for support)
emmon                         Test program for Extended Memory
enqt                         Check and Monitor the Enqueue Lock Table
enrepserver                 SAP Enqueue Replication Server
enserver                     SAP Enqueue Server
ensmon                         Enqueue Server Monitor Programs to monitor the enqueue server and the enqueue replication servers.
Es2mon                         Programs to monitor the enqueue server and the enqueue replication servers.
esmon                         Program to monitor the enqueue server and the enqueue replication servers.
estst                         Test program for the Extended Memory Segments (only for support)
evtd                         This program is able to trigger events within the SAP system. The tp tool uses this feature. It can be used as trigger for self-written interfaces as well.
exe_db2.lst                 The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
gateway.lst                 The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
gw.properties                 Gateway processes
gwmon                         Program gwmon (at operating system level) or SAP transaction SMGW monitors the SAP Gateway.
gwrd                         Program gwmon (at operating system level) or SAP transaction SMGW monitors the SAP Gateway.
icm.properties                 Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
icmadmin.SAR                 Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
icman                         Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
icmbnd                         Program to bind ports with numbers from 0 to 1023
icmon                         Internet Communication Manager (ICM) used for HTTP(S), SMTP based communication used to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
instance.lst                 List of database-independent executables. These executables are valid for all database systems used by the SAP system.
instancedb.lst                 List of database-dependent executables. These executables can only be used with a particular database system.
ipclimits                     Reports IPC memory available to SAP at the OS level
j2eeinst.lst                 The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
jcmon                         Program to monitor and manage Java processes
jcontrol                     Program to control Java processes
jenqulib.jar                 Java Enqueue Library
jlaunch                     Program starts the Java processes
jlogunzip.jar                 Java Classes used to unzip archives (used from the sapstartsrv)
jperflib.jar                 J2EE client Jar file
jstartup.jar                 Java Startup Frame Work jar file
jstartupapi.jar             J2EE Engine Monitoring API
jstartupimpl.jar             J2EE Monitoring
ldap_rfc                     LDAP Connector
ldappasswd                     Store LDAP directory user and password
ldapreg                     LDAP Registration Service
lgtst                         Program to test the message server
libicudata30.a                 ICU Common Library – Part of the RFC SDK and are used for RFC connections.
libicui18n30.a                 ICU Common Library – Part of the RFC SDK and are used for RFC connections.
libicuuc30.a                 ICU Common Library – Part of the RFC SDK and are used for RFC connections.
libjenqulib.o                 Part of the RFC SDK and are used for RFC connections.
libjmon.so                     JMON Shared Library – Part of the RFC SDK and are used for RFC connections.
libjperflib.so                 Part of the RFC SDK and are used for RFC connections.
libregex.o                     Part of the RFC SDK and are used for RFC connections.
librfcum.o                     Dynamic Load Library – Part of the RFC SDK and are used for RFC connections.
libsapcsa.o                 CSA Shared Library – Part of the RFC SDK and are used for RFC connections.
libsapsecu.o                 SECU Shared Library – SAP seculib library used for default encryption. It’s referenced in the j2ee startup logs in the work directory.
libsapu16.so                 Part of the RFC SDK and are used for RFC connections.
libsapu16_mt.so             Part of the RFC SDK and are used for RFC connections.
mdxsvr                         MDX Parser for RFC
memlimits                     The program memlimits lets you determine how much swap space is currently available in the host system.
msclients                     Shows running instances registered in the Message Server
msg_server                     Main Message Server executable
msmon                         Message Server Monitor Utility
msprot                         Monitor Message Server at the OS level
niping                         Program to test the SAP network layer and the SAProuter
rfcexec                     The tool to start other programs from within SAP (ABAP) on the OS level via the gateway on any other (or the same) server.
rfcexec.sec                 The tool to start other programs from within SAP (ABAP) on the OS level via the gateway on any other (or the same) server.
rfcping                     Ping the RFC layer
rscparulib.o                 Dynamic shared library with code page converter
rscpf2f                     Check installed locales for given list of languages.  (Created for installation tools. Possibly unused.)
rscpf3f                     Find possible system code pages for given list of languages.                (Created for installation tools. Possibly unused.)
rscpf_ars                     Test program for code page conversion, language handling and locales in combination with ‘rscparulib.o’.  (only for support)
rscpf_db                     Test program for code page conversion, language handling and locales. This program will connect to database and  also attached to shared memory of an instance if possible.  (only for support)
rslgcoll                     Central System Logging Collector
rslglscs                     Show the Syslog specific parts of the shared memory  segment ‘SCSA’. (mainly for support)
rslgsend                     Central System Logging Sender
rslgview                     View SAP Log at the OS level
rstrcscs                     Program creates a common memory segment for the SCSA, locates the trace switches block within it and initializes the trace switches block.
rstrfile                     R/3 system trace file tool
rstrlscs                     The command “rstrcscs r” removes that common memory segment again.
rstrsscs                     The command “rstrsscs” allows change to the switch settings in the trace switches block within the SCSA.
rsyn.bin                     For each kernel version of the R/3 System, there exists an appropriate file rsyn.bin which contains the ABAP/4 syntax description.  It describes what to do when compiling an ABAP statement
sapccm4x                     CCMS Agent for Abap
sapccmsr                     CCMS Agent for Java
sapcontrol                     ’sapcontrol’ is used to stop/start/monitor the sap instances (for example, from the sapmc).
sapcpe                         This checks that the local executables are up to date each time an SAP instance that uses local executables is started.
sapcpeft                     Parameter file used by sapcpe
sapcpp46.o                     Virus Scan Adapter files (Note 964305)
sapdbmrfc                     RFC for SAPDB connections
sapevt                         This program is able to trigger events within the SAP system. The tp tool uses this feature. It can be used as trigger for self-written interfaces as well.
sapexec                     Call SAP Function Modules
sapftp                         FTP Client, that can be used from within the SAP system (from ABAP) to communicate with other FTP servers.
saphttp                     HTTP Client, that can be used from within the SAP system (from ABAP) to communicate with other HTTP servers – e.g. for interfaces.
sapiconv                     Program for the conversion of text files
sapkprotp                     Relocate a Content Server Repository
saplicense                     The Tool for the installation of a new SAP License. This is needed when the license expires e.g. because of a hardware change.
sapmanifest.mf                 Text file that contains the kernel patch level and is read by the JSPM (Java Support Package Manager).
sapmanifestdb.mf             Text file that contains the database kernel patch level and is read by the JSPM (Java Support Package Manager).
sapmscsa                     SCSA Administration
saposcol                     The SAP Interface to the Operating System for Performance Data. The Operating System Collector collects CPU Usage, Disk Performance, Paging etc.
sapparar                     Reads the SAP Profile
sappfpar                     This tool can be used for checking the profiles after changes and before restarting the SAP system.
saproot.sh                     Script to set Root permissions necessary for some kernel programs
saprouter                     The program for the Router Connection from customers to SAP and vice versa.
sapsecin                     Generation of the PSE (Personal Security Environment)
sapstart                     Starts SAP processes
sapstartsrv                 Starts SAP processes
sapuxuserchk                 The program xuser is a tool from maxdb which stores the logon information to the DB.  This utility program called by sapcontrol which is a program that uses the web service APIs of the ABAP and Java startup framework to control an instance from the command line.
sapwebdisp                     The SAP Web dispatcher is used for load balancing for a setting up an SAP Internet scenario. It is the only application that needs to be located in the DMZ. Everything “behind” this can (and should) be located in your intranet. So, only one port on one IP address needs to be opened to internet and the SAP Web dispatcher can handle the traffic with the different SAP instances.
sapxpg                         Program that starts programs on an external host. The tool for starting OS commands from within SAP Systems.
scs.lst                     The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
scsclient.lst                 The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
semd                         A Test Tool used to verify semaphore operations.
servicehttp                 The port number where the server should listen for HTTP requests.
shmd                         Related to Shared Memory
showipc                     Checks shared memory segments
sldreg                         SLD registration program
sldreglib.o                 SLD registration program
ssfrfc                         Secure Store and Forward (SSF)
startdb                     Program to start the database
startj2eedb                 Program to start the database (Java)
startrfc                     The tool is a very easy SAP command line interface to start all of the implemented function modules of SAP systems.
startsap                     Program to start SAP
stopdb                         Program to stop the database
stopj2eedb                     Program to stop the database (Java)
stopsap                     Program to stop SAP
tp                             The Transport Tool. This program coordinates the complete import and export of program and table changes made within the SAP system in order to transport them through the complete System Landscape.
vscan_rfc                     Virus Scan Adapter files (Note 964305)
wdispadmin.SAR                 Web Dispatcher Administration Interface archive program
wdispmon                     Web Dispatcher Monitor program
webdispinst.lst             Web Dispatcher Administration Interface list
xml63d.o                     Virus Scan Adapter files (Note 964305)

How to Solve Oracle Error ora-1114 in SAP Instance using brtools

Steps would be like
1. Log into each of the SAP DB Servers thru Telnet
2. login as ora
3. goto all the /oracle/SID/sapdata? FS
4. Check whether these FS have Temp Data files created in these Directory
5. check the Free Space left in the FS using the command
5.1 $ cd /oracle/SID/sapdata??
5.2 $ bdf . in Unix
5.3 $ df -k . in Unix & linux

6. Check the Size allocated to the Temp files
6.1 $ ls -lt ./temp_?/* replace ? with the actual number.

the value will be in bytes and not in KiloBytes. so divide this value (8589934592) by 1024 to convert the value into Kilobytes.

7. Check the space currently used by the Temp Files.
7.1 $ du -sk ./temp_2/*


8. So the temp data file can maximum grow, as in this example, to the size 3,817,552+324,960 KB
but the datafile created is sized (8589934592 / 1024) KB = 8,388,608 KB

9. if the Temp Data file size in the FS is more than free space left.
i.e.
if 8,388,608 KB > (3,817,552 + 324,960 - 317,440) KB
then resize the Temp date File to 3,817,552 + 324,960 - 317,440
where the 3,817,552 is the current used by the Temp File
324,960 is the free space left in the mount point
317,440 Min Free space required in the Mount Point for OS.

so resize the the Temp file to 3735 MB (3825072 KB / 1024 => 3735 MB)

10. Check whether the Temp Table Space is being used or not
$brtools
2 - Space management ->
7 - Additional space functions ->
1 = Show tablespaces ->
5 ~ Database tabelspace (tablespace) . [PSAPTEMP]
press "c - cont" -> "c - cont"
The space in the Temp table Space must not have been used.

11. Resizing the Data File, please use brtools
$brtools
-> 2 - Space management
-> 5 - Alter data file
-> 3 ~ Alter data file action (action) . [resize]
-> 4 ~ Tablespace names (tablespace) ... [PSAPTEMP]
-> 5 ~ Data file names (file) .......... [/oracle/AEM/sapdata10/temp_2/temp.data2]
press "c - cont" -> "c - cont"
-> 7 ? New data file size in MB (size) ......... [3735]
press "c - cont" -> "c - cont"

to confirm the corrections, do the same checkes which are listed in steps from 5-9

12. Add a new Temporary Data File in a separate file system of a reasonable Size.

How to install BRTools Studio

A NEW TOOL From SAP………….ADD Multiple Instances to your BR*TOOL studio and enjoy freedom of Administration for Multiple Instances with your favourite WEB browser..

Download Br *TOOL studio from SDN(sdn.sap.com)
Link Given Below
DOWNLOAD

Now Come to your Server

Create a Studio home in any Drive With This Directory Structure

:\Oracle\sap\brtools\studio


EXTRACT the SAPCAR -xvf BRSTUDIO710EN__XXX.SAR into this directory


1) Call setup.cmd from command prompt
2) Click Install
3) Give https port By Default its 8888
4) Provide Password
5) Now keystore File (This is for security as we are using HTTPS)
We need to generate it using JAVA commands
Open Command Prompt Change Directory to java home
Run This Command and provide info:
Keytool -genkey
Give this path to next screen and password also you provide just now
Now a file has been generated
C:\document and setting\username\.keystore
6) Now installation is over.

Export/Import Table using BRTOOLS

Case : I want to reorganize table and rebuild index offline for table SOFFCONT1. Table SOFFCONT1 contains SAP Business Workplace/SAPoffice objects which often grow rapidly in Netweaver based component.

Procedure : Here’s the procedure to export/import tables and rebuild index using BRTOOLS,

1. Export table SOFFCONT1
2. Drop index
3. Import table SOFFCONT1
4. Run Update Statistics Optimizer

Details steps :

1. Export table SOFFCONT1

>brspace -f  tbexport  -t soffcont1

BR0280I BRSPACE time stamp: 2009-06-06 21.10.00

BR1009I Name of database instance: R3X

BR1010I BRSPACE action ID: seasymoz

BR1011I BRSPACE function ID: tbe

BR1012I BRSPACE function: tbexport

BR0280I BRSPACE time stamp: 2009-06-06 21.10.07

BR0657I Input menu 359 - please enter/check input values

Main options for export of tables: SAPR3X.SOFFCONT1

1 * Export utility (utility) ............... [EXP]

2 * Tablespaces for export (tablespaces) ... []

3 * Owner for export (owner) ............... []

4 - Export table rows (rows) ............... [yes]

5 - Export table indexes (indexes) ......... [yes]

6 - Export table constraints (constraints) . [yes]

7 - Export table grants (grants) ........... [yes]

8 - Export table triggers (triggers) ....... [yes]

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-06 21.12.18

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-06 21.12.18

BR0657I Input menu 360 - please enter/check input values

Additional options for export of tables: SAPR3X.SOFFCONT1

1 - Use direct path (direct) ................ [yes]

2 - Export buffer size in KB (buffer) ....... [10240]

3 - Compress table extents/data (compress) .. [no]

4 - Consistent export (consistent) .......... [no]

5 # Parallel degree (parallel) .............. [1]

6 - Max. size of dump file in MB (filesize) . [20000]

7 - Force table export (force) .............. [no]

8 - EXP/EXPDP command (command) ............. [E:\oracle\R3X\102\BIN\exp parfile=I:\Oracle\R3X\sapreorg\seasymoz\parfile.exp]

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-06 21.13.15

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-06 21.13.16

BR0370I Directory I:\Oracle\R3X\sapreorg\seasymoz created

BR0280I BRSPACE time stamp: 2009-06-06 21.13.16

BR0370I Directory I:\Oracle\R3X\sapreorg\seasymoz.edd created

BR1164I Export of tables will be started with command line: E:\oracle\R3X\102\BIN\exp parfile=I:\Oracle\R3X\sapreorg\seasymoz\parfile.exp

BR0280I BRSPACE time stamp: 2009-06-06 21.13.16

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2009-06-06 21.13.47

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0278I Command output of 'E:\oracle\R3X\102\BIN\exp parfile=I:\Oracle\R3X\sapreorg\seasymoz\parfile.exp':

Export: Release 10.2.0.2.0 - Production on Sat Jun 6 21:13:47 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Export done in WE8DEC character set and UTF8 NCHAR character set

About to export specified tables via Direct Path ...

Current user changed to SAPR3X

. . exporting table                      SOFFCONT1

continuing export into file I:\Oracle\R3X\sapreorg\seasymoz.edd\expdat1.dmp

962456 rows exported

Export terminated successfully without warnings.

BR0280I BRSPACE time stamp: 2009-06-06 22.44.59

BR1160I 1 table exported by EXP utility

BR0280I BRSPACE time stamp: 2009-06-06 22.45.02

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2009-06-06 22.55.09

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-06 22.55.10

BR1022I Number of tables processed: 1

BR1003I BRSPACE function 'tbexport' completed

BR1008I End of BRSPACE processing: seasymoz.tbe 2009-06-06 22.55.10

BR0280I BRSPACE time stamp: 2009-06-06 22.55.12

BR1005I BRSPACE completed successfully

2. Drop index

>sqlplus “/as sysdba”

SQL>drop index “SAPR3X”.”SOFFCONT1~0″;

Index dropped

3. Import table SOFFCONT1

>brspace -f tbimport -t soffcont1

BR0280I BRSPACE time stamp: 2009-06-06 23.00.00

BR1009I Name of database instance: R3X

BR1010I BRSPACE action ID: seasywiu

BR1011I BRSPACE function ID: tbi

BR1012I BRSPACE function: tbimport

BR0280I BRSPACE time stamp: 2009-06-06 23.00.00

BR0656I Choice menu 361 - please make a selection

Import tables main menu

1 = Import tables

2 - Show BRSPACE export runs

3 * Exit program

4 - Reset program status

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-06 23.00.14

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0699I Reading log file I:\Oracle\R3X\sapreorg\spaceR3X.log ...

BR0280I BRSPACE time stamp: 2009-06-06 23.00.15

BR0658I List menu 362 - please select one entry

List of BRSPACE exports for import

Pos.  Run           Date                   Tables  Dumps       Size[KB]  Util.

1 = seasymoz.tbe  2009-06-06 21.09.57        1      2       25519234   EXP

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

BR0662I Enter your selection:

BR0280I BRSPACE time stamp: 2009-06-06 23.01.22

BR0663I Your selection: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-06 23.01.22

BR0657I Input menu 363 - please enter/check input values

Main options for import from dump file I:\Oracle\R3X\sapreorg\seasymoz.edd\expd at.dmp,... (2 dumps)

1 * Import utility (utility) ............... [IMP]

2 - Import type (type) ..................... [full]

3 # Owner for import (owner) ............... []

4 # Tables for import (tables) ............. [SOFFCONT1]

5 - Import table rows (rows) ............... [yes]

6 - Import table indexes (indexes) ......... [yes]

7 - Import table constraints (constraints) . [yes]

8 - Import table grants (grants) ........... [yes]

9 # Import table triggers (triggers) ....... [yes]

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-06 23.02.42

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-06 23.02.42

BR0657I Input menu 364 - please enter/check input values

Additional options for import from dump file I:\Oracle\R3X\sapreorg\seasymoz.ed d\expdat.dmp,... (2 dumps)

1 - Import buffer size in KB (buffer) ....... [10240]

2 - Commit after each array insert (commit) . [yes]

3 - Ignore creation errors (ignore) ......... [yes]

4 # Table exists action (action) ............ [skip]

5 # Parallel degree (parallel) .............. [1]

6 # Max. size of dump file in MB (filesize) . [20000]

7 - Force table import (force) .............. [no]

8 - IMP/IMPDP command (command) ............. [E:\oracle\R3X\102\BIN\imp parfile=I:\Oracle\R3X\sapreorg\seasywiu\parfile.imp]

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-06 23.03.06

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-06 23.03.07

BR0370I Directory I:\Oracle\R3X\sapreorg\seasywiu created

BR1172I Import of tables will be started with command line: E:\oracle\R3X\102\BIN\imp parfile=I:\Oracle\R3X\sapreorg\seasywiu\parfile.imp

BR0280I BRSPACE time stamp: 2009-06-06 23.03.07

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2009-06-06 23.03.34

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0278I Command output of 'E:\oracle\R3X\102\BIN\imp parfile=I:\Oracle\R3X\sapreorg\seasywiu\parfile.imp':

Import: Release 10.2.0.2.0 - Production on Sat Jun 6 23:03:35 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via direct path

import done in WE8DEC character set and UTF8 NCHAR character set

. importing SYS's objects into SYS

. importing SAPR3X's objects into SAPR3X

. . importing table                    "SOFFCONT1"     962456 rows imported

Import terminated successfully without warnings.

BR0280I BRSPACE time stamp: 2009-06-07 00.43.12

BR1166I 1 table imported by IMP utility

BR0280I BRSPACE time stamp: 2009-06-07 00.43.14

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:

BR0280I BRSPACE time stamp: 2009-06-07 00.46.19

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-07 00.46.19

BR0656I Choice menu 361 - please make a selection

Import tables main menu

1 * Import tables

2 - Show BRSPACE export runs

3 = Exit program

4 - Reset program status

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-07 00.46.25

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-07 00.46.25

BR0680I Do you really want to exit BRSPACE? Enter y[es]/n[o]:

BR0280I BRSPACE time stamp: 2009-06-07 00.46.33

BR0257I Your reply: 'y'

BR0280I BRSPACE time stamp: 2009-06-07 00.46.33

BR1022I Number of tables processed: 1

BR1003I BRSPACE function 'tbimport' completed

BR1008I End of BRSPACE processing: seasywiu.tbi 2009-06-07 00.46.33

BR0280I BRSPACE time stamp: 2009-06-07 00.46.34

BR1005I BRSPACE completed successfully

4. Run Update Statistic Optimizer in SAP

Execute or Schedule this via DB13 then it will create a new index for table SOFFCONT1.

Note: Tables SOFFCONT1 need to be reorganized offline as they contain LONG RAW fields and must not be converted to LOBS with the online reorganization.

How to check BRTOOLS version

Some SAP Basis newbies ask me about how to know which version they are using right now. Although I am not SAP Basis expert, I'll try to get information to you.
You can follow this step :

Enter your SAP system on OS. You can use root (for UNIX/Linux) and Administrator (on Windows system). I am going to guide you on UNIX/Linux only system.

Switch you user to ora[sid] user :

#su - oraids
>

Type this command :

>brtools -V

You'll see something like this :

host:oraids 1> brtools -V
BR0651I BRTOOLS 6.40 (40)

Patch Date Info

36 2006-01-11 Small functional enhancements in BR*Tools (note 914174)
38 2006-03-29 BR*Tools support for MDM databases (note 936665)
40 2006-08-30 Wrong message numbers in BR*Tools 6.40 (note 976755)

release note 680046
kernel release 640
patch date 2006-08-30
patch level 40
make platform hpia64
make mode OCI_920
make date Sep 5 2006

host:oraids 2>

As you can see that I am using BRTOOLS version 6.40 and have patch level 40. I am using HP-UX on Itanium platform 64 bit. Now, check your own BRTOOLS version.
x