Monday 25 July 2011

WebDynpro Activation ABAP Stack

Hi Guys,

After long days , finally got some work to do :)

Activate below mentioned services using sicf

1. SICF
2. Activate Services for Web Dynpro ABAP
  
Using WDA Applications
    /default_host/sap/bc/webdynpro
 /default_host/sap/public/bc
 /default_host/sap/public/bc/ur
 /default_host/sap/public/bc/icons
 /default_host/sap/public/bc/icons_rtl
 /default_host/sap/public/bc/webicons
 /default_host/sap/public/bc/pictograms
 /default_host/sap/public/bc/webdynpro/* (ssr, mimes, etc.)
 /default_host/sap/public/myssocntl

Using the WDA Development Environment
 /default_host/sap/public/bc/webdynpro/viewdesigner
 /default_host/sap/bc/wdvd/
 /default_host/sap/bc/webdynpro/sap/configure_application
 /default_host/sap/bc/webdynpro/sap/configure_component
 /default_host/sap/bc/webdynpro/sap/wd_analyze_config_appl
 /default_host/sap/bc/webdynpro/sap/wd_analyze_config_comp
 /default_host/sap/bc/webdynpro/sap/wd_analyze_config_user


WDA Test Applications for Error Analysis
 /default_host/sap/bc/webdynpro/sap/WDR_TEST_EVENTS
 /default_host/sap/bc/webdynpro/sap/wdr_test_ui_elements
 /default_host/sap/bc/webdynpro/sap/WDR_TEST_TABLE
 /default_host/sap/bc/webdynpro/sap/WDR_TEST_ADOBE
 /default_host/sap/bc/webdynpro/sap/wdr_test_popups_rt




4.) IF your facing any error (FQDN)
Add the FQDN in local client .

Click Run -> enter drivers -> goto etc folder -> double click on hosts file -> open with note pad.
there u need to enter the host entries., like .. 192.....<server_address> <tab> <domain> <tab> <host>

5.) Still facing problem With DNS
Disable your VPN Connectivity

To Check the Webdynpro
Ask your ABAP team to do inital testing configuration ,
1.se80
2.Select webdynpro Comp/ intf
3.ZDemo
4.IVIEW
5.FirstView
6.Layout

Wednesday 6 July 2011

Configuring Logarchmeth1 in DB2 & TAKING OFFLINE BACKUP

O/S:- AIX 6.1 1.  Login as db2<sid>(ex db2qas)
2.  Start db2 with "db2start" command, if its not started.
3.  Connect to respective system via "db2 CONNECT to QAS".
4.  Give command "db2 UPDATE DB CFG FOR QAS USING LOGARCHMETH1 DISK:/DBbackup/QASbackup/LogBackup".
5.  It will now show the Confirmation message Like "DB2 Configuration Has been updated".
6.  Now its must to take offline backup of the database( db2 forces it as it will give message db backup pending).
7.  Now issue command "db2 connect reset".
8.  Stop db2 by "db2stop". -- not mandatory I am writing it because I did it this way
9.  Start db2 by "db2start".  -- not mandatory I am writing it because I did it that way
10. Issue offline backup command "db2 BACKUP DATABASE QAS TO "/DBbackup/QASbackup". --for backup to disk
      or
11. Issue offline backup command "db2 BACKUP DATABASE QAS TO "/dev/rmt0". --for backup to tape
After taking the offline backup you can work with your database normally.
ENJOY POWERPLAY!!!!!!!

Any quries , please contact sathyarthiss ...
satyarthivarun@gmail.com
 

Monday 4 July 2011

Cannot create Lock File) when run startsap

[root@ECCECQ2 ~]# tail -f /home/ecqadm/startsap_DVEBMGS12.log
Called command: /usr/sap/ECQ/SYS/exe/run/startsap start Starting Startup Agent sapstartsrv
-----------------------------
 Instance Service on host ECCECQ2 started
Starting SAP Instance DVEBMGS12
------------------------------
Cannot create Lock File. ("sapstart.sem" Permission denied)
(6662) Exiting with Return-Code -103. (Access permission denied)
 Startup of Instance failed

Solution:

1.) Check the all the file system used percentage
2.) This may cause bcoz of shared memory , just restart the application & OS
3.) sidadm user doesnt own the usr/sap/dir or the sapmnt dir
    (Change the ownership of the user:Group using chown command in unix )

I have faced this issue , while starting the apllication & i worked more than 5 hours to fix it , I hope given info will help you to fix the issue asap.

Tuesday 28 June 2011

sap competitors

SAP  at a glance

1. More than 35,000 customers, 120 countries
2. Claim #1 CRM market share leader
3. Built the client/server ERP market
4. Definite #1 ERP market share leader
5. Very impressive distribution/SCM
6. Several industry solutions
7. Netweaver, SQL and a chasm of technologies
8. Priced at the high end

Oracle at a glance

1. Over 37,000 application customers
2. Claim #1 CRM market share leader
3. #2 ERP market share leader
4. 30 year proven credibility
4. New SOA architecture
5. Deep software functionality
6. Outrageous flexibility
7. Technology is the Oracle stack
8. Priced at the high end

Microsoft at glance
1. Over 83,000 ERP customers
2. Strong SMB/mid-market solution
3. Very strong partner channel
4. Only sold through VAR channel
5. Multiple ERP products
6. ERP road map questionable
7. Solutions often vary by global region
8. MS/.Net/SQL technology
9. Low to moderately priced

Infor at glance
1. 3rd largest global ERP maker
2. Over 70,000 customers
3. Several different ERP systems
4. Vertically focused ERP solutions
5. Lean manufacturing capabilities
6. Complex and discrete manufacturing
7. Process manufacturing
8. Strong distribution and SCM
9. Low to moderately priced

Tier 1 Company
SAP
Oracle
Oracle eBusiness Suite
Oracle people soft
Microsoft Dynamics

Tier 2
sage
Infor
Epicor
Ross
Lawson
IFS

Tier 3
Baan
ABAS
Exact
Hansaworld
Syspro
Activant Solutions

Microsoft Dynamics ERP Product:

Microsoft Dynamics AX -  is a comprehensive ERP product that helps midsize and larger
organizations operate across multiple sites and countries. With a rich, flexible industry
foundation Microsoft Dynamics AX can standardize processes, provide visibility across your
business, and help simplify compliance

Microsoft Dynamics GP - Microsoft Dynamics GP offers flexible deployment options to connect
financial and operations processes, and provides fast access to relevant information using
familiar Microsoft tools

Microsoft Dynamics NAV - is an ERP product for midsize organizations that provides proven
industry-specific functionality relevant to your needs – even for the most highly specialized
industries and business processes.

Microsoft Dynamics SL - is an ERP product specialized to help project-driven midsize
organizations manage people, projects, and profitability

http://whatiserp.net/erp-report/erp-market-share-and-vendor-evaluation-2011/

Thursday 16 June 2011

Differences between SAP Netweaver EP and EPC

EP stands for Enterprise Portal – the well-known SAP Portal installation that includes all Portal components and functionality. EPC stands for Enterprise Portal - Core – is a leaner installation of the Portal that includes only the core Portal functionality without additional functionality such as Knowledge Management, Collaboration, etc

EP Core (EPC)This usage type contains the core portal capabilities that were available in the
former usage type EP. This new usage type provides more flexibility when
implementing a portal where the full enterprise portal capabilities, such as
knowledge management and collaboration, are not needed. It contains the
portal, Guided Procedures (GP), and Universal Worklist (UWL).

Enterprise Portal (EP)This usage type includes Knowledge management, Collaboration, Composite
Application Framework Core (CAF-Core), Visual Composer, Web Dynpro
extension, and .NET PDK.

Wednesday 15 June 2011

Aix Basic commands to work with SAP

Hi Guys,

I hope this basic AIX commands will help you work with sap.


ls -l -> listing directory & files
chmod -> Changing the directory or file permission(rwx)
chown -> changing the directory or file ownership
mkdir -> create directory
rmdir -> remove directory
touch -> create file
rm -> remove file

Note: use man page for more details about each command {man }

***************************************
ps -> Managing the process ( ps -ef | grep -i )
kill -> terminate the process (kill -9 )

******************************************************

To Display if the hardware is 32bit or 64bit
bootinfo -y

To see if you're running with a 32 bit or 64 bit kernel,
bootinfo -k

To identify the memory size:
lsattr -El sys0 -a realmem

To Display number of processor on system:
lscfg | grep proc

Displays the system name, nodename, version, machine ID.
uname -a

version, release, and maintenance level of AIX is running on my system
oselvel -r

To get ipaddress of my machine
ifconfig -a

*****************************************
Working with services:
lssrc -a
refresh
startsrc
stopsrc
*****************************************

Basic Logical volume command:

lsvg --> list volume group

lsvg --> Detail report of particule VG

lsvg -l --> list logical volume(lv) for particular vg

lslv --> Detail report of lv

lsvg -p --> Display the hardisk included in particular vg

lspv --> List all the physical disk

chfs -a size=+1G --> increase the file system


Cluster Basic :


Determine the cluster name and networks
/usr/es/sbin/cluster/utilities/cltopinfo

Cluster Service status

/usr/es/sbin/cluster/utilities/clshowsrv -v

/usr/es/sbin/cluster/utilities/cldump


To identify the volume group which comes under cluster

1.) smitty hacmp
2.) logical volume managment
3.) shared vg
4.) list shared vg

Tuesday 14 June 2011

To Reset Administrator Password through Config Tool

It may sometimes happen that a user enters the wrong password a number of times (by default, 3) and if that user is the administrator, then the administrator user is locked. This prevents all sorts of things happening. To unlock the administator, use the following process
You need to use the Config Tool and the process is:

1) Go to the Server Installed path i.e. usr\sap\\\J2EE\configtool\
2) Choose configtool.bat and start it.
3) Under Global Server Configuration, choose Services.
4) Find com.sap.security.core.ume.service, click it.
5) Under Global Properties, find ume.superadmin.activated
6) Set the Custom value to TRUE. Click on SET to apply the new value
7) Apart from that, you have to set another property i.e.
8) ume.superadmin.password, define some password.The password that you are defining is for SAP*. save the changes.
9) Restart the cluster / server. Issue the command stopsap to do so.
10) Log on to Portal with SAP* as user and the defined password.
11) Create a User with Super Administrator role.
12) Go back to Config Tool and set the Custom Value as default value i.e. FALSE. save the changes.
13) Restart the Server.

Incase if you deploy a Application i.e. a Webdynpro or PAR and the Admin Password is not configured properly or is locked then

1) Go to Config Tool.
2) Choose Secure Store, right click.
3) Choose Admin\Passowrd\Systemid\
4) Set the Password value, choose add and save.
5) Restart Server.

If you are able to logon to Visual Admin , You can create a new user and assign him administrator group or Reset password .

1) Go to the Server Installed path i.e. \usr\sap\\\j2ee\admin\go.bat Or in UNIX /usr/sap///j2ee/admin/go .
2) Choose go.bat / go and start it.
3) Under Cluster ->Server, choose Security Provider .
4) Select Tab 'Runtime' and Inner Tab 'User Management' , Click Create User .
5) And then assign to group Administrators .
6) No Need to restart J2EE engine , Open http://:/irj/portal .
7) Now you can User Administration Identity Management , Search for Administrator user and Unlock it . etc ....

Friday 10 June 2011

SAP LOGON SCREEN

How To Change LOGON Screen for ABAP stack?
Go To transaction SE 61
Set document class to general text
Put the name of the file like “z_logon_screen_info” and create the file
Now there will be a word document shown
Put the info of your company see the example below
@A8@ Name of Company

@KR@ SAP IDES 6.0 EHP4

@0S@ Clients Available On This System:
@01@ 800 – (you can put description of client)
@01@ 810 – (you can put description of client)
@01@ 811 - (you can put description of client)
@01@ 812 - (you can put description of client)

@0S@ Technical Details:
IP Address: x.x.x.x
System ID: xxx
System No: xx

@PO@ OS: Windows Server 2008
@PO@ DB: IBM DB2 9.7
For using different icons(likeA8,PO,0S used in example) you can run and execute report ‘RSTXICON’ in sa38 tcode.
For more info use OSS NOTE 205487

Save the file
Save active
Logoff and Logon
You will be able to see the customized logon screen
 
Thank you Sathyathisss for your valuable information
Enjoy ( POWER PLAY !...)

Thursday 9 June 2011

ST03N - User statistics Report

1.)STAD and/or ST03N will provide you with statistics when users have logged on, what transactions they  ran, how many memory that consumed and so on.


2.) Licensewise (=USMM) you may be after the 'valid from date' or when was the last-logon-date of a specific users. These are informations you can get in USMM and SUIM -> User -> By Logon Date and Password Change.

Monday 6 June 2011

SGen

1.) Use sgen once you installated new system.
2.) sgen improves the system performance .
3.)By using the SGEN function, the end user will never have to wait for compilation when using the  SAP system
3.)T-code sgen
4.)Select first option & select required component
5.)keep an eye on tablespace , some time it reaches 100%, it may lead to system hang.

Below link will help you to understand the sgen options:

http://help.sap.com/saphelp_sm32/helpdata/en/b1/52583c65399965e10000000a114084/content.htm

Wednesday 1 June 2011

Procedure for extending the File system in LINUX:



1.) #vgdisplay ( Identify the proper vg for particular File system )
2.) #PE (Check total number of free PE )
3.) #lvextend -L +1G <file system>
4.) #resize2fs <file system>
5.) df -h


use below link for LVM Baisc idea:
http://www.redhat.com/magazine/009jul05/features/lvm2/

Tuesday 31 May 2011

WebGui for SAP

1)verify if the ICM is working correctly. Transaction SMICM (ICM Monitor)
displays the central entry point to the ICM configuration and monitoring. After starting this
transaction, you will see the ICM status. Make sure it is running. Check the following ICM
parameters via Menu-> Goto -> Parameters ->Display:

icm/server_port_0 PROT=HTTP,PORT=8000(PORT Number can Varies )
icm/host_name_full server.full.domain

2)With transaction SICF and locate the
services by path
/sap/public/bc/its/mimes
/sap/bc/gui/sap/its/webgui
3)Activate the full path to these services
4)Browse to
http://server_name:icmport/sap/bc/gui/
sap/its/webgui/
and login to the
webgui.


Use Following transcation if you face any service error:
#SIAC_PUBLISH_ALL_INTERNAL (Transcation used to publish all the service )


For more Query Please refer sappandit

ITS WEBGUI Activation (Back End )



  1. Make sure Internet Communication Manager (ICM) is up and running. You can check it by calling transaction "SMICM". A window pops up where the ICMS status should be "Running" and show the green light.
  2. Make sure the Fully Qualified Domain Name is set up on the server. You can check it by calling transaction "RZ10" (Edit profiles). There should be an entry with "icm/host_name_full=mybackend.project.mycompany.intra"
  3. Set "INTERNAL" as the publishing site:
    Start transaction "SE80". In the top menu choose "Utilities(M)" --> "settings...". Right-click on the tab-arrow until you come to tab "Internet Transaction Server". Choose tab "Publish" inside and check mark "Integrated ITS".
  4. Start transaction "SE80". Choose "Internet Service" from the first drop down box located in the middle of the left side pane. Enter "SYSTEM" in the input field below and click the glasses-like button "display" next to it. You will see the ITS service SYSTEM and its components in a tree structure. Right click on "SYSTEM" in the tree and select "Publish" --> "Complete Service" to publish the service. Once the publishing is completed the system will issue a message "Object published successfully; site INTERNAL".
  5. Repeat the previous step with "SHUFFLER" and "WEBGUI" instead of "SYSTEM" to publish both, too.
  6. Set missing parameters:
    Execute transaction "SICF". Enter "Hierarchy Type" = "SERVICE ", then click on checkmark "execute (F8)". Now browse to "default-host" --> "sap" --> "bc" --> "gui" -->"sap" --> "its" --> "webgui". Right-click on it and choose "Display Service". Under tab "Service Data" inside chapter "Interactive Options" click on button "GUI Configuration". In the blank line, insert following parameter:
    Parameter Name: "~webgui_theme"
    Value: "sl"
  7. Clear cache:
    Execute transaction "SITSPMON". Select tab "Template and Mimes tab". Under tabs "Invalidate Template Caches" and "Invalidate MIME Cache", click on "System-wide"
  8. Test WebGUI:
    Execute transaction "SICF". Enter "Hierarchy Type" = "SERVICE", then click on checkmark "execute (F8)". Now browse to "default-host" --> "sap" --> "bc" --> "gui" -->"sap" --> "its" --> "webgui". Right-click on it and choose "Test Service".
    A browser window (Internet explorer) pops up with the URL "http://mybackend.project.mycompany.intra:8002/sap/bc/gui/sap/its/webgui?sap-client=100". It asks for username and password. Enter your credentials that you used for SAP-Logon. Then you should see a screen similar to the initial SAP-Logon screen: a screen titled "SAP Easy Access" with the SAP menu.

Error report :

"No switch to HTTPS occurred, so it is not secure to send a password" 

---> Use FQDN

DNS Not able to Report:

--> Add FQDN in local client
windows -->  window/system32/drivers/etc/hosts
Unix --> /etc/hosts


Thursday 26 May 2011

Tape Backup Reference

Below link give basic idea about taking Tape backup in unix platform.

http://baheyeldin.com/linux/using-tape-backup-on-linux-for-a-home-network.html


-->Aix you can use smitty 


BOTThe tape is positioned at the beginning of the first file.
EOTA tape operation has reached the physical End Of Tape.
EOFThe tape is positioned just after a filemark.
WR_PROTThe tape (or drive) is write-protected. For some drives this can also mean that the drive does not support writing on the current medium type.
ONLINEThe drive has a tape in place and ready for operation.
DR_OPENDoor is open. Depending on the type of drive, this usually means that the drive does not have a tape in place.
IM_REP_ENImmediate report mode. This bit is set if there are no guarantees that the data has been physically written to the tape when the write call returns. It is set to zero only when the driver does not buffer data and the drive is set not to buffer data.
SMThe tape is currently positioned at a setmark. DDS specific.
EODThe tape is positioned at the end of recorded data. DDS specific.
D_6250
D_1600
D_800
This "generic" status information reports the current density setting for 9-track 1/2 inch tape drives only.

Wednesday 18 May 2011

Extending the Expiry of License date:

Serveral tricks to be followed to change the expire date:

First Trick :

1. When you install IDES you can move forward your Windows datetime into the future date. eg : 01.01.2020 (22 years foward)
2. After you finished installation, then start SAP MMC for the first time in the future date.
3. Doing any kind of activities using SAP GUI, still in the future date
4. Stop SAP MMC
5. Restart your machine
6. Change your date to the correct date
7. Start SAP MMC again
8. Now, you have IDES for 22 years

Second Trick :

1. Move backward your computer date to installation date before start SAP MMC
2. In some case, this trick only work if you haven't start your SAP MMC after license is expired

If the first and second trick doesn't work, then you can try an illegal trick.

Third Trick.

1. Download "ZAPGUI" (Sap R3 License Keys Generator), you can download from p2p network. eg : eMule
2. open SAP GUI
3. Enter login using sap* or other super user
4. Open t-Code "SLICENSE"
5. Click "Install" button
6. Run ZAPGUI
7. Fill some field in ZAPGUI according to Installation information in SLICENSE
>> Customer Key = fill it with Hardware Key
>> Installation Number = Ints. Number
>> SID = SAP System
>> YYYYMMDD = 99991231
8. Click "Install" button in ZAPGUI
9. Copy license key on the Result Field
10. Paste into "Key" field on SLICENSE
11. Press enter to install new Crack License
12. Stop SAP MMC
13. Restart your Machine
14. Start SAP MMC

Now, you have 2 license, after the trial license is expired then automatically then second license will be active.

Tuesday 17 May 2011

RHEL Prerequsites for SAP Installation


Red Hat Enterprise Linux 5


1. File System     size(GB)

 /(Or all OS realted file system)  30
 /sapmnt      25
 /usr/sap     25
 /oracle      350
 /sapmedia            40

2. Swap space    40

3.Kernel Parameters
  Change the following parameters in  /etc/sysctl.conf
 Paramater Name

 kernel.msgmni 1024
 kernel.sem 1250 256000 100 1024
 vm.max_map_count 1000000
 kernel.shmmax   0
 kernel.shmall   5242880
Activate these settings with the command "sysctl -p".

5.Java needed to be  installed.
Required rpm for java to be installed  IBMJavaSDK-1.4.2-13.5
Download from ibm site ( create userid )

6.Services should be running  on RHEL 5.5
nfs,portmap

7.Root Access required
8.Utilities
zip utility in all Linux Hosts
FTP/SFTP utility in all Linux Hosts
X Window-Manager

Please Do read the following Notes before starting SAP installation on Linux platform:

Note 1048303 - Red Hat Enterprise Linux 5.x: Installation and upgrade
Note 171356 - SAP software on Linux: Essential information (import)
Note 941735 - SAP memory management for 64-bit Linux systems

Note 1172419 - Linux: Supported Java versions on the x86_64 platform
( IBMJava2-AMD64-142-SDK-1.4.2-13.8.x86_64.rpm )

Note 386605 - SAP Memory Management for Linux (32-bit)

Note 187864 - Linux: Locale Support on Linux

To resolve libxp.so.6 error , install XFree86-libs

http://rpm.pbone.net/index.php3/stat/4/idpl/2408420/dir/redhat_5.x/com/XFree86-libs-3.3.5-1.5.x.i386.rpm.html



if you get error in creating user for sap system
1.) check the log message
2.) oraadm -- password is wrong
3.) then rechange the password to master password
4.) click retry button

Oracle Pacth installation
stop all oracle process before patching
1.) unzip
2.) shutdown
3.) ./runinstaller

4.) startup upgrade
SQL> STARTUP UPGRADE
5.) run the script catetcrd.sql
SQL> @?/rdbms/admin/catupgrd.sql

if open migrate  error comes then stop the database and run the catupgrd.sql
then start the database stage by stage
1.)  STARTUP NOMOUNT (startup mount)
2.)  MOUNT (alter database mount )
3.)  OPEN THE DATABASE (alter database open)

then click on retry...

important notes:
OSS-note no. 0112891 (Last-Minute Infos about the IDES-Installation)
OSS-note no. 0039228 (Getting Started with IDES)
OSS-note no. 0043106 (IDES General Customer Information)

Default Users
Just as there is a default client, every installed R/3 System contains default users that have specific predefined authorizations
Client    User                         Default Password
000        SAP*                         06071992
000        DDIC                        19920706
001       SAP*                          06071992
001       DDIC                         19920706
066       EARLYWATCH                   SUPPORT
If You try to delete the user SAP* and DDIC, the password is reset to the password in the R/3 kernel, PASS. The users themselves are retained. This is constitutes a gap in security.
To overcome this we user to Restrict the login on USER SAP*. Through SAP Profile Management






Wednesday 11 May 2011

Oracle SAP Notes


980426 - Oracle 10.2 software installation on new operating system
871735 - Current Patch set for oracle 10.2.0 ( Prerequisties )
839187 - Applying patch oracle 10.2.0
169706 - Oracle

Get Hardware Information On Linux Using dmidecode Command

dmidecode command reads the system DMI table to display hardware and BIOS information of the server. Apart from getting current configuration of the system, you can also get information about maximum supported configuration of the system using dmidecode

DMI Types
DMI Type id will give information about a particular hardware component of your system. Following command with type id 4 will get the information about CPU of the system

# dmidecode -t 4# dmidecode 2.9
SMBIOS 2.3 present.

Handle 0x0400, DMI type 4, 35 bytes
Processor Information
        Socket Designation: Processor 1
        Type: Central Processor
        Family: Xeon
        Manufacturer: Intel
        ID: 29 0F 00 00 FF FB EB BF
        Signature: Type 0, Family 15, Model 2, Stepping 9
        Flags:
                FPU (Floating-point unit on-chip)
                VME (Virtual mode extension)
                DE (Debugging extension)
                PSE (Page size extension)
                TSC (Time stamp counter)
                MSR (Model specific registers)


Following are the different DMI types available


 Type   Information
 ----------------------------------------
          0   BIOS
          1   System
          2   Base Board
          3   Chassis
          4   Processor
          5   Memory Controller
          6   Memory Module
          7   Cache
          8   Port Connector
          9   System Slots
         10   On Board Devices
         11   OEM Strings
         12   System Configuration Options
         13   BIOS Language
         14   Group Associations
         15   System Event Log
         16   Physical Memory Array
         17   Memory Device
         18   32-bit Memory Error
         19   Memory Array Mapped Address
         20   Memory Device Mapped Address
         21   Built-in Pointing Device
         22   Portable Battery
         23   System Reset
         24   Hardware Security
         25   System Power Controls
         26   Voltage Probe
         27   Cooling Device
         28   Temperature Probe
         29   Electrical Current Probe
         30   Out-of-band Remote Access
         31   Boot Integrity Services
         32   System Boot
         33   64-bit Memory Error
         34   Management Device
         35   Management Device Component
         36   Management Device Threshold Data
         37   Memory Channel
         38   IPMI Device
         39   Power Supply

JRE Downloads

Saturday 7 May 2011

Table contain all Tcode

- TSTC table will contain all the Tcodes and
- TSTCT table will contain all the Tcodes with Texts.

Various Important SAP Basis T-Code
1)   SU01  User Maintainence
2)   SCC4  Client Overview ( Create , Quick Delete , Modify )
3)   SCC5  Deletes a client completely with tables & other factors
4)   SCCL  Local Client Copy
5)   SCC9  Remote Client Copy
6)   SCC3  Client Copy log Analysis
7)   DB02   Storage Management & Database Performance
8)   DB12  SAP Backup Logs
9)   DB14  Database Monitor
10) SM12  Lock Entries
11) SM21  System Logs
12) SM36  Background Job Scheduling
13) SM37  Background Job Monitoring
14) SM31  Table Maintenance
15) SM50  Process Overview
16) ST22    ABAP Dumps
17) ST02   Buffer Analysis
18) ST03   Workflow Analysis
19) RZ04   Operation Mode
20) SE09   Transport Organizer
21) SCC1  Copy as per Transport Request
22) STMS  Transport Management System

SAP Kernel upgrade in unix

1. Login as root

2. Make new backup directory
cd /
mkdir SIDkernel_<date>

3. Create latest kernel backup
cp -pr /sapmnt/SID/exe/* /SIDkernel_<date>

4. Compare the original kernel and the backup
du -sk /sapmnt/SID/exe
du -sk /SIDkernel_<date>

5. Make new directory
cd /
mkdir newkernel_<release>

6. Copy the new downloaded kernel files into /newkernel_<release>

7. Unpack the new downloaded kernel in folder /newkernel_<release>
SAPCAR -xvf SAPEXE_*.SAR
SAPCAR -xvf SAPEXEDB_*.SAR

8. Login as sidadm

9. Stop the SAP System
stopsap

10. Stop saposcol
saposcol -k

11. Login as root

12. Go to the current kernel directory
cd /sapmnt/SID/exe

13. Copy all extracted support packages into this folder
cp -pr /newkernel_<release>/* /sapmnt/SID/exe

14. Copy back the original file saproot.sh into this folder.
cp -p /SIDkernel_<date>/saproot.sh /sapmnt/SID/exe

15. Go to the current kernel directory
cd /sapmnt/SID/exe
Then run:
./saproot.sh SID

16. Login as sidadm

17. Start the saposcol service
saposcol

18. Start the SAP system
startsap

Sunday 1 May 2011

Sap Staus

To check the status of the sap system from OS ( Unix ) end.


1.) Login to server
2.) switch to su - sidadm
3.) startsap check 
or
4.) disp+work


startsap check gives clear picture of application running status & database status.

Sunday 24 April 2011

AIX QuickSheet

Filesystems
Default rootvg lesystems
hd1 - /home
hd2 - /usr
hd3 - /tmp
hd4 - /
hd5 - Boot logical volume
hd6 - paging space
hd8 - log device
hd9var - /var
hd10opt - /opt
Remove mount point entry
rmfs /mymount
Grow the
and the LV for /mymount(Add -r to remove mount point)/var lesystem by 1 Gig
chfs -a size=+1G /var
Grow the
/var lesystem to 1 Gig
chfs -a size=1G /var
Find the le usage on a lesystem
du -smx /
List lesystems in a
grep-able format
lsfs
Create a log device on
datavg VG
mklv -t jfs2log -y datalog1 datavg 1
Format the log device just created
logform /dev/datalog1
Format the log device associated with the fs on LV datalv1
logform /dev/datalv1


Kernel Tuning
no
is used in the following examples. vmo, no, nfso, ioo, raso, and
schedo
Reset all networking tunables to the default values
all use similar syntax.
no -D
List all networking tunables
(Changed values will be listed)
no -a
Set a tunable temporarily (until reboot)
no -o use isno=1
Set a tunable at next reboot
no -r -o use isno=1
Set current value of tunable as well as reboot
no -p -o use isno=1
List all settings, defaults, min, max, and next boot values
no -L
List all sys0 tunables
lsattr -El sys0
Change the maximum number of user processes to 2048
chdev -l sys0 -a maxuproc=2048
Check to see if SMT is enabled
smtctl

ODM
PdDv, PdAt, PdCn - Prede ned Databases
CuDv, CuAt, CuDep, CuDvDr, CuVPD - Customized Databases
Query CuDv for a speci c item
odmget -q name=hdisk0 CuDv
Query CuDv using the \like" syntax
odmget -q "name like hdisk?" CuDv
Query CuDv using a complex query
odmget -q "name like hdisk? and parent like vscsi?" CuDv

Devices
List all devices on a system
lsdev
Device states are: Unde ned; Supported Device, De ned; Not usable
(once seen), Available; Usable
List all disk devices on a system (Some other devices are: adapter,
driver, logical volume, processor)
lsdev -Cc disk
List all customized (existing) device classes (-P for complete list)
lsdev -C -r class
Remove hdisk5
rmdev -dl hdisk5
Get device address of hdisk1
getconf DISK DEVNAME hdisk1
or bootinfo -o hdisk1
Get the size (in MB) of hdisk1
getconf DISK SIZE hdisk1
or bootinfo -s hdisk1
Find the slot of a PCI Ethernet adapter
lsslot -c pci -l ent0
Find the (virtual) location of an Ethernet adapter
lscfg -l ent1
Find the location codes of all devices in the system
lscfg
List all MPIO paths for hdisk0
lspath -l hdisk0
Find the WWN of the fcs0 HBA adapter
lscfg -vl fcs0 | grep Network
Temporarily change console output to
swcons /console.out
/console.out(Use swcons to change back.)


Tasks
Change port type of (a 2Gb) HBA
(4Gb may use di
erent setting)
rmdev -d -l fcnet0
rmdev -d -l fscsi0
chdev -l fcs0 -a link type=pt2pt
cfgmgr
Mirroring rootvg to hdisk1
extendvg rootvg hdisk1
mirrorvg rootvg
bosboot -ad hdisk0
bosboot -ad hdisk1
bootlist -m normal hdisk0 hdisk1
Mount a CD ROM to /mnt
mount -rv cdrfs /dev/cd0 /mnt
Create a VG, LV, and FS, mirror, and create mirrored LV
mkvg -s 256 -y datavg hdisk1
(PP size is 1/4 Gig)
mklv -t jfs2log -y dataloglv datavg 1
logform /dev/dataloglv
mklv -t jfs2 -y data01lv datavg 8
(2 Gig LV)
crfs -v jfs2 -d data01lv -m /data01 -A yes
extendvg datavg hdisk2
mklvcopy dataloglv 2
(Note use of mirrorvg in next example)
mklvcopy data01lv 2
syncvg -v datavg
lsvg -l datavg
will now list 2 PPs for every LP
mklv -c 2 -t jfs2 -y data02lv datavg 8
(2 Gig LV)
crfs -v jfs2 -d data02lv -m /data02 -A yes
mount -a
Move a VG from hdisk1 to hdisk2
extendvg datavg hdisk2
mirrorvg datavg hdisk2
unmirrorvg datavg hdisk1
reducevg datavg hdisk1
Find the free space on PV hdisk1
lspv hdisk1
(Look for \FREE PPs")

Users and Groups
List all settings for root user in
grepable format
lsuser -f root
List
just the user names
lsuser -a id ALL | sed 's/ id.*$//'
Find the fsize value for user wfavorit
lsuser -a fsize wfavorit
Change the fsize value for user wfavorit
chuser fsize=-1 wfavorit

Networking
(
The examples here assume that the default TCP/IP con gurationrc.net) method is used. If the alternate method of using rc.bsdnet
is used then some of these examples may not apply.
Determine if
lsattr -El inet0 -a bootup option
rc.bsdnet is used over rc.net
TCP/IP related daemon startup script
/etc/rc.tcpip
To view the route table
netstat -r
To view the route table from the ODM DB
lsattr -EHl inet0 -a route
Temporarily add a default route
route add default 192.168.1.1
Temporarily add an address to an interface
ifconfig en0 192.168.1.2 netmask 255.255.255.0
Temporarily add an alias to an interface
ifconfig en0 192.168.1.3 netmask 255.255.255.0 alias
To permanently add an IP address to the en1 interface
chdev -l en1 -a netaddr=192.168.1.1 -a netmask=0xffffff00
Permanently add an alias to an interface
chdev -l en0 -a alias4=192.168.1.3,255.255.255.0
Remove a permanently added alias from an interface
chdev -l en0 -a delalias4=192.168.1.3,255.255.255.0
List ODM (next boot) IP con guration for interface
lsattr -El en0
Permanently set the hostname
chdev -l inet0 -a hostname=www.tablesace.net
Turn on routing by putting this in
no -o ipforwarding=1
rc.net
List networking devices
lsdev -Cc tcpip
List Network Interfaces
lsdev -Cc if
List attributes of inet0
lsattr -Ehl inet0
List (physical layer) attributes of ent0
lsattr -El ent0
List (networking layer) attributes of en0
lsattr -El en0
Speed is found through the ent
X device
lsattr -El ent0 -a media speed
Set the ent0 link to Gig full duplex
(
Auto Negotiation is another option)
chdev -l ent0 -a media speed=1000 Full Duplex -P
Turn o
Interface Speci c Network Options
no -p -o use isno=0
Get (long) statistics for the ent0 device (no -d is shorter)
entstat -d ent0
List all open, and in use TCP and UDP ports
netstat -anf inet
List all LISTENing TCP ports
netstat -na | grep LISTEN
Remove all TCP/IP con guration from a host
rmtcpip
IP packets can be captured using

Error Logging
Error logging is provided through:
Display the contents of the boot log
alog, errlog and syslog.
alog -o -t boot
Display the contents of the console log
alog -o -t console
List all log types that
alog knows
alog -L
Send a message to errlog
errlogger "Your message here"
Display the contents of the system error log
errpt
(Add -a or -A for varying levels of verbosity)
tions. S is software and H is hardware. Error types are (P)ermanent,
(T)emporary, (I)nformational, or (U)nknown. Error classes are
(H)ardware, (S)oftware, (O)perator, or (U)ndetermined.
Clear all errors up until
Errors listed from errpt can be limited by the -d S or -d H op-x days ago.
errclear
x
List info on error ID
FE2DEE00 (IDENTIFIER column in errpt output)
errpt -aDj FE2DEE00
Put a \tail" on the error log
errpt -c
List all errors that happened today
errpt -s `date +%m%d0000%y`
To list all errors on hdisk0
errpt -N hdisk0
To list details about the error log
/usr/lib/errdemon -l
To change the size of the error log to 2 MB
/usr/lib/errdemon -s 2097152
syslog.conf
line to send all messages to log le
*.debug /var/log/messages
syslog.conf
line to send all messages to error log
*.debug errlog
Error log messages can be redirected to the syslog using the errnotify
ODM class.


smitty FastPaths
Find a smitty FastPath by walking through the smitty screens to get
to the screen you wish. Then Hit F8. The dialog will tell you what
FastPath will get you to that screen. (F3 closes the dialog.)
lvm - LVM Menu
mkvg - Screen to create a VG
con gtcp - TCP/IP Con guration
eadap - Ethernet adapter section
fcsdd - Fibre Channel adapter section
chgsys - Change / Show characteristics of OS
users - Manage users (including ulimits)
devdrpci - PCI Hot Plug manger
etherchannel - EtherChannel / Port Aggregation

System Resource Controller
Start the xntpd service
startsrc -s xntpd
Stop the NFS related services
stopsrc -g nfs
Refresh the named service
refresh -s named
List all registered services on the system
lssrc -a
Show status of ctrmc subsystem
lssrc -l -s ctrmc

Working with Packages
List all les in bos.games leset.
lslpp -f bos.games
Find out what leset \fortune" belongs to.
lslpp -w /usr/games/fortune
List packages that are above the current OS level
oslevel -g
Find packages below a speci ed ML
oslevel -rl 5300-05
List recommended MLs
oslevel -rq
List installed MLs
instfix -i | grep AIX ML
List all lesets
lslpp -L
List all lesets in a
grepable or awkable format
lslpp -Lc
Find the package that contains the lemon utility
which fileset filemon
Install the database (from CD) for
installp -ac -d /dev/cd0 bos.content list
which fileset
Create a mksysb backup of the rootvg volume group
mksysb -i /mnt/server1.mksysb.`date +%m%d%y`
Cleanup after a failed install
installp -C


LVM
Put a PVID on a disk
chdev -l hdisk1 -a pv=yes
Remove a PVID from a disk
chdev -l hdisk1 -a pv=clear
List all PVs in a system (along) with VG membership
lspv
Create a VG called datavg using hdisk1 using 64 Meg PPs
mkvg -y datavg -s 64 hdisk1
Create a LV on (previous) datavg that is 1 Gig in size
mklv -t jfs2 -y datalv datavg 16
List all LVs on the datavg VG
lsvg -l datavg
List all PVs in the datavg VG
lsvg -p datavg
Take the datavg VG o ine
varyoffvg datavg
Remove the datavg VG from the ODM
exportvg datavg
Import the VG on hdisk5 as datavg
importvg -y datavg hdisk5
Vary-on the new datavg VG (can use
importvg -n)
varyonvg datavg
List all VGs (known to the ODM)
lsvg
List all VGs that are on line
lsvg -o
Check to see if underlying disk in datavg has grown in size
chvg -g datavg
Move a LV from one PV to another
migratepv -l datalv01 hdisk4 hdisk5
Delete a VG by removing all PVs with the
reducevg command.
reducevg hdisk3
(-d removes any LVs that may be on that PV)

Memory / Swap le
List size, summary, and paging activity by paging space
lsps -a
List summary of all paging space
lsps -s
List the total amount of physical RAM in system
lsattr -El sys0 -a realmem
Create a new paging device on rootvg of 64 PPs
mkps -a -s 64 -n rootvg

topas
Options
Make topas look like
topas -P
top
View statistics from other partitions
topas -C
View statistics for disk I/O
topas -D
Show statistics related to micro-partitions in Power5 environment
topas -L
All of the above commands are availible from within
topas

Performance Monitoring
Use
s0 entries for the best a nity and lesser a nity in the higher elds.
Get verbose disk stats for hdisk0 every 2 sec
mpstat -d to determine processor a nity on a system. Look for
iostat -D hdisk0 2
Get extended vmstat info every 2 seconds
while [ 1 ]; do vmstat -vs; sleep 2; clear; done
Get running CPU stats for system
mpstat 1
Get time based summary totals of network usage by process
netpmon
to start statistics gathering, trcstop to nish and summarize.

Getting info about the system
Find the version of AIX that is running
oslevel
List all attributes of system
getconf -a
Find the type of kernel loaded (use -a to get all options)
getconf KERNEL BITMODE
bootinfo and getconf can return much of the same information, getconf
returns more and has the
Find the level of rmware on a system
grepable -a option.
invscout
List all attributes for the kernel \device"
lsattr -El sys0
Print a \dump" of system information
prtconf

Display Error Codes
214,2C5,2C6,2C7,302,303,305 - Memory errors
152,287,289 - Power supply failure
447 - An error has occurred on an adapter
521 - init process has failed
551,552,554,555,556,557 - Corrupt LVM, rootvg, or JFS log
553 - inittab or /etc/environment corrupt
552,554,556 - Corrupt lesystem superblock
521 through 539 -
532,558 - Out of memory during boot process
518 - Failed to mount
cfgmgr (and ODM) related errors/var or /usr
615 - Failed to con g paging device
More information is availible in the \Diagnostic Information for Multiple
Bus Systems" manual

iptrace / ipreport or tcpdump