How to ignore case sensitive search on DB2

using the upper or lower functions

Example:

db2 "select FIRSTNME from db2inst1.employee "

FIRSTNME   
------------  
Michael    
Sally          
Eva         
Delores    

db2 "select FIRSTNME from db2inst1.employee where upper(FIRSTNME) like 'EVA' "

FIRSTNME   
------------
EVA