Monday 28 August 2017

How to check the spool requests generated in SAP


Check Spool requests generated in SAP System.

1. use SP01 Transaction code to view spool requests.

2. Below screen enter username,date,client,output device,,. or you put * for collect complete information from the system.


3. Then execute it.Get the Spool list like us below.


4. we can take the whole list based on the input.








Sunday 27 August 2017

Types of access methods in SAP Spool administration


Types of Access methods in SAP Spool Administration.

1. Local printing
2. Frontend Printing
3. Remote Printing

Local Printing.
  In SAP, Local printing means printing to a printer attached to your PC, rather than a dedicated SAP network printer.

Frontend printing.
  The printing with SAP GUI, with front end printing under Microsoft Windows, the system address that defined in the Microsoft windows Operating System of the front end PC.

Remote Printing.
  SAP provides its own " Remote Printing " from Microsoft Windows PCs. This solution uses the SAPscript service to transfer output requests from SAP spool server to the Microsoft Windows spooler  .

Saturday 26 August 2017

How to setup a default printer in SAP System


How to Setup a default printer in SAP System.

1. Enter the transaction SU3.


2. The following screen appears.

      choose Edit Option to make changes.


3. Choose the " Defaults " Option.

            Select Spool control  " Output Device "

           Execute (F4) and  Choose the " Frontend Printer " already created. 
     

4. Save and Exit.
      now, the default printer is assigned to particular Person as default.

5. Want to create Front end Printer see the before posted post.









Friday 25 August 2017

How to configure Frontend printer in SAP HANA


How to configure Frontend printer in SAP HANA.

1. Goto transaction SPAD

2. Click on Display for the output device.



3. Click the edit or change icon.


4. Click on create icon.


5. Fill the fields as needed below Screen.

In first Tab " Device Attribute "

       Choose the standard Device type " SAPWIN: MS Windows Drivers,latin-1 "

       Choose Spoole Server " _AUTOSPOOLSERVER " or already have default Spool server.


6. In Second Tab " Access Method "

         Choose Host Spool Access method " F: Printing on Front End Computer "
           

7. Save and Exit.


8. Now Frontend printer is ready to take print-out in front end printer.







Thursday 17 August 2017

How to take System copy for SAP Enterprise portal (EP)


Following the below steps to tke System copy for SAP EP server.

1. Execute the SWPM ./sapinst

2. Choose the SAP EP Server system copy--> Source system 



3. Select the SAP EP server user profile.





4. Select the System copy Export location in System.Verify the export location permission,avaliable Space for system copy export file






5. Enter the DATABASE Secure Store Password.





6. Define the Table Split Setting if you need change it or else leave it as Default.






7. Define the unload settings parallel jobs define min 2-3.






8. Verify the input details if need we can change the setting here.






9. System copy Exported Started SAP EP.






10. System copy process finished it not take much time.














Wednesday 16 August 2017

SAP HANA Database upgrade 2.00.00 to 2.00.20 steps

Tags

Simple Steps to Upgrade the SAP HANA Database.

1. Login to "root" user.

2. Before that download the SAP HANA Database 2.00.20 dump and extract it.

3. Run the ./hdblcmgui (using GUI) or ./hdblcm (via terminal).

4.Getting the below initial screen.

Note: before doing database upgrade must take database backup.



5. Then select the System to upgrade.



6. Choose the component which we want to upgrade in the SAP HANA database.


7. Enter the SAP HANA database system ID and SIDADM user  password,Database user and Password.



8. Verify the input what we have provided.


9. Upgrading process started its take time to upgrade.


10. Successfully SAP HANA Database upgrade 2.00.00 to 2.00.20












Monday 14 August 2017

How to activate HTTP,HTTPS,SMTP ports in SAP system




In many case you will need to activate,and define http,https and smtp ports.To do that follow the steps.

1. Execute Transaction Code RZ10 .

2. Choose Profile Default,Instance,Start profiles.

3. IF you want to add the HTTP,HTTPS,SMTP port use Instance Profile.


4. Choose Instance profile.


5. Create New Parameter enter the below if what you want.


6. I create HTTP,SMTP Port.


7. The Save the profile parameter and active it.


8.Check the Service Port is active or not use Transaction Code--> SMICM -->click highlighted icon


9.Now get Service port HTTP and SMTP.


10.Hope its helpful(SAP beginner). 


Friday 11 August 2017

How backup and recovery works in SAP HANA Database


Backup which requires to restore the SAP HANA database in case of recovery.

SAP HANA DATA BACKUP:

To take the data backup,the HANA database system must be in online state a backup request is received by one of the index server and forward to the backup manager in the name server .The backup manager tell all participating servers to perform a global save point.the global save point is required to get a system wide consistent snapshot  of the database.

Backup controller have to get the data  from the page stored in the data volumes on the disk .this is necessary because we need to backup up the consistent state written during the global save point  operation.

SAP HANA Log backup:

Its support automatic log backup,Automatic log backup is a local process which triggered and executed by each server in the SAP HANA database server  autonomously.It perform when log segment is full ,when time limit is exceeded after startup of a server.the time limit is required  to ensure that logs are backed up from time to time even if if there are few changes and the log segment are not filled.

SAP HANA is a distributed  system.It consist of multiple servers their.own persistence name server,multiple index server,and a statistics server.It is impotent that during recovery the system is restored to a state that is consistence across the whole system.  

  



Wednesday 9 August 2017

Types of Backup in SAP HANA DATABASE


Types of Backup in SAP HANA DB:

There are 3 types of backups in SAP HANA DATABASE.

  1. Full backup
  2. Delta backup
  3. Log backup
Full backup
  • Data backup
  • Storage snapshot(snapshot backup)
Delta backup
  • Incremental backup
  • Deferential  backup
Log backup
  • transaction Log backup









Tuesday 8 August 2017

How to set user key in SAP HANA Database



We can store user password in the form of key in SAP HANA database by using hdbuserstore tool

Check Key Information in SAP HANA :

Hostname:/usr/sap/<SID>/HDB00>hdbuserstore list

DATA FILE     /usr/sap/home/.hdb/hostname/SSFS_HDB.DAT

KEY FILE      /usr/sap/home/.hdb/hostname/SSFS_HDB.KEY

KEY DEFSID

ENV      :  XYZSID:30255
USER    : HANADBXYZ

KEY KEY02

ENV       :  XYZSID:30255
USER      : system

KEY SID

ENV    : localhost:30255
USER  : system

Store Password in Key File/

use the below command to store user and password in KEY File,

hdbuserstore -v SET(KEY _name) XYZDB(SID>):30255 (user_name),(Password)

Ex:

hdbuserstore  -v SET bkp XYZHDB:30255 root,PASSWORD

Hostname:/usr/sap/<SID>/HDB00/>hdbuserstore list

DATAFILE      :  XYZ/usr/sap/SID/home/.hdb/HDB000/XYZ_HDB.DAT

KEY FILE       :  XYZ/usr/sap/SID/home/.hdb/HDB000/XYZ_HDB.KEY

KEY BKP

ENV      :  XYZSID:30255
USER    : bkp

KEY DEFSID

ENV      :   XYZSID:30255
USER    :  HANADBXYZ

KEY KEY02

ENV      :    XYZSID:30255
USER    :   system

KEY XYZ

ENV       : localhost :2017
USER      : SYSTEM








Monday 7 August 2017

SAP Solution Manager 7.1 post installation steps


SAP Solution Manager 7.1 Post Installation Steps:

1. Check Tcode SICK


2. Check Missing Index and Tables during installation in DB02.


3. STMS configuration using Tcode STMS


4. Client Creation Copy the 001 client.


5. Create Logical System


6. Save the Logical System 


7. Create client information in SCC4


8. Do the Client copy using SCCL Tcode local client copy.

Note : Client copy must copy 001 client to newly created client.





check the client copy log in Tcode SCC3

9. ADD the profile parameter SAP Recommended.

 Refer the Snote 1582842

10. Now System is ready to configuration.