In order to run an applet against our current database setup

You would need to set the authentication type to be SERVER 

 Currently it is set to CLIENT which means that the authentication

to the database defaults to the Operating System

However applets are not run from the clients but rather the server

You can run JDBC applets inside a web page on any system with a Java-enabled browser, regardless of the platform of your client. Your client system requires no additional software beyond this browser. The client and the server share the processing of JDBC and SQLJ applets and applications.

The DB2 JDBC Applet server and the DB2 server must reside on the same machine as the Web server.

When the applet requests a connection to a DB2 database, the JDBC client opens a TCP/IP connection to the DB2 JDBC Applet on the machine where the Web server is running.

REQUIREMENTS

WEB SERVER,JDBC DRIVER AND DB2 JDBC Applet SERVER on the same server

                |
                |
            Java Enabled Browser
                |
                |

The DB2 Universal JDBC driver archive is db2jcc.jar. In the .html file associated with the applet, change the archive from db2java.zip to db2jcc.jar. Copy db2jcc.jar to the web server

The DB2 Universal JDBC driver class name is com.ibm.db2.jcc.DB2Driver

The DB2 Universal JDBC driver client connects directly to the DB2 server so the server and portnumber are those of the DB2 server TCP/IP listener.

TESTING APPLET CODE

appletviewer <filename>.html