Tuesday, September 29, 2009

Learnings from Remote Client Copy

1. Take offline backup just before the activity and switch off the archive logs otherwise, they will pile up and fill up the filesystem.
2. Execute the Test run before actual activity but it may not give practical results, in our scenario test run gave 2 hours but actually it took 12 hours for the copy to complete.
3. Lock users both in Target System and Source System, otherwise inconsistencies specially in number ranges may occur.
4. Take offline backup after Copy and don't forget to switch on archive logs before releasing the sytem for use.

Saturday, September 26, 2009

SAPCPIC user don't lock only change the password

SAPCPIC has the default password as (ADMIN), if you don't change the same your Early Watch Alert report will show red under User Authorizations. Follow SAP note 29276 to change the password only, don't lock the same.
Run report RSUSR003 to know what users are with standard passwords.

SAP Note 19574 Regarding Number Range in Client Copy

Amazing SAP Note clears concept of Number ranges during client copy:





Thursday, September 24, 2009

St02 Call Statistics Hit Ratio

Yesterday we did a test run of client copy from PRD to DEV client. It took 2 hours during peak load. Today I checked the buffer it is showing hit ration 51% in call statistics the
"Select" is showing only 4-5% hit ration in both PRD and DEV instance.

The above is more or less in both PRD and DEV servers, then I read one blog and it said :
"Transport activity triggers flushing of SAP buffer. Hence it is always advisable to do transport in the least loaded segment of a day." -

http://soumen.wordpress.com/performance-tuning-of-sap-another-experiance/5-st02-another-magic-transaction-for-sap-tuners-ii/

After above scenario, we should take care even test run should be scheduled after peak hours. Any other suggestions on tuning are welcome.

Tuesday, September 15, 2009

SAP MC utility allows you to start / stop sap from browser

From Netweaver Release 7.0 onwards, you may start and stop SAP intance from browser itself using the port http://hostname:5$$13 where $$ is the instance number. Amazing utility, even for UNIX also you can do the same. For more information, follow the below link:
http://help.sap.com/saphelp_nwpi711/helpdata/en/48/217444c3a34e6fe10000000a42189c/content.htm

Monday, September 14, 2009

Spool Request deleted immediately after printing

In the given scenario when we need to preserve the spool request even after printing, (in our scenario the spool is to be converted to pdf using zsmart program), we need to make sure that the "Delete after output " option in User profile (SU01) -> Defaults tab is unchecked, other wise it may delete the request immediately.
Follow below links for further information :
http://sap.ittoolbox.com/groups/technical-functional/sap-basis/spool-request-gets-deleted-automatically-2065750

Friday, September 11, 2009

How to check process and memory status in AIX

During monitoring we check the processes in SAP SM50 but if the SAP system is running for a long time, ST06 may show the RAM is reducing even though the system load is less. This results in less availability of RAM for other processes.

We need to trace the process that is consuming considerable amount of RAM. In AIX us the following command :
ps aux more
General view can be optained by command :
topas
Vitual memory state can be known by :
vmstat 01
For more information follow the below threads:
http://www.unix.com/aix/91057-process-consuming-most-memory.html
http://unix.ittoolbox.com/groups/technical-functional/ibm-aix-l/command-to-find-top-5-memory-consuming-process-2742917

Thursday, September 10, 2009

Config Tool Usage

You can only use the Config Tool to change parameters if all
instances of a SAP NetWeaver AS Java are stopped.

How to know who imported the Transport Request

From the STMS, go to Import history Goto -> import history. Then in personal settings of import history (Extras -> Personal Settings) , uncheck the "Hide Expert Fuctions" . This will bring you more options in menu. Then in Edit tab, you will be able to see "Display more" which will show the user who imported the request in "user" column.

For details follow the below link :

https://forums.sdn.sap.com/message.jspa?messageID=6606054

Tuesday, September 8, 2009

EP key pair certificate expires after 2 years of installation

When EP is installed it comes with the initial certificate for 2 years. You need to generate a new certificate so there is “Seamless SSO in spite of certification expiration “. Please follow the blog by Karsten Geiseler on SDN.
http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417400)ID0877570550DB01449507420568747014End?blog=/pub/wlg/4417

You may also follow the pdf
http://www.scribd.com/doc/6558598/Seamless-SSO-in-Spite-of-Certificate-Expiration

How to create certificate for your local system and get it certified from CA
http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417800)ID1328630650DB00590205151273352352End?blog=/pub/wlg/15747

Developers must not work on PRD system.

Referring SAP Documentation

"Also, taking into consideration security factors (and perhaps performance aspects, if the developers have to debug programs), developers must not work on production system."

Monday, September 7, 2009

DB2 License Issue

In DB2 , the SAP OEM license has to be applied after 90 days. If you don't apply then the database won't start. The procedure is different from Oracle as you need to log into the DB2 CLP to apply the license. Please find below the procedure:

1. Login as db2sol
2.Go to Start -> All Programs ->IBM DB2 -> SAPDB2SOL -> Command Line Tools -> Command Window
3. Now apply license here as per SAP Note 816773.Even with db2cmd we were not getting the actual license status.
Actually we raised OSS and logged it on SDN as well. For the same we also opened WTS connection. For more information, please refer the below SDN link:
https://forums.sdn.sap.com/thread.jspa?messageID=8124383&#8124383

Saturday, September 5, 2009

Total number of SAP transaction per day

There was a requirement from customer, if there is any way we can find out what is the total number of SAP transactions in any module in SAP. I raised the OSS, pl find below the reply:
Question :
"Is it possible to get the number of transacions done in SAP Finance per day?
We want to know how many transactions relating to FI are done in a day. "

Answer:
"There is no standard program that could record the transactions done during a day in any module."
-SAP Active Global Support

Friday, September 4, 2009

SSCR Registration : Check Advance Correction in case of SAP Notes

If you are registering SSCR keys for SAP Standard object mentioned in SAP Note then check Advance Correction checkbox, as it will tell SAP that this is due to SAP Note only, otherwise SAP warranty is invalidated.

Remote support SAPOSS - Connection Type WTS

There is more popular procedure known as R/3 support wherein the SAP support remotely connects to the customer throught SAPGUI but if the SAP server is down then WTS (Windows Terminal Server) connections needs to be opened.
How to :
SAP Note : 605795

Points to remember :
1. Please maintain the following line in the SAProuttab:
KP "p:CN=sapserv2, OU=SAProuter, O=SAP, C=DE" (IP-Address) 3389
PLEASE NOTE!!!!The "*" is a wildcard for all ports within 3200 and 3299. All otherports must be specified with their own lines.
When you make changes to saprouttab please run "saprouter -n" toreload the new saprouttab. You may also restart the router.

2. The connection needs to be re-established again from scratch (the SAProuter should come to disconnect state), otherwise, you may get error like :
route permission denied sapserv2 to (IP address of machine), (Port Number) Location: SapRouter on hostname(of machine where saprouter is running)
The above error can also come if the host entry is not maintained in saprouttab file as given above.