Latest Posts

AIX commands -Must needed for an engineer

//topas – show Server Status
topas

//netstat – View Networking
netstat -i

//iostat – Reports CPU Stats
iostat 5 10

//show java version
java -fullversion (show java version)

//search directory and subdirectories
grep -r text *

//display os and TL
oslevel -s

//Estimate the dump device size
sysdumpdev -e

//List system configuration
prtconf

//List processor assigned to Lpar
lscfg |grep proc |wc -l
lsdev -Cc processor

//View what the processors are doing
sar -P ALL 3 10

//Cut and Paste in AIX
left click and draw box around test control/insert to cut, shift/insert to paste

//lslpp – Lists installed software products
lslpp -L xlC.aix50.rte (shows version)
lslpp -L xlC.rte (shows version)

//Find and change all file, directory, and symbolic link ownership to new UID
find / -user old_uid -exec chown -h new_uid {} \;

//Create file that lists all files, folders, symbolic links with no ownership/old ownership
find / \( -fstype jfs -o -fstype jfs2 \) -nouser -print > /tmp/find_owner_script.txt

######################
Disk Commands
######################

//chfs – change filesystem attributes
chfs -a options=cio /file_path  (correct invalid argument errors)

//View all information about how an Hdisk is setup
lsattr-El hdisk###

//Test if data can be written to hdisk
dd if=/dev/hdisk0 of=/dev/null bs=512 count=1

//Test to see if you can communicate with the disk
lquerypv -h /dev/hdisk0   or lquerypv -h /dev/hdisk0 80 10

//View output information of specified hdisk
lqueryvg -Atp hdisk0

//Review VGDA status
readvgda hdisk0

//Verify if disk is available
lsdev -Cc disk

//Paging Command (perminent change)
vmo -p -o lru_file_repage=0  (Default is ‘1’, but if there is a problem with paging..set to ‘0’)

######################
Volume Group Commands
######################

//Synchronize logical volume copies that are not current (ie.. hd3)
syncvg -l hd3

//Redefine rootvg hdisk settings
redefinevg -d hdisk1 rootvg

//Extend hdisk into volume group
extendvg rootvg hdisk0

//Mirror logical volumes across hdisk
mirrorvg rootvg hdisk0

######################
Config/ODM Commands
######################

//show config of physical scsi adapter
lscfg -vl fcs0

//odm information
odmget -q name=inet0 CuAt
odmdelete -q “value=$info” -o CuAt
//Example
odmdelete -q “value=net,-hopcount,0,,0,192.168.0.1” -o CuAt

######################
Boot/Info Commands
######################

//Write boot information to hdisk
bosboot -ad /dev/hdisk0

//View current bootlist settings
bootlist -m normal -o

//Set bootlist order
bootlist -m normal hdisk0 hdisk1

//Show whether the hardware is in 32-bit or 64-bit
bootinfo -y

//Shows if the 64-bit kernel is active
bootinfo -K

//Shows which disk is bootable on the lpar
ipl_varyon -i

######################
Microcode Commands
######################

//View Microcode levels
lsmcode

######################
Fiber Channel Settings
######################

//Enable Dynamic Tracking
chdev -l fscsi0 -a dyntrk=yes

//View FC Settings
lsattr -El fscsi0

//Change FC Fabric Event Error “Recovery” Settings
chdev -a fc_err_recov=fast_fail -l fscsi0

//show Microcode level of the HBA
lsmcode -d fcs0

DATABASE CRASH WHEN IN BACKUPMODE OR SHUTDOWN ABORT

Recently had a DB crash and all the files were in backupmode. please follow below to start it up

1. Mount the database.
   SQL> STARTUP MOUNT
 



2. Find out which datafiles were in hot backup
   SQL> SELECT V1.FILE#, NAME
FROM V$BACKUP V1, V$DATAFILE V2
WHERE V1.STATUS = ‘ACTIVE’ AND V1.FILE# = V2.FILE#;


3. sql>alter database end backup


4. Open the database.

   SQL> ALTER DATABASE OPEN;
 
 
now try doing a shutdown immediate and a startup and confirm if DB comes up fine

 

Different Types of Users in SAP

Different Types of Users in SAP

1. Dialogue
2. System
3. Communication
4. Service
5. Reference
1. Dialogue:-
GUI login is possible.
Initial password and expiration of password are checked.
Multi GUI logins are checked.
Usage:- These are used for GUI logins.

2. System

GUI login is not possible.
Initial password and expiration of password are not checked.
Usage:- These are used for internal use in system like background jobs.

3. Communication
For this kind of users:-
GUI login is not possible.
Users are allowed to change password through some software in middle tier.
Usage:- These are used for login to system through external systems like web application

4. Service
For this kind of users:-
GUI login is possible.
Initial password and expiration of password are not checked.
Multiple logins are allowed.
Users are not allowed to change the password. Only admin can change the password
Usage:- These are used for anonymous users. This type of users should be given minimum authorization.
5. Reference
For this kind of users:-
GUI login is not possible.
Initial password and expiration of password are not checked.
Usage:- These are special kind of users which are used to give authorization to other users.

How to Change default SAP IMAGE on home screen

How to Change  default SAP IMAGE on home screen

  • Transaction code – SMW0
  • X – Binary data for WebRFC application
  • Hit Enter
  • Click Execute
  • Click Settings -> Maintain MIME types
  • Click the Create button
  • Fill in :- TYPE : image/gif EXTENSION : .GIF
  • Click Save
  • Click Back to the Binary data for WebRFC
  • Click Create
  • Fill in :- Obj. name : ZXXXX.GIF Description :
  • Company Logo
  • Click Import and specify the filename where your
  • GIF file is
  • located.File type is BIN. Finish press the
  • Transfer button.
  • If successful, your logo will be shown in the
  • Binary data for
  • WebRFC.
  • Transaction code SM30 – Table/View – SSM_CUST
  • Click Maintain
  • Click New Entries
  • Name Value to be set
  • START_IMAGE ZXXXX.GIF
  • RESIZE_IMAGE NO
  • Logoff and Login again

Procedure to reset TMSADM User

Procedure to reset TMSADM User

 

If you want to reset user TMSADM to the default, or if the configuration of this user was damaged, then:
1. Log on to the SAP system where you want to reset the TMSADM user. Call transaction STMS. Choose Overview > Systems. The system overview appears. Choose Extras > Reset User TMSADM. The system user TMSADM is regenerated with the default authorizations.

SE10,SE09,SE01 explained

SE10,SE09,SE01 explained

SE09 is the transaction code for workbench organizer. Workbench organizer is the set of utilities for development change management. All Development changes are tracked via Workbench organizer.

SE10 is for Customizing organizer. Customizing organizer is the set of tools for customizing change management. All customizing changes are tracked via customizing organizer.
SE01 is the main screen of the Change and transport Organizer. From here the administrator can achieve all tasks related to transport requests – such as create, change, view logs, display client/delivery transports,

Find the list of Tcodes executed by a user for a specific time period

Find the list of Tcodes executed by a user for a specific  time period

  • Go to ST03. Select choose for analysis. Choose only one application server at a time in case you have multiple application servers. Choose time period of your choice.
  • In the next screen from menu choose GO TO–>PROFILES->-USER PROFILES. Here you will get the list on users who have worked on that application server.
  • Double click on the required user and you will get all the transactions he/she has executed.
  • In case you select TOTAL in step 1 and then follow the steps 2 and 3 you will only get the list of application server on which the user has worked and not the transaction details.