Pages

Saturday, 8 December 2012

What is Logon load balance

Logon Load Balance | SMLG

During the request message server check for the least loaded instance in the group and route the request to that instance.

If instead of logon group we specify the instance then the request is routed to that instance only. Means no load balancing occur in this case.

difference between R3trans and SAP-DBA

R3trans | SAP-DBA

R/3trans is the R/3 system transport program which can be used for transporting data between different SAP systems ,even when they dont belong to the same group. R3trans normally is not used directorly but called from the Tp controle program or by the R/3 upgrade. Tp is the basic tool for the transporting the request.

Saturday, 1 December 2012

SAP Software Change Registration (SSCR)

SCCR Key | SAP Software Change Registration Key


SAP Software Change Registration (SSCR) is used to manage all changes by the customer to the SAP source code and SAP Dictionary objects. Everytime you register SAP issues a 20-digit registration key, which is issued for each object and SAP provides no guarantee for these types of modifications.

Advantages:
This supports rapid error location and correction
Prevents unintentional system modification
Ensures system stability
Overview of all the modifications facilitates the processing of release upgrades.
Here is a quick direct link to SSCR at SAP Support Portal.

SPOOL Administration - SPAD

SPOOL Administration in SAP | SAP SPOOL

 
It is used to output the document to a printer, fax, email and SMS etc.
It is only the process which is used to display the documents before they get printed.
Once a spool request is generated in the system, It can be printed to any printer with n no of copies, at any time.
Where as normal printing, the document will not be available once it is printed.
We can change the output format at any time.

Spool work flow:

A dialog user or a background process initializes a print request.
The print requests are stored in a location which is determined by a parameter ‘RSPO/Store_location = G/DB’.
G- Global directory at OS level
DB- In database tables.

This location is referred as “Temse”( Temporary Sequential File).
Temse is stored in Global directory when it is referred as ‘G’. It is stored in database tables TST01 ; TST03. If it is referred as ‘DB’ .

By default the value is ‘DB’.

G: (Global Directory on Application Server):

1. If G is specified it is stored at OS level
2. The printing will be faster if there are less no of documents. Because from file system to spooler

The communication faster than database to host spooler

Disadvantages:

1.A dedicated backup has to be planned to save the contents of Global directory.
2. When the records are more the printing consumes more time because of ‘Lack of indexes’ at file system.

Advantages:

1. No special attention is required to backup the spool requests.
2. RDBMS rules are inherited to spool requests, because they are in the Database.

‘Temse’ stores spool requests

Spool process gets initiated and reads the contents from ‘TST01’ name of the Author, no of copies name of the printer and spool data from ‘TST03’. And converts spool requests into “Output Requests’ (Printer specific requests).

The communication between the spool process & Host spooler depends upon the type of “Access Method”.

1. Local Access Method: The spooler process and the host spooler resides on the same server, then LAM is used.
On UNIX- OS Access Method ‘L’ is used (SAPLPD)

(To print the spool requests ------à # lpstat (Queue Name))

On windows Local Access Method ‘C’ is used.

It is direct OS called method.

Note: The printer can be connected to directly or we can send request too print server.


2. Remote Access Method : The ‘Spool Process’ &’Host Spooler’ request on different machines

On UNIX machines Remote Access Method ‘U’ is used It is derived from UNIX Berkley Protocol.
On windows SAP proprietary protocol type ‘S’ is used.

3. Front end printing:

The spool process is dedicated to the user requests and it will not be freed until the process finishes the task.

The spool process are configured by parameter ‘RDISP/WP_NO_SPO’
Depending on the resources as many no of spool processes can be configured.

In order to avoid spool congestion configure front end printing process to either 2 or 3 i.e. at any given point of time 2 or 3 work process can go into front end mode.

Goto SPAD to define printer.

Click on ‘Output Device’------à Create -------à

Specify the name of the output device. Ensure that the naming conversation are followed to define the name of the printer.

Provide a short name

Specify the device type (i.e. serial no & manufacturer of the printer)

If the device types are not available, communicates with SAP or the vendor, get the device types and import it to SAP system.

Goto SPAD ------à Utilites-------àdevice types ---à Import

We can also import ‘Character sets’.

Specify the spool server

Spool Servers: The application Server which is configured with at least one spool process is called as spool server.


Spool servers can be logical or real

Goto SPAD -----à click on spool servers--àclick on change(F8)---------à Create

We can create our own spool servers.

Logical Spool Serever:

Define the logical spool server and assign it to a real spool server

In order to select Logical Server
Select [ ] Logical Server ------àspecify mapping real server alternate server

Also [ ] Allow load balancing.

Device Class : Specify whether it is a printer , Archiving , fax etc…
Authorization Group: For securing the printer
Specify Model, Location & Message

Access Method : Specify the Access Method specify the host name

[ ] Do not query host spooler for output status.

Output Attributes: Specify

Tray info:

“RDISP/WP_NO_SPO_PRO_Max” to limit the users for front end printer.

Spool Monitoring: Spool requests are monitored in transaction SP01

Go to SP01 to display ‘Spool requests’ and ‘Output requests’ specify the ‘Spool request ‘ number or user id, Date & Time, Output device to display the Spool requests.

The spool request has the following statuses:

‘-‘ : The request is not sent to the host system (output request does not exist)
‘+’ : Spool request is generated and stored in “Temse’.
‘Waiting’ : The spool request is waiting to be processed by a spool process.
‘in process’ :Te spool work process is processing the spool request into output request for printing.
‘Printing’ :Te host spool is printing the request. If the RS system does not receive any status from the host spool, the status is dispatched for one minute and shifts the status to ‘Completed’

SPOOL Administration in SAP
Note: There are instances where the printing is continued and the status is set to “Completed”. This is due to the option set “[ ] Do not query host spooler for status”

‘Completed’: Generally the completed status donates that output request completed successfully, because the ‘spool system’ communicates with ‘Host Spool’ and if it doesn’t receive any status update within one minute , the status is set to “ Completed”

‘Problem’ : The output request is printed with minor error (Page Format, Margins).

‘Error’ : Indicates an error that the ‘Host Spool’ system is not reachable can a network error.

‘Archive’ : The request is waiting to be archived. Archived requests will be stored in external devices and are available to print at any time SARI & SARA.

Transaction SPIC is used to check the consistency of Spool Mechanism

Go to SP12 for “Temse” administration

It is used to identity the size based on users and applications in the “Temse”

SAP Installation and Upgrade Screenshots

SAP Installation and Upgrade Screenshots | SAP Upgrade

Attached is the link for all important installation that i have documented and would like to share to explore more on Basis activities.

http://rapidshare.com/files/284606380/install_upgradeSAP.rar

SAP DB Restore/Refresh

SAP System refresh | SAP DB Refresh/Restore


System/DB Restore Procedure:

Make a note of SAPLICENSE of the target system.
Check for the kernel version of target system is same as the source system. Other wise
Upgrade the kernel in target system to the same level of source system.
SAP DB refresh / System refresh
Check that the directory structure of the target system must be same as the source system Source system

Target system:

Copy the .aft, .tib and backPRD.log files from source system to destination system. These .aft& .tib files must be of the same date and time when the backup was taken. .aft file is the offline backup file-it contains all the information regarding offline backup .tib file contains information regarding tape initialization. BackPRD.log contains the entire l the backups log information.
In  .aft ,.tib files replace Source system SID<PRD> with target system SID<DEM>
Copy the trace file from source system to destination system.This trace must be of the same date and time when the backup was taken.
Connect to ERPDBA to restore   and follow the below screenshots.
Now the restoration process will start.

After Successful restore Shut down the database to create the control file.
Rename the present control files in target system. Control file is located n four locations
H:oracleDEMsaparchcntrl
G:ORACLEDEMSAPDATA1cntrl
L:oracleDEMsaparchcntrl
I:oracleDEMoriglogAcntrl
Create the control file with the old trace file copied from source system with RESETLOGS option In the trace file copy the text from
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE “PRD” NORESETLOGS ARCHIVELOG
to
CHARACTER SET WE8DEC

In a text file and change the Create command as follows.
CREATE CONTROLFILE SET DATABASE “PRD” RESETLOGS ARCHIVELOG
Connect to Sqlplus /”as sysdba” and then paste the entire text then control file will be created.

Open the database with reset logs.
Initialize SAPconnet for this follow the screenshots.
 Change the Environmental variable of  DBS_ORA_SCHEMA to SAPR3.
Then restart the system and up the MMC.
Apply the sap license of the target system that was noted before restore…

What is SLICENSE in SAP

SLICENSE in SAP | SAP SLICENSE


SLICENSE – It is a transaction that is used to apply the license to get the runtime support for the system even though it is valid for 30 days (4 Weeks i.e. 28 days). It is recommended to apply license because they are not considered for support.



Goto – Market place www.service.sap.com/licensekey
Click on obtain permanent license key
Select the Installation number based on the component (ERP, NETWEAVER(EP, BI, XI, PI, MI, JDI), SCM, SRM, CRM & Solution Manager).

Specify the system ID(SID), OS, DB, System Type, purpose(DEV, PRD, QAS, TEST etc)
Click on continue to display the hardware key input.
The license key is specific to Customer, Installation number, System Number, Hostname and the Hardware key.

Hardware key is unique (use command saplicense -key )
Specify the Hardware key and email-id to generate and send license key to the mail-id specified, Alternatively select the system and click o
Execute [Slicense] Tcode

Click on > New Licenses
Click on > Install license key and it prompts for the path of the license key, provide the downloaded file path and click on OK to apply the license.

Remote Function Call ( RFC)

Understanding Remote Function Call (RFC) Processes | RFC in SAP-SM59

RFC is used to communicate between SAP systems and SAP to Non-SAP systems using TCP/IP protocol.  RFC’s are defined in [SM59]. There are 4 types of RFC’s
1. Asynchronous RFC
Remote Function Call in SAP
2. Synchronous RFC
3. Transactional RFC
4. Queue RFC

1. Asynchronous RFC – (Like a post card). The sending system may or may not receive it. i.e. there is no acknowledgement from the receiving . The transmission is not reliable.

2. Synchronous RFC – It is not like ARFC. It gets an acknowledgement from the target system. (like a register post).
If the receiving system is not available the process goes into RFC/ CPIC/ Sleep mode and waits until it is wakened by the target system. Target system/ Receiving system may be busy i.e. all the resources are used up. This is reliable but time consuming and expensive (Client Copy) the job should get finished.
Note: SAP uses CPIC protocol SAP specific (Common Programming Interface for Communication) to communicate between system.

3. Transactional RFC – TRFC – It is an advanced version of ARFC and SRFC. The request goes to receiving system if it is not handled a Transaction ID is generated by the source system. A program RSARFCSE is scheduled in the background to run for every 60 seconds. Transaction SM58 is used for Transactional RFC. It is used to document all the transactional ID’s and ensure that they are received by the recipient system. This is consistence and reliable.

4. Queued RFC – It is an advanced version of TRF and ensures that the transaction is committed based on FIFO/ Queue. It ensures transaction consistency of LUW and reliability of data transmission.
SMQ1 – to monitor the outbound queues of a sending system refer SCOTT for FAX…
SMQ2 – Provides interface to monitor Inbound queues.