JSM services such as the PDFSpoolFileService require IBM Toolbox for Java or JTOpen.
JSM ships with Open Source Software JTOpen 9.6. Refer to trace file STDOUT.TXT for the current installed version.
IBM provides two JDBC drivers for the IBM i database:
Native JDBC driver
This is shipped as part of the IBM i Developer Kit for Java (57xxJV1).
It is implemented by making native method calls to the SQL CLI (Call Level Interface).
Consequently, it only runs on the IBM i JVM.
The class name to register is com.ibm.db2.jdbc.app.DB2Driver. The URL subprotocol is db2.
Toolbox JDBC driver
This is shipped as part of the IBM Toolbox for Java.
It is implemented by making direct socket connections to the database host server.
This JDBC driver runs on any JVM.
The class name to register is com.ibm.as400.access.AS400JDBCDriver. The URL subprotocol is as400.
Physical file journaling for JDBC updates
CRTJRNRCV JRNRCV(MYLIB/JDBC) TEXT('JDBC Journal Receiver')
CRTJRN JRN(MYLIB/JDBC) JRNRCV(MYLIB/JDBC) TEXT('JDBC Journal')
STRJRNPF FILE(MYLIB/MYFILE) JRN(MYLIB/JDBC) IMAGES(*BOTH)
It is easy to forget to start journaling when you create or change a physical file.
You can avoid such problems by creating a data area named QDFTJRN in any library where you want to automatically start journaling.
The new data area contains the name of a journal, and as long as the person creating the physical file has adequate authority, journaling will be started to the journal named in the data area.
You specify the journal library in the first 10 positions, and the second 10 positions contain the journal, and the last five positions contain *FILE. You can also specify *NONE in the last five positions to prevent journaling from starting.