Posts

Showing posts from April, 2011

HOW TO SAP - Applying SAP License

Image
Make sure you already received the license from SAP

Tcode slicense

If you just perform system copy, then remove old license.

Click "New Licenses"


Delete off all the old exisitng license.


Now you may import in the new license. Click Install

HOW TO SAP - Request SAP LICENSE from SAP

Image
Visit http://service.sap.com/licensekey > Keys & Request > License Key


Select request permanent license key


To seach for installation key, go to tcode slicense


Once found your installation, click New System


Enter all the details need from the screen

For hardware key, refer to tcode slicense.

Continue and SAP will ask for your email address so that they can sent you the license file.


HOW TO SAP - How to approve support packages via solman manager

Image
There is a shortcut by running functional module

Tcode se37, enter /TMWFLOW/MO_UI_BASKET_AUTHORIZ

Click on test execute


Press execute


Patch waiting for download will be displayed below. Check and then click confirm download

HOW TO SAP - You cannot logon (CUA system assignment missing)

Just reset user password

HOW TO SAP - The entered password is not downward compatible (see long text)

Image
Tcode SU01, reset user password and encounter:
"The entered password is not downward compatible (see long text)"



To resolve, don't type "enter" instead, use mouse and click on Save.

HOW TO SAP - Solman to approve support pack - AISUSER

Image
Before you can use solman to approve support pack, you have to add yourself to AISUSER tcode

Tcode AISUSER


Click edit and add your userid and OSS ID eg:6785432 (without S and Zero)

Now you can execute tcode solution_manager and you will see maintain optimizer to approve the download.

HOW TO SAP - Client Copy

Image
SCC8 + SCC7- Import/Export (only one system's client is locked at a time)
SCC9 - Remote client copy (both source and target client will be locked) SCCL - Local import (between local clients in same system)

* We are copying client from one system to another using SCC8. It will create a transport number. * For client export, you can specify more then 1 processors. Execute SCC8


Click schedule as background job


Check Immediate and click schedule job


Continue



Transport will be created


Check status from SCC3 > Export >
Run STMS and import the 3 transport. Starting with
HRPO0000XXX
HRPT0000XXX
HRPX0000XXX
Run SCC7 after finish transporting client.

Click Start Immediate or Schedule as background


HOW TO SAP - Estimate I/O cost (expensive sql)

Image
Dbacockpit or db02

SQL Statement


Double click on any sql statement


Click Explain tree


You will see the estimate I/O cost

HOW TO SAP - Create Database in MS SQL 2008

Image
Two types of database – system database(MS SQL) and user database (HRT)


Master:  MS SQL database. Contains info of all physically files, configuration.Model :  template dataabasemsdb : manage sql server agent configuration.tempdb:  store temporary tables

Right click databases > new database

Enter TST as database name

For the 1st data file , the extenstion should end as *.mdf

Click Add (for new data files)
Logical name TSTDATA2, Path M:\TST\Data2\, File name : TSTDATA2.ndf
For other data files, remember extension should be *.ndf

TST_Log path is M:\TST\Log1, File name: TSTLOG.ldf
Remember logfiles extension is *.ldf

Double click cell under Autogrowth. Settings can be change here.

Ok

HOW TO SAP - Upgrade Kernel

Kernel upgrade is simple.

Once downloaded and uncar the *.sar files

Stop sap and sap services

Do a backup of the exe folder in our case its
\usr\sap\sid\dvebmgs00\exe

Then replace the uncar files into exe folder.

Now restart SAP.

If fail, restore back the exe folder

:D

How to use sap car

Backup any folder or files before you process.
First search for sapcar.exe. Its usually located at \usr\sap\sid\dvebmgs00\exe
To uncar your *.sar files, run this command
SAPCAR -xvf  dw_294.sar
All files in dw_294.sar will be uncar into the directory where sapcar.exe is located.

To list a file (preview) you may execute
SAPCAR -tvsf dw_294.sar > c:\list.txt

This way, it will not uncar any files but list out the files for you in list.txt.
Find the file in drive C: