grails - DB2 Before Update Trigger Behavior -

wondering if can me understand how db2 before insert trigger behaves. have grails app inserts rows db2 database. table in question has before insert trigger updates date , user update:

create trigger wtestp.scsma11i no cascade before insert on  wtestp.scsma01t referencing new newrow each row mode  db2sql begin atomic set newrow.lst_updt_tmsp =  current_timestamp ; set newrow.user_id = rtrim ( user ) ; end ; 

in grails application set values, including user id:

flatadjustmentinstance.setuserid("ts37813") 

we use generic application id , password via jndi make connection database. auditing purposes need set value of user whomever logged application. solution remove trigger entirely , sure set?

the db2 user variable (also called "special register") contains authorization id of current database connection. if application wishes pass user id db2, can calling api function sqleseti() or stored procedure wlm_set_client_info() -- more info here. trigger can reference special register, current client_userid.