In my db2 database i am getting following message

ADM5502W The escalation of "1" locks on table "TTE .PE_REQUEST" to lock
intent "S" was successful.

Why it is escalated to table level lock when there is only 1 lock...?
If there is any problem if these message keeps coming ?

There are several reasons for lock escalation. One reason may be that the locklist parameter is running out of memory for additional row level locks. You might want to increase the size of the locklist to prevent escalation because of memory problems.

Another reason for escalation is if one application has more than a certain percentage of the locks in the locklist. This is controlled by the maxlocks parameter.

The message you got about getting "1" table level lock is not related to the number of other locks that may have caused the escalation.

Check the "Administration Guide: Performance" for more information on these parameters.