• Creation of a new tablespace, for example as a preparation to move certain tables out of the standard tablespace PSAP into a special tablespace
• Deletion of a tablespace, for example after an upgrade
• Extending tablespaces by adding a data file or tempfile or by resizing existing data files
• Moving data files, for example because after adding a new disk a data file which was created on another disk needs to be moved to the new disk This lesson describes the actions of BRTOOLS or BRGUI under the main menu item Space management.
Creating and Dropping tablespaces
On normal operation creating a new tablespace or dropping an existing tablespace is not necessary.
The creation of a new tablespace is necessary for example
• in preparation for the upgrade: During the upgrade, the old ABAP programs in PSAP are deleted and the new ABAP programs are imported into the new tablespace PSAP.
• in preparation for an online reorganization of a tablespace, for example to switch from a dictionary managed to a locally managed tablespace.
To create a new tablespace use BRTOOLS or BRGUI and select Space management ? Create tablespace. To enter the main menu mode of BRSPACE, select continue in the next screen and select Create tablespace from the BRSPACE menu. As an alternative, you can start brspace -f tscreate and press continue.. Now fill in the necessary information by selecting the appropriate menu items.
Create a tablespace using BR*Tools
BR0657I Input menu 305 - please check/enter input values
-------------------------------------------------------------------------------
Main options for creation of tablespace in database T00
1 - Tablespace name (tablespace) ......... [PSAPT00NEW]
2 - Tablespace contents (contents) ....... [data]
3 - Segment space management (space) ..... [auto]
4 # Database owner of tablespace (owner) . []
5 ~ Table data class / tabart (class) .... []
6 - Data type in tablespace (data) ....... [both]
7 # Joined index/table tablespace (join) . []
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
The main options and their possible entries are:
tablespace
Enter the name of the tablespace to be created. According to the SAP conventions, the tablespace name should start with the letters "PSAP", followed by the SCHEMA-ID, plus a unique name.
contents
• data for normal tablespaces containing tables and/or indexes
• temp for a temporary tablespace
• undo for an undo tablespace
space
You can select either auto for automatic segment space management (default) or manual for manual segment space management.
owner
Changing this is only possible if you have multiple components in one database. The owner is SAP of the database schema you create the tablespace for.
data
In the "old" tablespace layout a tablespace contained either tables (table) or indexes (index). In the new MCOD tablespace layout, tablespaces contain tables and indexes (both). SAP recommends generally to create new tablespaces containing data and indexes to simplify administration.
join
If in the data field you entered either table or index, you can enter here the corresponding index or table tablespace. In the first case, BRSPACE will create both tablespaces. In the second case, BRSPACE creates only a index tablespace on joins it with already existing table tablespace. When you entered both in the data field, this option is not selectable.
After continuing, the menu for the data file properties is shown. The screenshot shows the output after changing autoextent to yes.
Options for creation of a tablespace
BR0657I Input menu 306 - please check/enter input values
--------------------------------------------------------------------
Space options for creation of tablespace PSAPT00TST (1. file)
1 - Tablespace file name (file) .......... [G:\oracle\T00\sapdata3\0tst.data1]
2 # Raw disk / link target (rawlink) ..... []
3 - File size in MB (size) ............... [2]
4 - File autoextend mode (autoextend) .... [yes]
5 - Maximum file size in MB (maxsize) .... [10]
6 - File increment size in MB (incrsize) . [2]
7 - SQL command (command) ................ [create tablespace PSAPT t management local autoallocate segment space management auto datafi le\T00\sapdata3\t00tst_1\t00tst.data1" size 2M autoextend on next 2M M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
--------------------------------------------------------------------
BR0662I Enter your choice:
The main options and their possible entries are:
file
The name of the new data file for the tablespace. The default path and file name follows the SAP naming conventions for data files. You can create a tablespace with up to five data files using BRSPACE.
size
Size of the data file in MB.
autoextend
If set to yes, the new data file is created autoextensible. In this case, maxsize and incrsizemust be specified. If set to no, maxsize and incrsizecannot be specified and their entries are locked.
maxsize
For autoextensible data files, this parameter specifies the maximum size in MB up to which the data file can be increased.
incrsize
For autoextensible data files, this parameter specifies the size in MB, by which the data file is automatically increased when necessary.
Now the tablespace will be created. Because creating a tablespace is a structural change in the database, a control file backup is created in the directory $SAPDATA_HOME/sapreorg/ before and after the creation. In addition the action will be reported in $SAPDATA_HOME/sapreorg/struc .log.
To drop a tablespace use BRTOOLS or BRGUI and select Space management ? Drop tablespace. To enter the main menu mode of BRSPACE, select continue in the next screen and select Drop tablespace from the BRSPACE menu. As an alternative, you can start brspace -f tsdrop and enter continue.
Now a list of tablespaces is shown, from where you can select the tablespace to be dropped. After selecting the tablespace you can set the force option (default: no). Per default, BRSPACE will not drop a tablespace which is not empty. Using the force option, BRSPACE will drop the tablespace even if it is not empty.
When a tablespace is dropped, BRSPACE will
• create a control file backup in the directory $SAPDATA_HOME/sapreorg/ before and after the deletion
• check if the tablespace is empty. If the tablespace is not empty, it will not be dropped unless you force it by setting the force mode to yes.
• take the tablespace offline
• drop the tablespace including data files
• remove all subdirectories for the data files
• create an entry of the action in struc.log
Enlarging Tablespaces
To make a tablespace larger, there are three possible ways:
• a new data file can be added to the existing tablespace.
Use this option, if the existing data files cannot be resized because there is no disk space available on the disks holding the existing data files, or because the existing data files already have their maximum size and you don't want to make them larger.
• the properties of an existing data file can be changed to be autoextensible. Use this option to simplify further tablespace administration in the future. Any autoextensible data file will grow automatically when needed up to a maximum file size defined.
Caution: When using autoextensible data files, you have to monitor the disk space usage. In this case, a tablespace overflow can still occur if the disks holding these data files are full!
• an existing data file can be resized.
Use this option if you want to keep the control over the data file growth.
To enlarge a tablespace by adding a new data file start BRTOOLS or BRGUI and select Space management? Extend tablespace. To enter the main menu mode of BRSPACE, select continue in the next screen and select Extend tablespace from the BRSPACE menu. As an alternative, you can use brspace -f tsextend and enter continue.
After selecting the tablespace to be extended, a menu similar to the menu when creating a tablespace is shown. Enter the appropriate values as described above when creating a tablespace.
To switch an existing file to be autoextensible start BRTOOLS or BRGUI and select Space management ? Alter data file ? Maintain autoextend. To enter the main menu mode of BRSPACE, select continue in the next screen. As an alternative, you can use brspace -f dfalter and select Maintain autoextend.
Now select the data file from the list. The list only contains all data files because you can change maxsize and incrsize with this function.
In the next screen, the parameters for automatic extension of the data file have to be entered (maxsize,incrsize - see above).
To resize an existing data file start BRTOOLS or BRGUI and select Space management ? Alter data file ? Resize data file. To enter the main menu mode of BRSPACE, select continue in the next screen. As an alternative, you can use brspace -f dfalter and select Resize data file.
Now select the data file from the list. Specifiy the new data file size and continue.
Moving or Renaming Data Files
To move or rename a data file, it is not sufficient to just move or rename the file itself, as Oracle would not know about the new file name or location. After moving or renaming a data file, the new file name has to be entered in the control file with Oracle commands. Using BRSPACE, all necessary actions are performed.
You might want to move an existing data file to another location if
• you want to move data files from a file system to raw devices or from raw devices to a file system (on UNIX)
• you had to extend a tablespace by adding a new data file, but because of lack of disk space in the disks containing sapdata directories, the data file was created on another disk which was not intended to hold data files. After adding another disk you want to move this data file to the new disk.
• you need to replace a disk on Windows (due to different drive letters used).
To move or rename a data file start BRTOOLS or BRGUI and select Space management ? Move data file. To enter the menu mode of BRSPACE, select continue in the next screen. As an alternative, you can use brspace -f dfmove and enter continue. Now select the data file to move from the list of data files.
In the next screen, enter the required information:
destination
enter the full path of the sapdata directory where data file shall be moved to. This directory must already exist. The subdirectory for the data file must not be entered and will be created by BRSPACE.
parallel
when moving more than one data file, you can parallelize the copy process. Enter the number of copy processes here.
force
To move or rename a data file, the database needs to be shut down. BRSPACE will normally only shut down the database, if SAP is not running. You can force BRSPACE to shut down the database even when SAP is connected by setting the force option.
Additional Database Space Management Options
To show database information start BRTOOLS or BRGUI and select Space management ? Additional space functions.
You can view information about tablespace, data files, redo log and control files. Also disk usage information of all directories containing database data can be displayed.
To alter a tablespace start BRTOOLS or BRGUI and select Space management ? Alter tablespace. Now you have the following possibilities:
set tablespaces offline and online
When a tablespace is set offline, it cannot be accessed anymore. For SAP to work correctly, all tablespaces belonging to the corresponding database schema user SAP must be online!
There are situations, when Oracle sets a tablespace offline. This happens for example when Oracle receives an I/O error from the operating system when writing into a data file. To avoid corrupt blocks to be written, Oracle sets this tablespace offline.
Caution: Whenever a tablespace is offline, and it was not actively set offline by an database administrator, you must find the reason for this and solve the problem causing Oracle to set this tablespace offline! After finding and resolving the problem, the tablespace can be set online using this menu.
In databases having multiple components in one database (MCOD), the tablespaces belongs to one schema user SAP could be set offline to perform certain administrative actions without affecting other SAP systems using a different SAP user. But even in this situation, the tablespaces SYSTEM, PSAPROLL/PSAPUNDO and PSAPTEMP must not be set offline, because these tablespaces are used by all schema users.
set or reset the backup status
The backup status is regularly set by BRBACKUP when performing an online backup and reset after the backup. When BRBACKUP crashed during an online backup, one or more tablespaces remain in backup mode. This situation is checked by the database system check, which reports the following warning if a tablespace is in backup mode:BR0970W Database administration alert - level: WARNING, type: TABLESPACE_IN_BACKUP, object: PSAPC11 In this case,
• a normal shutdown would not work
• if the database crashes or a shutdown abort is performed while a tablespace is in backup mode, the database would need a manual recovery in order to be opened.
To avoid a manual recovery, reset the backup status when a tablespace is in backup mode when the following conditions are true:
• Analyzing the situation it turns out that an online backup crashed
• There is currently no online backup running.
Coalesce free extents
Coalescing free extents means that several free extents which directly follow each other are combined to a single, larger free extent. The tool database system check will automatically coalesce free extents for all tablespaces. Manually coalescing free extents using this menu makes sense when a high amount of data was deleted in the database, for example after archiving data or the deletion of a client.
Wednesday, August 11, 2010
Monday, August 9, 2010
OS DB Migration
Pre Export Process In Application level:-
o Check the Java JRE version (Min 1.4.1).
o Check the QCM table entries of SAP.
o Check for cancelled and update task
o Delete table entries from TATGPC, TATGPCA
o Check the incremental table conversion
o Cancel all released jobs
o Check for the operation modes
o Delete unnecessary spool data
o De-schedule all SAP jobs
o Delete all the batch jobs
o Release all repairs and correction and transports
o delete background input logs
o Delete job logs
o Delete the tRFC
o Check for the code pages installed
o Check the DDIC password for 000 client
Pre Export Process In OS level:-
o Deschedule all OS DB backups
o Shutdown all external interface
o The source should have minimum SP3
Pre Export Process In DB level:-
o Update DB statistics
o Change the DB to no archive log mode
Steps to Start the DB export
o Enter the system asadm
o Create to directory in the source system eg, Export, Install
o Check for the PSAPTEMP, the size should be 2 times the largest index
o Start the R3setup.bat program from the kernel CD (use the 45B_EXT kernel cd for the migration as the target system is AIX 5.3, always check the PAM before using the kernel cd.)
o Edit the DBEXPORT.R3S file and skip the update of statistics as it is already done and update statistics of R3SETUP is high time consuming. It can even run for days for a DB size more than 1 TB
o Edit the DBEXPORT.R3S to stop for splitter
o Start the export
o The export stops at the given breakpoint for the splitter
o Split the STR files generated
o Repeat the export process
Import process
o Check the Java version ( Minimum JRE version 1.4.1 )
o Check all necessary drives and filesystems. ( #mkdir /oracle/client/92x_64, # cd /oracle/stage, #mkdir 920_64 )
o Create to directory eg, Install, Import
o From install directory run instool.sh of Ext. kernel cd for AIX.
o set environment.
#csh
#setenv LIBPATH /sapmnt//exe:/oracle//920_64/lib.
o Install the central instances. R3SETUP –f CENTRAL.R3S
o In the next installation process choose “Exit”
o Install Oracle software as per WAS640 guide with ora user.
o After the oracle installation is done repeat the installation of the R3SETUP
o The R3SETUP stops for Migration key check phase
o Create the tablespaces of the required sizes
o Restart the database in no archive log mode
o Start the import process
o Complete the post installation steps from the migration guide of 45 B
Some of the problems faced with the above mentioned source and target system
1. During the export phase after the STR files are created the export stops with an error saying
“Cannot connect to DB”
Solution: Delete the following R3load, R3szchk, R3ldctl from the Instal directory.
2. Use update of DB statistics by sapdba or brtools. Avoid using the update of statistics by the export
Process
Solution: Edit the DBEXPORT.R3S file and delete the lines DBCOMPUTESTAT4MIG_XT*,
DBCOMPUTESTAT4MIG*, BRCONNECTEXPSTAT*
3. Export takes a huge time
Solution: Use the java based package splitter to split the STR files for the export.
4. Export fails complaining the PSAPTEMP size is small.
Solution: Check the size of the PSAPTEMP before export. It should be atleast 2 times the size of the largest index for R/3.
5. During the import process check the aio settings in the OS level.
Solution: We have used the mix server of 512 and max server of 1024 during the import process
6. The import process fails due to lack of space to extend the extent at PSAPROLL
Solution: Try using the PSAPUNDO in place of PSAPROLL
7. The total system downtime could be reduced if MIGMON was used. The firewall rule prevented
from the use of migmon between the source and the target.
Post Installation jobs for BASIS area
1. Replace the disp+work of the kernel.
2. Delete the table entries as mentioned in the Heterogeneous system copy guide of 45B
3. Edit the RFC destination address of other connected system.
4. Change the printer definition of the target. Test all the printers are working or we need to make changes in the settings.
5. Set up the TMS
6. Check for the ALE and IDOCS flow after the new system is up
7. Schedule all the basic BASIS background jobs.
8. Take a full offline backup
Reason for moving to Oracle 9.2.0.7
9.2.0.4 being the first stable release of R/3 had many bugs which are listed in the SAP and Oracle sites were later removed in later subsequent releases.
This oracle will be upgraded to Oracle 10.2.0.2 and for the upgrade the source should be at oracle 9.2.0.7 before it can be upgraded to 10g.
As we go higher up in the in the Optimizer gets improved hence the execution plans are improved and this results is transactions executing faster
Using of the Package splitter
The java based package splitter can be used to split the STR files
• Open new terminal preparation for splitter tool.
• Edit packet_splitter_end.properties file
• Use splitter guide for clarification.
• setenv JAVA_HOME /usr/opt/java141.
• usingadm user, start split process.
o Check the Java JRE version (Min 1.4.1).
o Check the QCM table entries of SAP.
o Check for cancelled and update task
o Delete table entries from TATGPC, TATGPCA
o Check the incremental table conversion
o Cancel all released jobs
o Check for the operation modes
o Delete unnecessary spool data
o De-schedule all SAP jobs
o Delete all the batch jobs
o Release all repairs and correction and transports
o delete background input logs
o Delete job logs
o Delete the tRFC
o Check for the code pages installed
o Check the DDIC password for 000 client
Pre Export Process In OS level:-
o Deschedule all OS DB backups
o Shutdown all external interface
o The source should have minimum SP3
Pre Export Process In DB level:-
o Update DB statistics
o Change the DB to no archive log mode
Steps to Start the DB export
o Enter the system as
o Create to directory in the source system eg, Export, Install
o Check for the PSAPTEMP, the size should be 2 times the largest index
o Start the R3setup.bat program from the kernel CD (use the 45B_EXT kernel cd for the migration as the target system is AIX 5.3, always check the PAM before using the kernel cd.)
o Edit the DBEXPORT.R3S file and skip the update of statistics as it is already done and update statistics of R3SETUP is high time consuming. It can even run for days for a DB size more than 1 TB
o Edit the DBEXPORT.R3S to stop for splitter
o Start the export
o The export stops at the given breakpoint for the splitter
o Split the STR files generated
o Repeat the export process
Import process
o Check the Java version ( Minimum JRE version 1.4.1 )
o Check all necessary drives and filesystems. ( #mkdir /oracle/client/92x_64, # cd /oracle/stage, #mkdir 920_64 )
o Create to directory eg, Install, Import
o From install directory run instool.sh of Ext. kernel cd for AIX.
o set environment.
#csh
#setenv LIBPATH /sapmnt/
o Install the central instances. R3SETUP –f CENTRAL.R3S
o In the next installation process choose “Exit”
o Install Oracle software as per WAS640 guide with ora
o After the oracle installation is done repeat the installation of the R3SETUP
o The R3SETUP stops for Migration key check phase
o Create the tablespaces of the required sizes
o Restart the database in no archive log mode
o Start the import process
o Complete the post installation steps from the migration guide of 45 B
Some of the problems faced with the above mentioned source and target system
1. During the export phase after the STR files are created the export stops with an error saying
“Cannot connect to DB”
Solution: Delete the following R3load, R3szchk, R3ldctl from the Instal directory.
2. Use update of DB statistics by sapdba or brtools. Avoid using the update of statistics by the export
Process
Solution: Edit the DBEXPORT.R3S file and delete the lines DBCOMPUTESTAT4MIG_XT*,
DBCOMPUTESTAT4MIG*, BRCONNECTEXPSTAT*
3. Export takes a huge time
Solution: Use the java based package splitter to split the STR files for the export.
4. Export fails complaining the PSAPTEMP size is small.
Solution: Check the size of the PSAPTEMP before export. It should be atleast 2 times the size of the largest index for R/3.
5. During the import process check the aio settings in the OS level.
Solution: We have used the mix server of 512 and max server of 1024 during the import process
6. The import process fails due to lack of space to extend the extent at PSAPROLL
Solution: Try using the PSAPUNDO in place of PSAPROLL
7. The total system downtime could be reduced if MIGMON was used. The firewall rule prevented
from the use of migmon between the source and the target.
Post Installation jobs for BASIS area
1. Replace the disp+work of the kernel.
2. Delete the table entries as mentioned in the Heterogeneous system copy guide of 45B
3. Edit the RFC destination address of other connected system.
4. Change the printer definition of the target. Test all the printers are working or we need to make changes in the settings.
5. Set up the TMS
6. Check for the ALE and IDOCS flow after the new system is up
7. Schedule all the basic BASIS background jobs.
8. Take a full offline backup
Reason for moving to Oracle 9.2.0.7
9.2.0.4 being the first stable release of R/3 had many bugs which are listed in the SAP and Oracle sites were later removed in later subsequent releases.
This oracle will be upgraded to Oracle 10.2.0.2 and for the upgrade the source should be at oracle 9.2.0.7 before it can be upgraded to 10g.
As we go higher up in the in the Optimizer gets improved hence the execution plans are improved and this results is transactions executing faster
Using of the Package splitter
The java based package splitter can be used to split the STR files
• Open new terminal preparation for splitter tool.
• Edit packet_splitter_end.properties file
• Use splitter guide for clarification.
• setenv JAVA_HOME /usr/opt/java141.
• using
Monday, July 26, 2010
NetWeaver Installation Part I
1. How to make sap autostart with the OS restart after the Upgrade?
A. /usr/sap/sapservices - after the upgrade execute cd $DIR_PUT/bin/ execute ./installsapinit.sh
A. 3901 and 3902 hence 01 and 02 should NOT be used for SAP instance numbers.
3. Can I install SAP on NFS mounted filesystems under AIX?
A. No, there might be problems when JVM is started.
4. What is heterogeneous installation of SAP?
A. Installing an SAP system with instances running on different operating systems.
We need to download NW07_01_REL.zip from the marketplace and extract it to the installation directory to update the control.xml. Since, this avoids "sapcontrol not found dir DIR_EXECUTABLE and DIR_CT_RUN" error.
5. Why do we disable VM Container in PI systems?
A. To reduce memory consumption. Long GC runtimes in the AS JAVA of the NetWeaver PI cause shutdown of the server nodes.
6. Why do we set ulimits (soft limits) before the installation?
A. SAP Note: 323816
7. After the PI 7.11 installation PISUPER is lack of which role?
A. SAP_NWA_FULL. Manually assign it.
8. What is an SMD agent?
A. This is a standalone Java program that runs on each of the systems managed by SAP solution manager diagnostics. The installation of the diagnostics agent is a part of the Installation Master DVD. This gets installed automatically with the Primary Application server and Additional application server. Or we do have an option to installation separately for non-SAP systems. http://service.sap.com/diagnostics
9. What is a SAP Host Control Agent?
A.
10. How to update the Preequisite checker with the lastest conditions?
A. Download the latest version of SAR file PREREQUISITE_CHECK_DATA_700.SAR from the marketplace and extract the files to
11. What SAP Guides are used for Installation?
A. Master Guide, Technical Infrastructure Guide, Media Guide, Specific Notes.
12. What is the difference between Standard, Distributed, and High-Availability system installation types?
A.
Standard - PAS, DB, and SCS run on single host
Distribute - PAS, DB and SCS run on different hosts
HA - PAS, DB, ASCS, SCS each run on separate host
Both ASCS and SCS run in a switchover cluster infrastructure. ASCS and SCS must have their own Enque replication server (ERS) instance.
13. What is the need of standalone host agent?
A.
14. Examples for possible distributed and HA system installations
A.
15. Describe about Standalone Host Agent.
A. Using the host agent you can centrally monitor any host with the Alert Monitor or the NWA or ACC. The host agent is used by the ACC for starting, stopping and relocating SAP instances and databases.
The host agent is automatically installed during the installation of NW components. You may need to install a standalone host agent in case
1. If you want to manage a host that does not have an SAP instance or component
2. If you have upgraded your SAP system to NW7.1 or higher and want the instances of the upgraded system to be managed by the ACC
The host agents contain
1. The control program saphostexex
2. The SAP NW Management agent SAPHostControl (sapstartsrv)
3. The sapacosprep executable of the Adaptive Computing Infrastructure
4. The operating system collector saposcol
The installed programs are automatically started when the host is booted.
The automatic start is ensured by the startup script sapinit that start the required executables.
16. Where can you find the result of the Prerequisite check phase in the SAPInst?
A. Check the results in the file prerquisites_checker_results.html under the installation directory.
17. How to run a test for High-capacity tape drive?
A. tar -cvf /dev/
18. How to display the available disks on AIX?
A. lspv and lspv -p
19. How to display the RAM size on AIX?
A. lsattr -El sys0 -a realmem
20. How to check the C++ runtime levels on AIX?
A. lslpp -L xlC.aix50.rte and lslpp -L xlC.rte
21. How to check the OS version on AIX?
A. lslpp -l bos.rte
22. How to ML and TL levels on AIX?
A. oslevel -r or oslevel -s
23. Describe about AIO need under AIX?
A. If the database is installed using the filesystems, the settings for AIO should be maxservers = minservers = 1.2 X number of datafiles used for the Oracle
Having more number of maxservers for AIO will cause problems, the reason is the surplus AIO processes are charged against the database system rather than root and have a lower scheduling priority. All processes become active very quickly and once active, the AIO servers are never stopped.
24. What is the check condition for max processes per user (maxprocs) on AIX?
A. max processes per user > max aio servers + all other process of the ora
25. How do you adjust minperm and maxperm parameters on AIX?
A. SAPNote: 973227
26. What library will be used for LDAP on AIX?
A. libldap.a
27. How to check the fileset consistency on AIX?
A. lppchk -v
28. How to do a printer check on AIX?
A. lp -d
29. Which XML file contains space requirements for SAP system installation?
A.
30. What is the X11, Perl, NLS, saplocales, fonts, codepages, NFS installation necessary prior to the start of the SAP installation?
A.
If the application servers are installed decentralized, NFS must be installed.
fonts and code pages should be pre-installed.
X11 is needed for Oracle database software installation with runInstaller.
Perl should be installed for applying Oracle interim patches
31. When do we install ABAP Central Services?
Kinds of SAP Tables
What is transparent table?
Transparent Table : Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.
What is a cluster table? Where and when we use these tables?
Pooled Table : Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be combined in a table pool. The data of these pooled tables are then sorted in a common table in the database.
What is a pool table? Where and when we use these tables?
Cluster Table : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to store control data. They can also be used to store temporary data or texts, such as documentation.
What is the major difference between Standard tables, Pooled tables and Clustered Tables?
A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement.
Transparent table is a one to one relation table i.e. when you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data.
A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field.
One of the possible reasons is for instance that their content can be variable in length and build up. Database manipulations in ABAP are limited as well.
But pool and cluster table is a many to one relationship table. This means many pool table store in a database table which is know as table pool.
All the pool table stored table in table pool does not need to have any foreign key relationship but in the case of cluster table it is must. And pool and cluster table is basically use to store application data.
Table pool can contain 10 to 1000 small pool table which has 10 to 100 records. But cluster table can contain very big but few (1 to 10) cluster table.
For pool and cluster table you can create secondary index and you can use select distinct, group for pool and cluster table. You can use native SQL statement for pool and cluster table.
A structure is a table without data. It is only filled by program logic at the moment it is needed starting from tables.
A view is a way of looking at the contents of tables. It only contains the combination of the tables at the basis and the way the data needs to be represented. You actually call directly upon the underlying tables.
How many tables we will come across in ABAP?
Ans : 3 types : Pooled , clustered, Transparent
How many kinds of internal table are there?
Ans: 5 Types.
Standard Table,
Sorted Table,
Index Table,
Hashed Table,
Any Table ( Generic type , Rarely used )
Some more NetWeaver QA on Installation and Migration
Can I install an SAP NetWeaver 7.0 SR3 system on 32-bit platforms?
As of SAP NetWeaver 7.0 SR3 (SPS 14) you can install only dialog instances on 32-bit platforms. All remaining instances (central instance, database instance, central services instance (SCS), ABAP central services instance (ASCS)) you can install only on 64-bit platforms.
Is SAP Solution Manager 7.0 a new release following SAP Solution Manager 4.0?
SAP Solution Manager 4.0 SR4 (SPS 15) was renamed to SAP Solution Manager 7.0 to make the name compliant with SAP NetWeaver 7.0.
The new name SAP Solution Manager 7.0 brings with it the advantage of both SAP Solution Manager and SAP NetWeaver having the same release number, and is aligned with SAP's decision to streamline its product offerings. This decision also highlights the close alignment and joint go-to-market strategy of these two products.
The renaming of SAP Solution Manager 4.0 to SAP Solution Manager 7.0 is a name change only, therefore the SAP Solution Manager functionality, release schedule, installations, or other technical aspects of SAP Solution Manager will not be affected.
How can I install SAP Solution Manager Diagnostics on an SAP Solution Manager 3.2 system upgraded to SAP Solution Manager 7.0?
Proceed as follows:- Install the Java Add-In for ABAP with SAPinst.
- Deploy LMSERVICE*_.SCA with SAPinst
For more information, see the installation guides at http://service.sap.com/instguides -> SAP Components -> SAP Solution Manager -> Release 7.0
Can I install an SAP NetWeaver 7.0 system as a non-Unicode system?
You can install an SAP NetWeaver 7.0 SR1 or SR2 ABAP system as a non-Unicode system. When you install an SAP NetWeaver 7.0 SR1 or SR2 dual-stack system (ABAP+Java), the ABAP part of this system can also be installed as non-Unicode. The Java part of this system can only be installed as Unicode.As of SAP NetWeaver 7.0 SR3, you cannot install an SAP NetWeaver 7.0 ABAP system or the ABAP part of an SAP NetWeaver 7.0 SR3 dual-stack system as non-Unicode any longer.
However, non-Unicode is still supported when you perform the system copy for an SAP system upgraded to SAP NetWeaver 7.0 SR3.
Where can I find the Configuration Wizard?
The Configuration Wizard is a Java application in the SAP NetWeaver Administrator:http://
or open the application with the following shortcut directly:
http://
What are the benefits of using the Configuration Wizard?
- You only have to read a reduced number of guides and get familiar with a reduced number of tools.
- You do not need to check conflicting configuration settings and mutual dependencies between components, as the configuration wizard takes care of these dependencies.
- Reduced time and effort for setup
How can I cancel/re-execute configuration task which has "Currently executing" status?
This may happen if your web session has expired during execution of configuration task which was not able to finish in the background because it needed some user input/response. The next time you login to Configuration Wizard if the server is not restarted you will see this task with "Currently executing" status which prevents you from re-executing the task. The status can be cleared by restarting the "tc~lm~ctc~cul~startup_app" application. To do this go tohttp://
Then stop and start the application.
What takes place during a homogeneous system copy?
The main purpose of a homogeneous system copy is to build a test, demo or training system or to move a system to a new hardware. The difference from a heterogeneous system copy is that both the database and operating system remain the same. Because of this on some platforms there is the possibility to perform the copy using database dependent methods. Please read SAP Note 89188. Please note - no matter if you change the version or bit version of either the operating system or the database, the system copy is still considered to be a homogeous system copy (e.g. system copy from Windows 2000 32-bit to Windows 2003 x64).What takes place during a heterogeneous system copy (migration)?
The main purpose of a heterogeneous system copy is to create a copy of an already existing R/3 system on the platform where either operating system, or database, or both differ from the operating system/database of the source system.The whole migration process consits of five main steps:
a) preparation steps on the source system
b) export of the source system data into database-independent format. In a ABAP+ Java system it#s required to both export the ABAP and the Java stack.
c) transfer of the data made during the export
d) new system installation together with data import
e) post-processing steps within the target system
Which tools are used during a migration on source and target systems?
The main programs used for the migration are - depending on the kernel release 'R3SETUP' or 'sapinst'. When working, they call some other programs for particular purposes: R3LOAD, R3LDCTL, R3SZCHK. There are also several command files or, in another words, installation templates, that have the extensions R3S (R3SETUP) or xml (sapinst).For the kernel-tools used during a migration some rules should be followed:
a) Tools used at the export on the source system must have the same version as on the target system.
b) Tools used must all have the same kernel-version. (do not mix up kernel-tools of different releases)
c) Tools must have the same kernel release as the system which is migrated.
The Java system copy tools do not depend on the kernel-version and you can always use the latest version of these tools.For details on this please refer to note #784118.
These rules should be applied unless otherwise specified in an appropriate installation/migration note or guide. Please keep this in mind when downloading a patched version of any mentioned tool from SAP Service Marketplace.
What is the purpose of the files of different types that are used during a migration?
DDLSAP
SAP
SAP
These are binary files and they should never been changed by any editor.
SAP
SAP
TOC files must never been changed besides the approval of SAP Support is given.
SAP
SAP
I am considering a database/operating system change. Are there any requirements that should be met before the migration starts?
A heterogeneous system copy requires a certified consultant responsible for the migration as well as the migration services if a productive system is affected. Please refer to SAP Note ' 82478 where the requirements are described in detail.How and from where can I get all the necessary tools for a migration?
To order a Migration Kit please create customer message under XX-SER-SWFL-SHIP component and specify exact OS and DB versions as well as Kernel Release of the system you would like to migrate. A migration guide can be downloaded at: http://service.sap.com/instguides. A list of notes with the most up to date information might be found in beginning of the migration guide.Is there anything else I need to have/ to do/ to know before doing a migration?
You also need an installation package to build up the target system and installation guide, which you can get in the same way as the Migration Kit and System Copy Guide. Please also read carefully Note #82478 and information stored under http://service.sap.com/osdbmigration.You may find very useful information in the SAP OS/DB Migration Service and SAP OS/DB Migration Service Planning Guide (please, pay attention to chapter "Organizational Steps"), where you also can find out all prerequisites and requirements for this procedure. Please, note that the migration must be performed by a Basis consultant with special certification for OS/DB Migration.
How can I check whether a migration of a specific product/os-db-combination is supported?
Please check whether both the source and the target product/os-db-combination is supported first. Please refer to the Platform Availability Matrix on http://service.sap.com/pam for this.In addition please check both the system copy guide and the relevant notes for any restrictions. In some exceptional cases it may be necessary to set up a pilot project for a specific system copy.
Fore more details regarding the availability of system copy procedures odf BW 3.0B/3.1 and SAP NetWeaver 04 systems please refer to: http://service.sap.com/bi --> Services & Implementation --> System Copy and Migration.
Please also refer to the following notes:
#777024 - BW3.0 and BW3.1 System Copy
#771209 - NW04: System copy (supplementary note)
#888210 - NW04s: System copy (supplementary note)
#543715 - Projects for BW Migrations and system copies
For more details on the system copy of 'SAP Web AS Java 6.40' based systems please refer to note #785848 on restrictions and procedures.
Where can I find information on how to optimize the overall runtime of a system copy?
You may refer to: HTTP://service.sap.com/systemcopy -> System Copy & Migration -> Optimization for this.Are there any restrictions regarding system copies in general?
Yes, there are. You should always refer to the corresponding system copy guide to check the details. For instance for the system copy of ABAP+Java or Java systems of release NW 7.0 the following applies:- "Refresh"of the database is not supported. A"refresh" of the database means that only the database is loaded with the content of a database of a different system. As in this scenario no migration controller is invoked, this is not supported.
- Copying the database only is not supported
- Copying the central instance only is not supported. The migration controller deletes all dialog instances in the database, so the system is not complete any longer.
- Reinstalling the central instance without the database is not supported.
The migration controller deletes all dialog instances in the database, so the system is not complete any longer.
Is it possible to perform a final migration of a productive system without a "test" run?
No, you should never do this. You should perform a test migration on a comparable hardware with a system which is a copy of the productive database. This is necessary both to get an idea of the overall runtime of the productive migration an to recognize major issues at the export/import before the final migration.The same applies for the migration key. That means the migration key is generated as a self-service and should be tested before the productive migration. In case of any issues with the key generated it's not possible to create migration keys by the weekend support.
Configure ALE
Tcode: SALE
Step 1: Create Logical System
Next screen will be
Create logical systems YLS800, YLS810
Save it and back
Step 2 : Assign Client to Logical System
Dbl Click on 800 Client and give the logical system as YLS800
Dbl Click on 810 Client and give the logical system as YLS810
Step 3 : Create RFC destination
Give the RFC destination Connection type, Description and Target Host
Click on Logon/Security
Give the Language Client, User , Password
Click on Test Connection and Remote Logon
Step 4 : Create Port WE21
Select own port name and give the own port name and click on continue
Give the Description and RFC Destination created by you ie YLS810RFC
Step 5 : Create Partner Profiles WE20
Give the Partner no Parrtner type Type Agent Lang and save it
Click on Outbound Parameters
Give the Message type , Reciever Port Basic type and save it
Step 6 : Create Distribution Model
Click on Create Message type give the shorttext and Technical name and continue
Step 7 : Generate Partner Profiles
Enivornment -> Generate Partner Profiles
Give the logical system name
Step 7 :
save it , So material 858 Created
Step 8 : Send material BD10
Step 9 : Check the Idoc WE02
Click on F8
Step 10 : Execute the program RBDMOIND- Status Conversion with Successful tRFC Execution
You can check the status record status 12 appears.
Step 11. Login 810 ABAP EDITOR SE38
Execute the program RBDAPP01 - Inbound Processing of IDocs Ready for Transfer
S\tep 12 : Idoc List WE02
Check the entrty in MARA TABLE
Step 1: Create Logical System
Next screen will be
Create logical systems YLS800, YLS810
Save it and back
Step 2 : Assign Client to Logical System
Dbl Click on 800 Client and give the logical system as YLS800
Dbl Click on 810 Client and give the logical system as YLS810
Step 3 : Create RFC destination
Give the RFC destination Connection type, Description and Target Host
Click on Logon/Security
Give the Language Client, User , Password
Click on Test Connection and Remote Logon
Step 4 : Create Port WE21
Select own port name and give the own port name and click on continue
Give the Description and RFC Destination created by you ie YLS810RFC
Step 5 : Create Partner Profiles WE20
Give the Partner no Parrtner type Type Agent Lang and save it
Click on Outbound Parameters
Give the Message type , Reciever Port Basic type and save it
Step 6 : Create Distribution Model
Click on Create Message type give the shorttext and Technical name and continue
Step 7 : Generate Partner Profiles
Enivornment -> Generate Partner Profiles
Give the logical system name
Step 7 :
save it , So material 858 Created
Step 8 : Send material BD10
Step 9 : Check the Idoc WE02
Click on F8
Step 10 : Execute the program RBDMOIND- Status Conversion with Successful tRFC Execution
You can check the status record status 12 appears.
Step 11. Login 810 ABAP EDITOR SE38
Execute the program RBDAPP01 - Inbound Processing of IDocs Ready for Transfer
S\tep 12 : Idoc List WE02
Check the entrty in MARA TABLE
Enable an SAP R/3 System send Idocs to SAP PI
Maintain the Sender R3 system 1. SM59 : Create a RFC destination to XI
2. WE21 : Create a TRFC Port ->Specify the RFC Destination Created
3. BD54 : Create a Logical System for the Idoc Receiver
4. WE20 : Create Partner Profile ->Maintain Outbound and the Inbound Parameters
Log on to XI System: 1. SM59 : RFC Destination for Sender System
2. IDX1 : Create the port to get Idoc Metadata from Sender System ( The Port Name must match the port name in the idoc header - Usually in format SAP. eg. SAPID1 [Optional Step. Not mandatory]
3. IDX2 : Maintain the Idoc Metadata. This is needed only by XI, and not by other SAP systems. IDX2 is needed because XI needs to construct IDoc-XML from the IDoc. No other SAP system needs to do that.
To Enable Acknowledgement: SXMB_ADM ->Integration Engine Configuration ->Specific Configuration ->Add New entry -> Select parameters as:
Category: RUNTIME
Parameters: ACK_SYSTEM_FAILURE
Current Value: 1
Go to SLD: 1. Create Technical System: Choose WEB AS ABAP if the system is R/3 -> Define SAP SID, Installation Number and Database Host Name a Maintain message Server Details according to Sender System -> Maintain Client Details of Sender System ->Select a Installed Product for Sender System
2. Create Business System: Choose WEB AS ABAP if the system is R/3 -> Choose the Technical System and the client Created Before -> Choose the Installed Product -> Set:
Business System Role: Application System
Related Integration Server: Integration Server
Idoc Tunneling in XI To prevent performance consuming XMLization and de-XMLization IDOCs are tunneled through SAP XI IDOC adapter meaning no XMLiziation is executed before the IDOC is passed onto the pipeline. Note the message is converted to UTF-8 codepage.
Start transaction SXMB_ADMIN on SAP XI.
Select option Configuration->Integration Engine Configuration and add two parameter EXTERNAL_MAPPER in the category IDOC.
Configure the parameter according to the conditions below:
If Message Code and Message Function are specified in the partner profile:
..ReceiverPort...
If only the Message Code is specified in the partner profile:
..ReceiverPort..
If only Message Function is specified in the partner profile:
..ReceiverPort...
Integration Builder Integration Directory:
1. Add Business System: Adapter Specific Identifiers -> 'Logical System' identical to the 'Logical System Name' in the SLD Business System
2.IDoc Receiver Communication Channel: port the same as XI System IDX1
2. WE21 : Create a TRFC Port ->Specify the RFC Destination Created
3. BD54 : Create a Logical System for the Idoc Receiver
4. WE20 : Create Partner Profile ->Maintain Outbound and the Inbound Parameters
Log on to XI System: 1. SM59 : RFC Destination for Sender System
2. IDX1 : Create the port to get Idoc Metadata from Sender System ( The Port Name must match the port name in the idoc header - Usually in format SAP. eg. SAPID1 [Optional Step. Not mandatory]
3. IDX2 : Maintain the Idoc Metadata. This is needed only by XI, and not by other SAP systems. IDX2 is needed because XI needs to construct IDoc-XML from the IDoc. No other SAP system needs to do that.
To Enable Acknowledgement: SXMB_ADM ->Integration Engine Configuration ->Specific Configuration ->Add New entry -> Select parameters as:
Category: RUNTIME
Parameters: ACK_SYSTEM_FAILURE
Current Value: 1
Go to SLD: 1. Create Technical System: Choose WEB AS ABAP if the system is R/3 -> Define SAP SID, Installation Number and Database Host Name a Maintain message Server Details according to Sender System -> Maintain Client Details of Sender System ->Select a Installed Product for Sender System
2. Create Business System: Choose WEB AS ABAP if the system is R/3 -> Choose the Technical System and the client Created Before -> Choose the Installed Product -> Set:
Business System Role: Application System
Related Integration Server: Integration Server
Idoc Tunneling in XI To prevent performance consuming XMLization and de-XMLization IDOCs are tunneled through SAP XI IDOC adapter meaning no XMLiziation is executed before the IDOC is passed onto the pipeline. Note the message is converted to UTF-8 codepage.
Start transaction SXMB_ADMIN on SAP XI.
Select option Configuration->Integration Engine Configuration and add two parameter EXTERNAL_MAPPER in the category IDOC.
Configure the parameter according to the conditions below:
If Message Code and Message Function are specified in the partner profile:
..ReceiverPort...
If only the Message Code is specified in the partner profile:
..ReceiverPort..
If only Message Function is specified in the partner profile:
..ReceiverPort...
Integration Builder Integration Directory:
1. Add Business System: Adapter Specific Identifiers -> 'Logical System' identical to the 'Logical System Name' in the SLD Business System
2.IDoc Receiver Communication Channel: port the same as XI System IDX1
Subscribe to:
Posts (Atom)