JdV's Notes

Go to www.jdvnotes.info

To repeat every 2 seconds (default): watch <command> To repeat every X seconds: watch -n <X> <command>

Find the existence of a value in an Excel spreadsheet =IF(ISERROR(VLOOKUP(<input cell>,<page>!<col>:<col>, 1, FALSE...

Search for transport request in table E070CREATE

Connect to remote DB dbmcli -d <SID> -n <server name> -u <username>,<password> Switch to log overwrite mode dbmcli...

Go to http://<server>:<port>/urlapi_app_manager Create new Application ID Go to http://<server>:<port>/sap/url/go/...

Change System User's Password ALTER DATABASE <DB> SYSTEM USER PASSWORD <new password> Log Into HANA Database hdbsql ...

To display all the available standard icons Transaction ICON Note the icon's name (e.g. ICON_POSITIVE) To find the allocated 2...

SAP SCN Pages http://scn.sap.com/docs/DOC-8616 Transaction SPUMG - Unicode Preconversion 1051576 - Conversion of Single Code Page Syst...

Browse table AGR_1251 to see roles in the system Browse table AGR_USERS to see users assigned to roles

R3load 455195 - R3load: Use of TSK files 1970577 - (TSK) ERROR / / .TSK.bck already seems to exist

Add items to download basked on SAP net. Login to Solution Manager system Run SE37 Enter:  /TMWFLOW/MO_UI_BASKET_AUTHORIZ Press F8 Leav...

Assuming the SAP system is shut down! To list semaphores and event flags cleanipc To remove leftover semaphores and event flags clean...

SAP note 1394553 - EH&S WWI server installation instructions Transactions: CGSADM - Administer connections CG5Z - WWI monitor (make ...

To adjust the content of a stack.xml file to change the system name: Run transaction SE38 Enter program name RPT_MOPZ_COPY_STACK_XML Se...

If the db2vend process needs to be restarted using "kill -9 <PID>" could crash the database. IBM's recommendation is t...

To temporarily map a drive in the Windows command prompt (DOS): pushd \\server\folder The current directory changes to the mapped drive....

SAP Host Agent Troubleshooting: http://scn.sap.com/docs/DOC-34217 1862333 - Common Host Agent issues displayed in Agent Administration...

To make changes to an RFC entry which isn't editable follow the steps below: Run transaction SM59 Double-click on the appropriate RF...

Run transaction SOLMAN_WORKCENTER Click on the  Root Cause Analysis  page tab Click on the  Host Analysis  link Filter the...

Run transaction SOLMAN_WORKCENTER Click on the Technical Monitoring page tab Click on the System Monitoring link Click on the...

To find the startup time of an Oracle database: SELECT to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time" ...

If the user ID Administrator or J2EE_ADMIN is locked or the password is forgotten the system can be accessed using the following method: ...

The following transactions are useful for configuring BW/BI connections RSMO - Monitor InfoPackages RSADMIN - Set various parameters i...

Open command prompt Enter following command: netsh wlan show networks bssid

To change the TMSADM password used in STMS (or Charm): Log on to the transport domain controller in client 000 Run SE38 Enter program n...

Transaction SE16 Table: CDHDR Search for the user and/or date the change was made Copy the contents of the 'Object value' field ...

Manually Add Transport To a SAP Import Queue tp addtobuffer <Transport> <SID> client=<Client no.> pf=<Path to transpo...

At command line: db2 connect update sapsr3.usr02 set uflag=0 where mandt='<client>' and bname='<username>' ...

As db2<sid>: Got to dir /db2/db2<sid>/sqllib Modify db2nodes.cfg file to show: 0 <servername> 0 As root: cd /db2/db2...

Find machine serial number of frame which hosts an LPAR: Log into the LPAR prtconf | more

Run SE16 Enter table name TPFHT Press F8 or click Execute The generation date should indicate when the profiles were initially created.

This is how to find the version of the C++ library files on AIX:  lslpp -L | grep xlC

Check Database Connection Run transaction DB59 Execute connection tests from all servers Retrieve Document Run transaction CV01N Sea...

To navigate directly to the Solution Manager diagnostic agent administration page in Solution Manager the following URL can be used: http:/...

SAP Host Agent URL: http://<server name>:5<inst>13/SAPHostAgent/?wsdl SAP Host Control URL: http://<server name>:112...

To find out what process/executable is using a port on AIX: lsof -i :1527 COMMAND      PID   USER   FD   TYPE             DEVICE SIZE/O...

/usr/sap/<SID>/wily/bin ./EMCtrl.sh (start|stop|help) status     - status of the Enterprise Manager start      - start Enterprise...

See SAP note  83819 - DB6: Collecting support data As <SID>adm or db2<SID>: db2support <work_dir> -d <dbsid> -c ...

To find the uptime of a Windows server without uptime.exe: Open a command prompt Type "net statistics server" The line that ...

Log In To DB2 As a Specific User db2 CONNECT TO <database> USER <user ID> USING <password> To bring a database o...

Wily Introscope Help: https://service.sap.com/~sapdownload/011000358700001995842008E/SAPISDOC02_0.pdf Default URL: http://<server n...

Switch to 'root' User in SUDO Type: sudo su - Prompt should change to reflect the fact you're now logged in as root. If t...

How To Register a Content Server/SAP MaxDB in LMDB/SMSY (Info taken from SAP note 1794004) Assume Solution Manager Diagnostic agent and ...

To Suspend All Currently Released SAP Background Jobs Run SE38 Enter program name BTCTRNS1 Click Execute This program has no selection...

To produce an example document from within SAP GUI to test the connection to Adobe Document Services (ADS): Run SE38 Enter program name F...

Centrally administer SAP printers for a whole landscape with transaction PAL. Requires RFCs to target systems SAP doc on setting up PAL ...

 If the SAP system/Oracle database is 'stuck' due to lack of space in the oraarch folder, the archive log destination can be dynamic...

If there are no trace files in /oracle/<SID>/saptrace the configure destination may be different. To find the configured destination:...

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

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 aro...

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

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

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

The following has been tested on Solaris To start a VNC Server process: bash export DISPLAY='hostname':10.0 export PATH=$PATH...

Starting SAP Web Dispatcher on Unix Change to sapwebdisp folder, typically /usr/sap/<SID>/W<instance>/sapwebdisp Enter command...

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 MDM: startsap pf=/usr/sap/<sid>/SYS/profile/<mds profile> startsap pf=/usr/sap/<sid>/SYS/profile/<mdis profi...

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

Note 1344564 - Maintenance Optimizer: Check system landscape How to configure product system and technical system to run Maintenance Opti...

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

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

Run transaction SMSY_SETUP

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

If access to the Portal is secured with HTTPS, opening catalogues can result in web page errors. The inbound and outbound handlers needs t...

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...

saphostctrl.exe -host hostname -function GetComputerSystem If this fails the port is probably closed.

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

To access the web GUI use the following URL: http://<server>:<port>/sap/bc/gui/sap/its/webgui/!

To pause the current session: ctl+z To list paused sessions: jobs To make the current session a foreground session: fg %<number in bra...

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\...

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

To invoke the Runtime Work Bench: http://<server>:<port>/rwb/ To invoke Integration Tools web page from ABAP: SXMB_IFR

In order to find the volume group that a filesystem is on: df -g <file system> Filesystem GB blocks Free %Used Iused %Iused Mounte...

To cause a transaction to run in another user's session: SE37 Enter "TH_CREATE_FOREIGN_MODE" Execute Enter the client, use...

List virtual applications to which user has access: Open command prompt sftmime /query obj:app /short   To start a command prompt in a...

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 ...

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...

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

To list the jobs for a printer: lpstat -W -o<printer name> (The '-W' switch shows the job number in wide column format) To...

Searchable index of man pages: http://homepages.ed.ac.uk/unixhelp/index.html IBM AIX command reference library: http://publib.boulder.ib...

To find out information about the local PC (CPU, RAM etc.) run: msinfo32 (Can be found in: Accessories -> System Tools -> System Inf...

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: Run transaction SE16 Enter table name E070V

The SAP Application Performance Standard (SAPS) is a hardware independent unit, which describes the performance of a system configuration in...

To view the current schedules: select * dba_scheduler_schedules; Also: select * from dba_scheduler_jobs; To view job run histories: ...

By default the Cancel button in the print dialog is greyed out: Run regedit Go to: HKEY_CURRENT_USER\Software\SAP\SAPlpd\SAPLPD Add char...

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

Run transaction SCU0 Choose SAP Refernce IMG Click Create Choose Select activites Click the green tick Choose an area and click ...

Oracle Free-form statements: SE38 Program name RSORADJV Execute Using drop down menu options: SE38 Program name RSORAVDV ...

DB13 CheckDB – BRCONNECT errors with the following: BR0301E SQL error -1031 at location BrDdartRead-1 ORA-01031: insufficient privileges See...