Running the ejbdeploy command to generate deployment code is a required step in deploying enterprise beans. As part of the generation of deployment code, one or more SQLJ customization profiles will be created. You can then run the DB2® SQLJ profile customizer against the customization profiles to produce static SQL in the database.
Follow these steps:
For example: ejbdeploy in.ear tmp out.ear -sqlj -cp "C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;"
This generates a EAR file called out.ear and an Ant script called out.ear.xml.
There will be at least one customization profile for each EJB JAR file. It is located in one of the subdirectories below the websphere_deploy directory, for example FS_TopDown1_SJProfile0.ser.