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;