Wednesday, June 27, 2012

Friday, May 18, 2012

SAP Sava Password in SAP Shortcut

Start --> Run --> CMD
Cd C:\Program Files\sap\FrontEnd\SAPgui
sapshcut –register

Start --> Run --> REGEDIT
HKEY_CURRENT_USER –> Software –> SAP –> SAPShortcut –> Security,
Change the variable Enable Password from 0 to 1.

Wednesday, April 11, 2012

Solution Manager aisuser


Maintain the OSS user using transaction AISUSER








sm37

/TMWFLOW/MO_UI_BASKET_AUTHORIZ
























Wednesday, February 1, 2012

Determining the Tablespace Type

db2 get snapshot for tablespaces on



 
To check information about the automatic extend and automatic storage status of all tablespaces, you can also use the following SQL statement:



db2 "SELECT SUBSTR(TBSP_NAME,1,10) AS TBSP_NAME, TBSP_TYPE, TBSP_CONTENT_TYPE, TBSP_USING_AUTO_STORAGE, TBSP_AUTO_RESIZE_ENABLED FROM TABLE(SNAP_GET_TBSP_V91('')) AS T"


A value of 1 in the columns TBSP_USING_AUTO_STORAGE and TBSP_AUTO_RESIZE_ENABLED indicates that the respective feature is enabled, 0 would indicate that it is not enabled.


 
To check if the database is enabled for automatic storage, use the following command:
db2 "get snapshot for database on "



 
 
 
 
 
 
 
To check if the tablespaces in your DB2 9.7 installation have the reclaimable storage attribute, use the following SQL statement:



db2 "SELECT varchar(tbsp_name, 30) as tbsp_name, tbsp_type, reclaimable_space_enabled FROM TABLE(MON_GET_TABLESPACE('',-2)) AS t"


A value of 1 in the reclaimable_space_enabled column would indicate that this tablespace has the reclaimable storage attribute.





Monday, January 16, 2012

Windows SAP Start and SAP stop script

================================================
Stop SAP Script
================================================



@echo off
echo *****************************************************************
echo +++ Stop SAP Time stamp: %date% %time% +++
REM ----------------------------------------------------------
REM Stop SAP Services
REM ----------------------------------------------------------
echo.
echo Stopping SAP Instance ...
echo.
D:\usr\sap\WPT\SYS\exe\uc\NTAMD64\stopsap.exe name=wpt nr=00 SAPDIAHOST=RAMANSAP
IF %ERRORLEVEL% NEQ 0 (
echo.
echo Stopping SAP Instance failed! Please inform system administrator.
echo. exit /B 1
)
net stop saposcol
IF %ERRORLEVEL% NEQ 0 (
echo.
echo Stopping SAP Instance failed! Please inform system administrator.
echo. exit /B 1
)
echo ----------------------------------------------------------
echo Stop DB2 DB
echo ----------------------------------------------------------
echo.
echo Stopping DB2 Database ...
echo.
net stop DB2WPT-0

IF %ERRORLEVEL% NEQ 0 (
echo.
echo Stopping DB2 Database failed! Please inform system administrator.
echo.
exit /B 1
)
echo.
echo -----------------------------------------------------------
echo finished
echo -----------------------------------------------------------




================================================
Start SAP Script
================================================

@echo off
echo ----------------------------------------------------------
echo Start DB2 DB
echo ----------------------------------------------------------
echo.
echo Starting DB2 Database ...
echo.
net start DB2WPT-0
IF %ERRORLEVEL% NEQ 0 (
echo.
echo Starting DB2 Database failed! Please inform system administrator.
echo.
exit /B 1
)
echo.
echo *****************************************************************
echo +++ Start SAP Time stamp: %date% %time% +++
REM ----------------------------------------------------------
REM Start SAP Services
REM ----------------------------------------------------------
echo.
echo Starting SAP Instance ...
echo.
D:\usr\sap\WPT\SYS\exe\uc\NTAMD64\startsap.exe name=wpt nr=00 SAPDIAHOST=RAMANSAP
IF %ERRORLEVEL% NEQ 0 (
echo.
echo Stopping SAP Instance failed! Please inform system administrator.
echo. exit /B 1
)

D:\usr\sap\WPT\SYS\exe\uc\NTAMD64\startsap.exe name=wpt nr=01 SAPDIAHOST=RAMANSAP

IF %ERRORLEVEL% NEQ 0 (
echo.
echo Stopping SAP Instance failed! Please inform system administrator.
echo. exit /B 1
)

net start saposcol
IF %ERRORLEVEL% NEQ 0 (
echo.
echo Stopping SAP Instance failed! Please inform system administrator.
echo. exit /B 1
)
echo -----------------------------------------------------------
echo finished
echo -----------------------------------------------------------

Wednesday, December 8, 2010

Print Architecture and Printing Methods 

Print Methods
1.Local printing 2.Remote printing (network) 3.Frontend Printing



1. After the user triggers the print process, the print requests are sent to the spool server, which contains the dialog and spool work processes required for the processing.
2. A dialog work process (D-WP) of the spool server forwards the spool data to the spool database for temporary storage.
3.When the data is explicitly sent to an output device, an output request is generated from the spool request. This is forwarded to the spool work process (S-WP).
4.The spool work process formats the output request data.
This converts an internal data stream of the SAP Systems to a data stream that the output device understands.
5. After formatting, the spool work process forwards the print request to the host spool system (operating system spooler). The host spool system has the following tasks:
Wait queue management
Transferring the data to the output device
Depending on the situation of the host spool system, one of the following print types is used:
local: The print requests are forwarded to the printer through a local network. The host spool system and the spool work process are on the same host.
It is irrelevant whether the output device is directly connected to the server, or whether it is defined using a remote print server.
remote: The print requests are forwarded from the spool work process to the printer through a remote network. The host spool system is on a different host to the spool work process. This remote host is called the target host.