SAP IDES Servers & Training Server Teachnical Support with Very Lowest Price myhomebasis@gmail.com/+919052825025

SAP OIL and GAS Certification Material @ $ 50 USD
SAP OIL & GAS CERTIFICATION TRAINING
Following Materials You Will Learn@HOME : ( All Below 9+ Courses -Latest and OLD VERSION COURSES )
=================================================
IOG100 - Primary & Secondary Distribution with SAP Oil & GasEHP6 ( v097 - Col97 ) - Latest
IOG150 - Oil & Gas Industry Supply ChainIOG320 - Oil & Gas Exchanges Business
IOG330 - Bulk Transportation and Shipment Costing
IOG340 - Trading & Scheduling with SAP for Oil & Gas - EHP6 ( v097 - Col97 )- Latest
IOG350 - Service Station Retailing
IOGW40 - Joint Venture Accounting (JVA)
IOGW50 - Offshore Logistics Management (IS-Oil)SAP OIL & GAS Overview - Presentation
+

GET BELOW - 4 Alternative Study Courses For FREE :



SCM500 - Processes in Procurement ( Col92 - 2009/Q2 )
SCM600 - Sales & Distribution Processes ( Col92 - 2009/Q2 )
SCM601 - Processes in Logistics Execution ( Col92 - 2009/Q2 )
SCM611 - Shipments ( Col92 - 2009/Q2 )

SAP IDES Servers & SAP  Training Server Teachnical Support /Basis Support with Very Lowest Price
Contact  any time  : support@sapbasis.in/+919052825025


Website: www.sapbasis.in

Paid Remote SAP Basis Support and IDES Remote Access with Lowest Price and Best Performance Server

SAP OIL & GAS CERTIFICATION TRAINING
COMPLETE SET OF SAP OIL & GAS COURSE STUDY
( SAP IS - OIL & GAS STUDY PACKAGE )

NOW FOR JUST $50 USD

Now You Can Study At Home By Your Self & Become A Certified Consultant.
=================================================
IOG100 - Primary & Secondary Distribution with SAP for Oil & Gas - EHP6 ( v097 - Col97 ) - Latest 
IOG150 - Oil & Gas Industry Supply Chain
IOG320 - Oil & Gas Exchanges Business
IOG330 - Bulk Transportation and Shipment Costing
IOG340 - Trading & Scheduling with SAP for Oil & Gas - EHP6 ( v097 - Col97 )- Latest
IOG350 - Service Station Retailing
IOGW40 - Joint Venture Accounting (JVA)
IOGW50 - Offshore Logistics Management (IS-Oil)
SAP OIL & GAS Overview - Presentation
+ 
GET BELOW - 4  Alternative Study Courses For FREE :

SCM500 - Processes in Procurement  ( Col92 - 2009/Q2 )
SCM600 - Sales & Distribution Processes  ( Col92 - 2009/Q2 )
SCM601 - Processes in Logistics Execution  ( Col92 - 2009/Q2 )
SCM611 - Shipments  ( Col92 - 2009/Q2 )

Step by Step Db2 restore Production server to Quality Server (Db2 Database Refresh with Production Offline Backup)

Url For Download Db2 Resore Steps..

http://downupfiles.com/file/0S3Ij

Step by Step GUIDE Db2 BACKUP Restore Production server to Quality Server (Db2 Database Refresh with Production Offline Backup)

Login in To Production db2 Data base Server .

Login User ID: SIDadm

# run beloow command 

brdb6brt -bm RETRIEVE -es –replace <Proudction SID>=<Quality SID>,db2ecp=db2ecq,/db2/<ProductionSID>=/db2/<QualitySID>

Output file Created with File extension is .scr

Open and check the file

Login telnet in Quality Server

Output file and Db2 backup are mounted or copied in Quality Server

Change Permission of files

Stop the SAP in Quality server.

Stopsap all

>cat ECP_NODE0000.scr---à to view the file

In below screen we can view the file

Now we have to edit the “ECP_NODE0000.scr” file.

To edit this copy the ECP_NODE0000.scr file to your system using FileZilla.

Open the file with NOTEPAD and edit the file.

Save and copy the above file to the /qabackup.

Login in Quality server with db2SID user

Run below commands.

      db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=NO

      db2set DB2_WORKLOAD=SAP

   db2set –all | grep –I db2 restore grant

   db2 –tvf  ECP_NODE0000.scr (Output file .scr file)

Now open new session(192.168.1.67) and check the file systems.

To check the status

Successfully completed.

And create user id in Quality server with <ProductionServerSID>adm

Run below  command

dscdb6up –create <password of SIDadm user>  <sapsid user password>

if it will give error like not a valid user then

edit dscdb6.conf file from  /usr/sap/SID/global

write production server Username SIDadm .

Regards,

Alihamed.saRegards,

Alihameds.sa

Search for SAP Basis Transaciton codes

Search for SAP Basis Transaciton codes
You can access all the transaction codes by using the transaction code 'SDMO'.
This is the transaction code for the Dynamic Menu.
Based on your search string, you can get all related transaction codes for all the SAP application modules.
For e.g. the Search text for ADMIN returns the following results:
----------------------------------------------------------
|Tcode|Transaktionstext |
----------------------------------------------------------
|ADOK |AM: System Administration Guide |
|BALE |Area Menu for Administration |
|BDMO |ALE CCMS Group Administration |
|CATSX|Time Sheet Admin.: Initial Screen |
|CICY |CTI Administration |
|CJV6 |Maintenance: Version administration |
|CN84 |PS: Archiving project - admin. |
|COA4 |PP: Archiving order - administration |
|CSADM|Content Server Administration |
|FC_BW|Administrator Workbench |
|FDTA |TemSe/REGUT Data Administration |
|FDTT |Treasury Data Medium Administration |
|FO86 |Change active admin.contract fees |
|FO8E |Create admin.contract event |
|FO8F |Change admin.contract event |
|FO8G |Display admin.contract event |
|FO8H |Admin.costs acct sttlmnt simulation |
|FOART|REsearch: Administration Web-User |
|HRCMP|Compensation Administration |
|HRCMP|Budget Administration: Display |
|HRCMP|Budget Administration: Change |
|IM_AR|Admin. of App. Request Archives |
|KA18 |Archive admin: assess., distr., ... |
|KE72 |Archive Administration: Line Items |
|KE73 |Archive Administration: Totals Recs |
|KPRO |KPRO Administration |
|OAAD |ArchiveLink Administration Documents |
|OG00 |Personnel Administration Customizing |
|OG01 |Personnel Administration Customizing |
|OMSM |CS MM Set Up Administrative Data |
|OOCM_|Compensation Administration Settings |
|OOML |Room Administration Mail Connection |
|OOPC |Administration: Personnel No. Check |
|OY22 |Create subadministrator Customizing |
|OYEA |IDoc administration |
|PA97 |Compensation administration - matrix |
|PA98 |Compensation Administration |
|PA99 |Compensation Admin. - Release Report |
|PACA |PF administration |
|PAT1 |Personnel Administration infosystem |
|PC00_|CBS survey salary administrations |
|PC00_|Tax Certificates - Administration 16 |
|PP26 |Plan Scenario Administration |
|PP2D |Administer Payroll Results |
|PSO5 |PD: Administration Tools |
|PUCA |PC administration for PF |
|PVSEA|Administer Search Engine |
|QD25 |Archiving Notifications: Admin. |
|S002 |Menu Administration |
|SA02 |Academic title (cent. addr. admin.) |
|SA04 |Name prefixes (centr. addr. admin.) |
|SA05 |Name suffix (centr. addr. admin.) |
|SA07 |Address groups (centr. addr. admin.) |
|SA08 |Person groups (centr. addr. admin.) |
|SA09 |Internat. versions address admin. |
|SA10 |Address admin. communication type |
|SARA |Archive Administration |
|SBPT |Administration Process Technology |
|SCC4 |Client Administration |
|SCON |SAPconnect - Administration |
|SCOT |SAPconnect - Administration |
|SCUA |Central User Administration |
|SCUM |Central User Administration |
|SE78 |SAPscript: Graphics administration |
|SECST|Administration of Secure Memory |
|SENG |Administration of External Indexes |
|SENGE|Explorer Index Administration |
|SIAC1|Web Object Administration |
|SLICE|Administer SAP Licenses |
|SLWA |Translation Environment Administratn |
|SM14 |Update Program Administration |
|SP12 |TemSe Administration |
|SPAD |Spool Administration |
|SPAT |Spool Administration (Test) |
|SPHA |Telephony administration |
|SPHB |SAPphone: System Administration |
|SSAA |System Administration Assistant |
|SSCA |Appointment Calendar: Administration |
|SSCA1|Appointment calendar: Administration |
|SSO2 |Workplace Single Sign-On Admin. |
|SSO2_|Workplace Administration SSO2 Ticket |
|STMA |Proposal Pool Administration |
|SURAD|Survey Administration |
|SURL_|Personalization for URL Gen. Admin. |
|SUUMD|Display User Administration |
|SWDC |Workflow Definition: Administration |
|SWEAD|Event Queue Administration |
|SWEQA|Event Queue Administration |
|SWEQA|Queue Administrator Maintenance |
|SWIA |Selection rep. for work items(admin) |
|SWRK |Administrtation using work areas |
|SWUF |Administration of Runtime System |
|SWUL |Customizing: Process Administrator |
|SWUX |SAPforms Administration |
|SYSAD|System Administration: Task List |
|S_ALR|IMG Activity: CIC_V_CCMCTIADMIN |
|S_ALR|IMG Activity: SIMG_EURO_ADMINUSER |
|S_BCE|IMG-Aktivität: BCDIGSI_ADMIN |
|S_PH0|InfoSet Query: Administration |
|S_PH0|InfoSet Query: Administration |
|S_PH0|InfoSet Query: Administration |
|S_PH0|InfoSet Query: Administration |
|S_PH0|InfoSet Query: Administration |
|TBD0 |Datafeed: Adminster Archives |
|TBD3 |Datafeed: Market data administration |
|TBD6 |Datafeed: Log file administration |
|WE46 |IDoc administration |
|WORKI|Administrtation using work areas |
----------------------------------------------------------
What the difference between tcode SE09 & SE10?
SE09 transaction is for workbench transport request wherein the developers can track their changes or modifications to the workbench objects .
Whereas SE10 is a customising transport request transaction.this is used for displaying customising requests. Sometimes this may be restricted to business analysts.

SAP Administrator Daily Activities

SAP Administrator Daily Activities
SAP DAILY ACTIVITIES
1] Check that all the application servers are up:
sm51 SAP Servers
sm04/al08 Logon Users
2] Check that daily backup are executed without errors
db12 Backup logs: overview
3] SAP standard background jobs are running successfully. Review for cancelled and critical jobs.
sm37 Background jobs--- Check for successful completion of jobs. Enter * in user-id field and verify that all critical successful jobs and review any cancelled jobs.
4] Operating system Monitoring
st06
5] Extents monitoring
db02 Database monitoring--Check for max-extents reached
6] Check work-processes(started from sm51)
sm50 Process overview-- All work processes with a running or waiting status.
7] Check system log
sm21 System log-- Set date and time to before the last log review. Check for errors ,warning, security, message-bends, database events.
8] Review workload statistics
st03 Workload analysis of
sto2 tune summary instance
9] Look for any failed updates
sm13 update records
10] check for old locks
sm12 lock entry list
11] Check for spool problems
sp01 spool request screen-- check for spool that are in request for over an hour.
12] Review and resolve dumps
st22 ABAP Dump analysis
13] Checking .trc file in SAP trace directory for block corruption on daily basis.
C:\ORacle\sid\saptrace
14] Archive backup
brarchive -f force -cds -c
Insert the archive backup tape
15] Review NT system logs for problem
-> NT system log- look 4 errors or failures
-> NT security log- failed logon 2 sap servers
-> NT Application log -look 4 errors or failures

Tcodes used for Daily System Monitoring

Tcodes used for Daily System Monitoring
After running daily system monitoring transaction, what should we check for:
In st22 look for the core dumps if any and report to the respective consultants and try to know why it happened.
In sm21 try to check for errors.
In sp01 try to see if any spool jobs have failed.
In st02 look if any swaps are happening, swaps are not good for performance.
In st04 look for Database alert logs and Performance.
In st03 look for ratio hits.
In sm59 look for connectivety tesing if there are other systems also connected to your SAP R/3 system
In db13 look if the jobs have run successfully.
In sm37 look for any cancelled scheduled job and take action appropriately.
In sm12 look for any pending locks from the previous days.
In sm13 look for any hanged updates, or updates pending for long or updates in PRIV mode.

How to know or get the Kernel Version of SAP system

How to know or get the Kernel Version of SAP system

Posted by Basis-Consultant | 1:21 PM | Basis, how to's, Security | 1 comments »

There are many ways through which you can get the Version Number of SAP Kernel.
One of the method is from any window in the top menu go to
system--> status and click on the other kernel info button which is between the navigate and cancel buttons.

Another method is to login as administrator and enter the following disp+work -v. in command field on left top corner. This will show you the kernel version of SAP.

You can also check the log or trace files at os level /usr/sap/work/dev_disp.

You can also get this kernel information from sm51 screen. Go to transaction sm51 then click on database server (single click only. Not double click) and then click on release notes. Then you will see the kernel information and patch level.

Backup profile for SAP ECC6 + Oracle

Backup profile for SAP ECC6 + Oracle
This is my sample backup profile (initSID.sap) for taking disk backup on path /local/
backup_mode = all
restore_mode = all
backup_type = online
backup_dev_type = disk
backup_root_dir = /local/BKP
stage_root_dir = /oracle/SID/sapbackup
compress = yes
compress_cmd = "compress -c $ > $"
uncompress_cmd = "uncompress -c $ > $"
compress_dir = /oracle/SID/sapreorg
archive_function = save
archive_copy_dir = /local/arch
archive_stage_dir = /local/arch
tape_copy_cmd = cpio
disk_copy_cmd = copy
stage_copy_cmd = rcp
cpio_flags = -ovB
cpio_in_flags = -iuvB
cpio_disk_flags = -pdcu
dd_flags = "obs=64k bs=64k"
dd_in_flags = "ibs=64k bs=64k"
saveset_members = 1
copy_out_cmd = "dd ibs=8k obs=64k of=$"
copy_in_cmd = "dd ibs=64k obs=8k if=$"
rewind = "mt -f $ rew"
rewind_offline = "mt -f $ offline"
tape_pos_cmd = "mt -f $ fsf $"
tape_size = 1200M
exec_parallel = 0
tape_address = /dev/rmt/0mn
tape_address_rew = /dev/rmt/0m
volume_archive = (SIDA01, SIDA02, SIDA03, SIDA04, SIDA05,
SIDA06, SIDA07, SIDA08, SIDA09, SIDA10,
SIDA11, SIDA12, SIDA13, SIDA14, SIDA15,
SIDA16, SIDA17, SIDA18, SIDA19, SIDA20,
SIDA21, SIDA22, SIDA23, SIDA24, SIDA25,
SIDA26, SIDA27, SIDA28, SIDA29, SIDA30)
volume_backup = (SIDB01, SIDB02, SIDB03, SIDB04, SIDB05,
SIDB06, SIDB07, SIDB08, SIDB09, SIDB10,
SIDB11, SIDB12, SIDB13, SIDB14, SIDB15,
SIDB16, SIDB17, SIDB18, SIDB19, SIDB20,
SIDB21, SIDB22, SIDB23, SIDB24, SIDB25,
SIDB26, SIDB27, SIDB28, SIDB29, SIDB30)
expir_period = 30
tape_use_count = 100

SAP Kernel Upgrade

SAP Kernel Upgrade
SAP Kernel Upgrade Tutorial step by Step:
1. Login as root
2. Make new backup directory
cd /
mkdir SIDkernel_10102007
3. Create latest kernel backup
cp -pr /sapmnt/SID/exe/* /SIDkernel_10102007
4. Compare size of the original kernel and the backup
du -sk /sapmnt/SID/exe/
=>840413 /sapmnt/SID/exe
du -sk /SIDkernel_10102007
=>840413 /SIDkernel_10102007
5. Make new shadow kernel directory
cd /
mkdir newkernel_175
6. Copy the new downloaded kernel files into /newkernel_175
7. Unpack the new downloaded kernel in folder /newkernel_175
/sapmant/SID/exe/SAPCAR -xvf SAPEXE_175-20000221.SAR
/sapmant/SID/exe/SAPCAR -xvf SAPEXEDB_175-20000223.SAR
8. Login as sidadm
9. Stop the SAP System
stopsap
10. Stop saposcol
saposcol -k
11. Go to the current kernel directory
Login as root
cd /sapmnt/SID/exe
12. Copy all extracted support packages into this folder
cp -pr /newkernel_175/* /sapmnt/SID/exe13.
13. Change file permission of files into kernel folder
cd /sapmnt/SID/exe
chown SIDadm:sapsys ./*
14. Copy back the original file from backup saproot.sh into this folder.
cp -p /SIDkernel_10102007/saproot.sh /sapmnt/SID/exe
15. Login as SIDadm with root privilege
Login as SIDadm
su root
16. Go to the current kernel directory
cd /sapmnt/SID/exe
Then execute:
./saproot.sh SID
Solaris Error (refer SAP Note 420417):
# ./saproot.sh SID
> ./saproot.sh: whoami: not found
> ./saproot.sh: test: argument expected
Solution:
#PATH=/usr/ucb:$PATH
#./saproot.sh <SID>
Again execute:
disp+work
17. Start the saposcol service
Login as sidadm
saposcol
18. Start the SAP system
startsap

How lock and unlock client in sap to prevent user login

How lock unlock client in sap to prevent user login
This is a workaround to lock a client to prevent user to login during patching or any maintenance activity of SAP R/3 (ECC 6.0). Example with detaile are given below:-
Client locking:-----------
SE37->SCCR_LOCK_CLIENT
Press Run/Test (look like ZIP file button)
enter your Client No. i.e. 210/300/500/900 etc
Press Execute button only.
Done
Client Unlocking:-----------
Client lock-> SE37->SCCR_UNLOCK_CLIENT
Press Run/Test (look like ZIP file button)
enter your Client No. i.e. 210/300/500/900 etc
Press Execute button only.
Done
Best of Luck