Suspend Or Release All SAP Background Jobs

To Suspend All Currently Released SAP Background Jobs

Run SE38
Enter program name BTCTRNS1
Click Execute

This program has no selection screen. It just returns the screen below:

In SM37 the jobs go into status "Release/Suspended":

To Release All Currently Suspended SAP Background Jobs

Run SE38
Enter program name BTCTRNS2
Click Execute

This program has no selection screen. It just returns the screen below:

Adobe Document Services (ADS) Notes

To produce an example document from within SAP GUI to test the connection to Adobe Document Services (ADS):

Run SE38
Enter program name FP_TEST_00

Choose form FP_TEST_00
Click Execute
Enter a 'real' printer such as LP01 (as opposed to LOCL)
Click Print Preview

Document will appear embedded in SAP GUI

To Display Info About the Adobe Document Services (ADS) Service

Run SA38

Enter FP_FEATURE_TEST

Adding Extra Fonts to ADS

Create folder fonts under:
/usr/sap/<SID>/SYS/global/AdobeDocumentServices/FontManagerService
Create folder customer under fonts
Ensure that the <sid>adm user has read and write permission for the directory
Restart following services in NWA: ADS (com.adobe/AdobeDocumentServices), font manager and XML template

More info here.

PAL - Printing Assistant for Landscapes

Centrally administer SAP printers for a whole landscape with transaction PAL.

Requires RFCs to target systems

SAP doc on setting up PAL

(PAL is to SAP printing what CUA is to SAP users!)

Switch Oracle Archive Log Destination

 If the SAP system/Oracle database is 'stuck' due to lack of space in the oraarch folder, the archive log destination can be dynamically changed so that log files are produced in a different location.

• Create new folder, for example: /oracle/<SID>/sapdata1/arch
• sqlplus /as sysdba
• show parameter log_archive_dest;
• alter system archive log stop;

If log_archive_dest is set:

• alter system set log_archive_dest='/oracle/<SID>/sapdata1/arch/<SID>arch';

If log_archive_dest_n is set:

• alter system set log_archive_dest_n='location=/oracle/<SID>/sapdata1/arch/<SID>arch';
• alter system archive log start;
• alter system switch logfile;

Note: This step can take a while if the system is busy or the database was previously stuck.

The location of where an archive log has been written is recorded in the Oracle table v$archived_log. Therefore it is not advisable to move the archive log files after the space in oraarch has been freed up - let brarchive backup the files and delete them.

Oracle Trace Folder

If there are no trace files in /oracle/<SID>/saptrace the configure destination may be different.
To find the configured destination:
Log into Oracle
Type:
show parameter user_dump_dest

Alternatively run:
SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Default Trace File';

SAP Backup and Restore

Info taken from:
http://help.sap.com/saphelp_nw04/helpdata/en/e6/f3d0ed99634078be2da254b97104d7/content.htm

Restore full database:
brrestore -d util_file -p init<SID>.sap.online -m full -b <backup log file to use>

Restore individual datafiles:
brrestore -d util_file -p init<SID>.sap.online -m <file number> -b <backup log file to use>

File number is the Oracle file number. To list the Oracle file numbers in the original database:

select file#, name from v$datafile;

FILE#       NAME  

---------------------------------------------- 

1 /oracle/ECY/sapdata1/system_1/system.data1 

2 /oracle/ECY/sapdata1/undo_1/undo.data1 

3 /oracle/ECY/sapdata1/sysaux_1/sysaux.data1...

Restore archive log files:
brrestore -a util_file -p init<SID>.sap.online -m <file number> -b <backup log file to use>

BDLS Notes

Transaction BDLS complains if it is not run in test mode first.

If the BDLS run fails subsequent runs may show an error:

To get around the message "Another Process is Running for Conversion":

• Run SE38
• Enter program RBDLSMAP_RESET
• Execute

No message is shown during or after the program is run.

SAP Web/Java Management Console (SAPMC)

Info taken from here:
http://help.sap.com/saphelp_nwce10/helpdata/en/44/c707c053550f2ce10000000a1553f7/frameset.htm

Hosted on Java instance:
Connect to following URL on any Java instance:

http://<servername>:5<instance>13/

To install the SAP Java MC locally:
Copy all files from following location to PC:

/usr/sap/<SID>/JC<instance>/exe/servicehttp/sapmc

Open the sapmc.html file in Internet Explorer

Starting and Stopping SAP Systems

Info taken from here:
http://help.sap.com/saphelp_nwpi71/helpdata/en/47/1d6feeff6e0d46e10000000a155369/content.htm

stopsap/startsap -t <task> -i <instance> -v <virtual host>

E.g. stopsap -t r3 -i DVEBGMS00 -v vserver1

(Quick form: startsap/stopsap <virtual host> to start all services on that particular virtual host)

Parameters

[-t | -task <task>] Specify task (see list below)
[-i | -instance <instance>] Specify SAP system instance (see list below)
[-v | -vhost "<virtual hostname="">[ <virtual hostname="">]*"] Specify virtual host names
[-c | -check] Check database and SAP instance status
[-h | -help] Display help
[-V | -VERSION] Display startsap script version
[-C | -checkVHost] Check virtual host name

Task List

check - Check status of database and SAP system instancesr3 | j2ee - Start or stop SAP instances only. You can use either r3 or j2ee, regardless if the instance to be started or stopped is an ABAP or Java instance.
db - Start or stop ABAP database only
jdb - Start or stop Java database only
all | <blank> - Start or stop database and SAP instance
startupsrv - Start or stop sapstartsrv program

SAP System Instance List

DVEBMGS<nn> - ABAP primary application server Instance
D<nn> - ABAP additional application server instance
ASCS<nn> - ABAP central services instance (ASCS instance)
SCS<nn> - Java central services instance (SCS instance)
J<nn> - Java application server instance
TRX<nn> - TREX instance
ERS<nn> - Enqueue replication server instance (ERS instance)
SMDA<nn> - Diagnostics agent instance
W<nn> - Web services instance
G<nn> - Gateway instance

Stopping Order

ABAP system:

1. Additional application server instances (if available)
2. Primary application server instance
3. ASCS instance (if available)
4. ERS instance for the ASCS instance (if available)
5. Database instance

Java system:

1. Application server instances
2. SCS instance
3. ERS instance for the SCS instance (if available)
4. Database instance

Dual-stack (ABAP+Java) system:

1. Additional application server instances (if available)
2. Primary application server instance
3. ASCS instance (if available)
4. SCS instance
5. ERS instance for the ASCS instance (if available)
6. ERS instance for the SCS instance (if available)
7. Database instance

Starting Order

ABAP system:

1. Database instance
2. ERS instance for the ASCS instance (if available)
3. ASCS instance (if available)
4. Primary application server instance
5. Additional application server instances (if available)

Java system:

1. Database instance
2. ERS instance for the SCS instance (if available)
3. SCS instance
4. Application server instances

Dual-stack (ABAP+Java) system:

1. Database instance
2. ERS instance for the SCS instance (if available)
3. ERS instance for the ASCS instance (if available)
4. SCS instance
5. ASCS instance (if available)
6. Primary application server instance
7. Additional application server instances (if available)

Ping SAP ICM

http://<server>:<port>/sap/public/icman/ping (doesn't require login)

http:// <server>:<port> /sap/bc/ping (requires login to the backend system)

VNC Server

The following has been tested on Solaris

To start a VNC Server process:

bash
export DISPLAY='hostname':10.0
export PATH=$PATH:/usr/X11/bin:/usr/openwin/bin
vncserver

To reset the VNC password:
vncpasswd

To start a new Xterm session in an existing VNC session:
hostname (to get the server name)
setenv DISPLAY <hostname result>:1
nohup /usr/openwin/bin/xterm &

SAP Web dispatcher

Starting SAP Web Dispatcher on Unix
Change to sapwebdisp folder, typically /usr/sap/<SID>/W<instance>/sapwebdisp
Enter command: nohup sapwebdisp pf=<profile file>.pfl &

Test Web Dispatcher
The admin URL is http://<server>:<port>/sap/admin
Log in as webadm

SAP Content Server Notes

SAP Content Server consists of a DB and Apache front end on Unix or an IIS service on Windows. Both components are started independently.

Starting SAP MaxDB
login as the Database Instance Owner (eg sqd<SID>)
dbmcli -u superdba,<password> –d <sid> db_online
(/sapdb/<SID>/db/pgm/dbmstart –d <db sid> might also work)
./sapdb/programs/bin/x_server start

Starting Apache2 and Content Server
Log in as <SID>cs
cd /usr/sap/<SID>/apache2/bin
apachectl start
It may take quite a while to start

Stopping Apace2 and Content Server
Log in as <SID>cs
cd /usr/sap/<SID>/apache2/bin
apachectl stop

Stopping SAP MaxDB
login as the Database Instance Owner (eg sqd<SID>)
/sapdb/<SID>/db/pgm/dbmstop –d <SID>
or
/sapdb/programs/bin/dbmcli –d <SID> –u DBM, <password> db_offline

MaxDB Status
/sapdb/programs/bin/dbmcli –d <SID> –u DBM, <password> db_state

Test Content Server Web Page
http://<server>:1090/sapcs (this always returns an "HTTP 400 Bad Request" page")

A better one is:
http://<server>:1090/ContentServer/ContentServer.dll?serverInfo

Test Apache Web Page
http://<server>:1090/ returns the page below:

Test Content Server From SAP
Transaction SE38
Enter program name RSCMST and click execute
Choose the repository and click execute

Click execute to run the tests

MDM Notes

Starting MDM:
startsap pf=/usr/sap/<sid>/SYS/profile/<mds profile>
startsap pf=/usr/sap/<sid>/SYS/profile/<mdis profile>

Stopping MDM:
sapcontrol -nr <mds instance> -function Stop
sapcontrol -nr <mdis instance> -function Stop

Testing MDM Catalogue:
http://<server>:<j2ee port>/SRM-MDM/SRM_MDM

Emergency SAP Portal login

Emergency SAP Portal log in procedure:
http://help.sap.com/saphelp_nw04s/helpdata/en/3a/4a0640d7b28f5ce10000000a155106/frameset.htm

Log in as <SID>adm
Navigate to /usr/sap/<SID>/JC<instance>/j2ee/configtool
Run Configtool
Navigate to Global server configuration -> Services -> com.sap.security.core.ume.service
Change field ume.superadmin.activated to TRUE
Change field ume.superadmin.password to a new password
(under CUA this may have to be set to blank in order to use the password from the backend UME system)

Save changes
Restart the Java instance

Log in as SAP* user. All other users will be locked out at this stage and they will be shown a warning on the Portal log in page.

When Portal config work is complete:
Change field ume.superadmin.activated back to FALSE
Restart Java instance

Maintenance Optimizer Notes

Note 1344564 - Maintenance Optimizer: Check system landscape


How to configure product system and technical system to run Maintenance Optimizer

Register SAP Java system in Solution Manager (SLD)

The following steps detail how to register an SAP Java system (version 7.1 or higher) in Solution Manager (SLD) without using Visual Administrator

Log into NetWeaver Administrator http://<host>:<port>/nwa

Navigate to Configuration Management -> Security -> Destinations

Create 2 (*) new destinations which point to the Solution Manager system:
SLD_Client - user ID supplied must have SAP_SLD_DATA_SUPPLIER role or better
SLD_DataSupplier - user ID supplied must have SAP_SLD_GUEST role or better

Click Home to return to previous NWA screen

Navigate to Configuration Management -> Infrastructure -> SLD Data Supplier Configuration

Click on Collect and Send Data

System data will now be in the Solution Manager's SLD. Check in http://<solman host>:<solman port>/sld and navigate to Technical Systems -> Web AS Java

To ensure it's also in SMSY run 'Landscape fetch' background job.

Info from here:
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90f7d52e-8637-2e10-5caf-950dd1a4a42c?QuickLink=index&overridelayout=true

(*) Following page suggests only the SLD_DataSupplier destination is required:
http://help.sap.com/saphelp_nw73/helpdata/en/48/b6847d96655295e10000000a42189b/content.htm

Trusted System Set-Up

Ensure an RFC connection from the remote system to the trusted system (and vice versa) exists
Ensure the RFC connection does not have 'Trusted System' option ticket

Run transaction SMT1 in remote system
Click Create
Enter the name of the RFC connection to the central system
Enter log in details
Save new entry

Run SMT1 in the central system to create connection to the remote system and repeat steps above

Run SM59
Change RFC connection so that the 'Trusted System' option is selected

Set SMSY to use data from SLD

Run transaction SMSY_SETUP

Known Problems With Support Packs

See SAP note 822379 - Known problems with Support Packages in SAP NW 7.0x AS ABAP

SAP SRM Catalogues HTTP HTTPS Switch

If access to the Portal is secured with HTTPS, opening catalogues can result in web page errors.

The inbound and outbound handlers needs to be bypassed in order to make the switch successful:

Run SPRO
Go to Supplier Relationship Management -> SRM Server -> Master Data -> Content Management -> Define External Web Services
Select the catalogue
Double click Standard Call Structure
Add the following:
Parameter = BYPASS_OUTB_HANDLER, Value = X, Type = Fixed value
Parameter = BYPASS_INB_HANDLER, Value = X, Type = Fixed value
Click Save

Updating and Repairing SLD

For updating the SLD refer to SAP note:
Note 669669 - Updating the SAP Component Repository in the SLD

For repairing the SLD refer to SAP note:
Note 1093168 - Repair of SLD CR content
Build the reference SLD using an import of data from the same model version and CR data version as the afflicted local productive SLD.
Run the CRRepair process to rebuild the sld/active SLD to a clean version of the data.

Testing connectivity to monitoring agent

saphostctrl.exe -host hostname -function GetComputerSystem

If this fails the port is probably closed.

Freespace in Oracle database

select tablespace_name, sum(bytes/1024/1024) from dba_free_space group by tablespace_name;

URL for web GUI

To access the web GUI use the following URL:

http://<server>:<port>/sap/bc/gui/sap/its/webgui/!

Some terminal commands

To pause the current session:

• ctl+z

To list paused sessions:

• jobs

To make the current session a foreground session:

• fg %<number in brackets from 'jobs'>

Create new Xterm session with scroll bars running in the background:

• xterm -sb &

SAP GUI installation check

To check the installation of the SAP GUI client version 7.10 and 7.20, run NWCheckWorkstation.exe (located in C:\Program Files\SAP\SapSetup\setup).

For previous versions of the GUI run "sapsetup.exe /check"

SRM URL

Standard URL to SAP SRM system:
http://<server>:<port>/sap/bc/gui/sap/its/bbpstart

SAP PI URL

To invoke the Runtime Work Bench:
http://<server>:<port>/rwb/

To invoke Integration Tools web page from ABAP:
SXMB_IFR

Find the volume group for a file system

In order to find the volume group that a filesystem is on:

df -g <file system>

Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/<filesystemname> 40.00 2.42 94% 541 1% /oracle/EXD

lslv <filesystem name>

VOLUME GROUP: cstdexdvg VG IDENTIFIER: 00c724b200004c000000011f1381fa92
VG STATE: active PP SIZE: 128 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 959 (122752 megabytes)
MAX LVs: 256 FREE PPs: 366 (46848 megabytes)
LVs: 6 USED PPs: 593 (75904 megabytes)
OPEN LVs: 6 QUORUM: 2 (Enabled)
TOTAL PVs: 1 VG DESCRIPTORS: 2
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 1 AUTO ON: yes
MAX PPs per VG: 32512
MAX PPs per PV: 1016 MAX PVs: 32
LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable

Run transaction in another user's session

To cause a transaction to run in another user's session:

• SE37
• Enter "TH_CREATE_FOREIGN_MODE"
• Execute
• Enter the client, username and transaction code you wish to run
• Execute

Note: You must be on the same application server as the user in order for this to work.

Microsoft App-V Commands

List virtual applications to which user has access:

• Open command prompt
• sftmime /query obj:app /short

 
To start a command prompt in a the same session that an application is running in:

• List applications as shown above
• sfttray.exe /exe cmd "<full application name>"

To start the Application Virtualisation Client MMC plug in:

• SFTCMC.MSC

How to create a text file printer in AIX/Unix

To create a printer in AIX/Unix which saves the spool to a text file:

• Create a file 'output.txt' in /dev
• Type: smit print
• Choose ‘Add a print queue’
• Choose ‘File’
• Choose ‘Other’
• Choose ‘Generic’
• Enter ‘output.txt’ as the file name
• Name the ASCII queue ‘textfile’
• Press enter

View computer/server shares

To view all of the shared resources provided by a PC or server using the DOS/command prompt, type the following:

• net view \\<host name>

Reading the Registry through DOS

To read the Windows registry through a DOS prompt (command prompt) see:

• reg /?

Cancel print jobs

To list the jobs for a printer:

• lpstat -W -o<printer name>

(The '-W' switch shows the job number in wide column format)

To cancel a job:

• cancel <spool number> <printer name>

To cancel all prints for a printer:

• qcan -X -P<printer name>

Helpful Unix links

Searchable index of man pages:
http://homepages.ed.ac.uk/unixhelp/index.html

IBM AIX command reference library:
http://publib.boulder.ibm.com/infocenter/pseries/v5r3/topic/com.ibm.aix.doc/doc/base/commandsreference.htm

Comprehensive PC info

To find out information about the local PC (CPU, RAM etc.) run:

• msinfo32
• (Can be found in: Accessories -> System Tools -> System Information)

Also running 'dxdiag' will allow the output of some useful information to a text file.

To delete the contents of a file in VI

To delete the contents of a file in Unix editor vi:

• When on the first line enter the command: dG
• Anywhere else in the file: :1,$d

To find a transport request

To find a transport request:

• Run transaction SE16
• Enter table name E070V

Definition of SAPS

The SAP Application Performance Standard (SAPS) is a hardware independent unit, which describes the performance of a system configuration in the SAP environment. It is derived from the SD Standard Application benchmark, where 100 SAPS are defined as 2,000 fully business processed order line items per hour.

In technical terms, this throughput is achieved by processing 6,000 dialog steps (screen changes), 2,000 postings per hour in the SD benchmark, or 2,400 SAP transactions.

Fully business processed in the SD Standard Application Benchmark means the full business process of an order line item: creating the order, creating a delivery note for this order, displaying the order, changing the delivery, posting a goods issue, listing orders, and creating an invoice.

(From here)

Oracle job scheduler

To view the current schedules:

• select * dba_scheduler_schedules;
  
  

Also:

• select * from dba_scheduler_jobs;

To view job run histories:

• select * from dba_scheduler_job_log;

See also SAP note 974781

Make the cancel print button active

By default the Cancel button in the print dialog is greyed out:

• Run regedit
• Go to: HKEY_CURRENT_USER\Software\SAP\SAPlpd\SAPLPD
• Add character string "EnableCancelButton"
• Enter value '1'

Change takes effect immediately

See SAP note 1449136

Creating and viewing memory snapshots in SAP

• Run transaction S_MEMORY_INSPECTOR

• To create a memory snapshot, enter /hmusa into the transaction field
• Message shown in status bar:

Compare SAP config between two systems

• Run transaction SCU0

Choose SAP Refernce IMG
Click Create

Choose Select activites
Click the green tick

Choose an area and click the green tick

Enter a description and choose and R/3 (RFC) connection

Click either Total comparison or Total comparison in background

Note: This process uses a lot of session memory, particularly from the extended memory area whether run in foregoround or background.

Running SQL statements in SAP (Oracle and DB2)

Oracle

Free-form statements:

• SE38
• Program name RSORADJV
• Execute

Using drop down menu options:

• SE38
• Program name RSORAVDV
• Execute

DB2

• Run transaction ST04
• Expand Diagnostics
• Double-click SQL Command Line

SAP Issues And How To Resolve Them

DB13 CheckDB – BRCONNECT errors with the following:

BR0301E SQL error -1031 at location BrDdartRead-1
ORA-01031: insufficient privileges

See SAP note:
Note 900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

Essentially:
Re-run SQL file sapdba_role.sql from \usr\sap\SID\SYS\exe\run





Long running BBP/SRM job BBP_GET_STATUS_2:

See SAP note:
Note 521857 - Selection parameters for BBP_GET_STATUS/BBP_GET_STATUS_2

In DB13 – Table tablename has no statistics:

See SAP note:

Essentially:
SQLPLUS> Alter table sapr3.tablename monitoring;