Want to know some basic performance checks which should be done while coding the embeded SQL's.

Use the EXPLAIN YES option on the BIND command. This will populate the explain tables for static SQL (you have to make sure the explain tables are created if not already done so). Once the explain tables are populated, you can use the visual explain feature to analyze the access path of your SQL.

There are other explain options that can be used during the BIND process, so consult the manual for details. Make sure you use the option that does not create explain output during each program execution for any dynamic SQL (unless that is what is desired).