AIX command for DBA

What do all those numbers mean on oslevel -s ?
first four numbers show the AIX base level. Next is the Technology Level (TL), followed by the number of the Service Pack (SP).

how to check if a fix is installed on aix

  server1:/home/aixuser> instfix -i | grep IV48087    
    All filesets for IV48087 were found.

lists installed software products (fileset)

  server1:/home/aixuser> lslpp -L | grep bos
  bos.64bit                 7.1.3.45    C     F    Base Operating System 64 bit
  bos.acct                  7.1.3.45    C     F    Accounting Services
  bos.adt.base              7.1.3.45    C     F    Base Application Development
  bos.adt.data               7.1.0.0    C     F    Base Application Development
  bos.adt.debug             7.1.3.45    C     F    Base Application Development
  .......

display physical volume 

 server1:/home/aixuser> lspv
hdisk0          00f754ed016d9c0a                    rootvg          active      
hdisk1          00f754ed07c6d35d                    rootvg          active       
hdisk2          none                                None                        
hdisk4          none                                None                        
hdisk5          none                                None                        
hdisk6          none                                None                        
hdisk7          none                                None                        
hdisk8          none                                None                        
hdisk9          none                                None                        
hdisk10         none                                None                        
hdisk11         none                                None                        
hdisk12         none                                None                        
hdiskpower0     00f754eddf167b65                    vg00            active      
hdiskpower1     00f754eddf1aa617                    vg00            active      
hdiskpower2     00f754eddf1ef78f                    vg00            active      
hdiskpower3     00f754eddf138e5a                    vg00            active      
hdiskpower4     00f754eddf17939e                    vg00            active

physical volume size

 server1:/home/aixuser> bootinfo  -s hdisk4
  153600

check reserve policy

 server1:/home/aixuser> lsattr -El hdisk10
PR_key_value   none               Reserve Device on open           True
clr_q          no                 Device CLEARS its Queue on error True
location                          Location Label                   True
lun_id         0x2000000000000    Logical Unit Number ID           False
lun_reset_spt  yes                FC Forced Open LUN               True
max_coalesce   0x100000           Maximum Coalesce Size            True
max_retries    5                  Maximum Number of Retries        True
max_transfer   0x100000           Maximum TRANSFER Size            True
node_name      0x50060160c1e0ac34 FC Node Name                     False
pvid           none               Physical volume identifier       False
q_err          yes                Use QERR bit                     True
q_type         simple             Queue TYPE                       True
queue_depth    32                 Queue DEPTH                      True
reassign_to    120                REASSIGN time out value          True
reserve_policy single_path        Reserve Device on open           True
rw_timeout     30                 READ/WRITE time out value        True
scsi_id        0xef               SCSI ID                          False
start_timeout  60                 START UNIT time out value        True
ww_name        0x5006016141e0ac34 FC World Wide Name               False

display EMC storage powerpath device

server1:/home/aixuser> powermt display dev=all
Pseudo name=hdiskpower0
CLARiiON ID=CK200081101044 [server1]
Logical device ID=60060160DF621A008601684F9981E511 [LUN 0]
state=alive; policy=CLAROpt; queued-IOs=0
Owner: default=SP A, current=SP A       Array failover mode: 3
==============================================================================
--------------- Host ---------------   - Stor -  -- I/O Path --   -- Stats ---
###  HW Path               I/O Paths    Interf.  Mode     State   Q-IOs Errors
==============================================================================
1 fscsi2                 hdisk8      SP A1    active   alive      0      0
0 fscsi0                 hdisk2      SP B1    active   alive      0      0

Pseudo name=hdiskpower1
CLARiiON ID=CK200081101044 [server1]
Logical device ID=60060160DF621A00F2B751709981E511 [LUN 2]
state=alive; policy=CLAROpt; queued-IOs=0
Owner: default=SP A, current=SP A       Array failover mode: 3
==============================================================================
--------------- Host ---------------   - Stor -  -- I/O Path --   -- Stats ---
###  HW Path               I/O Paths    Interf.  Mode     State   Q-IOs Errors
==============================================================================
1 fscsi2                 hdisk9      SP A1    active   alive      0      0
0 fscsi0                 hdisk4      SP B1    active   alive      0      0

................

disk  device

 server1:/home/aixuser> lsdev -Cc disk
hdisk0 Available 00-00-00 SAS Disk Drive
hdisk1 Available 00-00-00 SAS Disk Drive
hdisk2 Available 00-00-00 SAS Disk Drive
hdisk3 Available 00-00-00 SAS Disk Drive
hdisk4 Available 05-00-02 EMC CLARiiON FCP RAID 1/0 Disk
hdisk5 Available 05-00-02 EMC CLARiiON FCP RAID 1/0 Disk
hdisk6 Available 05-00-02 EMC CLARiiON FCP RAID 1/0 Disk
hdisk7 Available 06-00-02 EMC CLARiiON FCP RAID 1/0 Disk
hdisk8 Available 06-00-02 EMC CLARiiON FCP RAID 1/0 Disk
hdisk9 Available 06-00-02 EMC CLARiiON FCP RAID 1/0 Disk
hdiskpower0 Available 06-00-02 PowerPath Device
hdiskpower1 Available 06-00-02 PowerPath Device
hdiskpower2 Available 06-00-02 PowerPath Device

tape device

 server1:/home/aixuser> lsdev -Cc tape
rmt0 Available 00-00-00 SAS 4mm Tape Drive
rmt1 Available 07-00-02 Other FC SCSI Tape Drive
rmt2 Available 07-00-02 Other FC SCSI Tape Drive
rmt3 Available 07-00-02 Other FC SCSI Tape Drive
rmt4 Available 07-00-02 Other FC SCSI Tape Drive

how to check iocp configuration for oracle 12c installation
The resulting output should match the following example:

server1:/home/aixuser> lsdev -C | grep iocp
iocp0       Available               I/O Completion Ports