Testing the XML schema repository setup

After you set up the XML schema repository, perform some tests to ensure that it is operating correctly. You need to test whether the WLM environment, the Java™ stored procedure environment, and the XML schema repository stored procedures are working correctly.

Procedure

To test the XML schema repository setup:

Run installation job DSNTIJRV.

The following JCL uses program DSNTRVFY to check the XSR stored procedures:

//DSNTJVFY EXEC PGM=DSNTRVFY,
//         PARM='DB2SSN(DSN) ROUTINE(DD:SYSIN)'
//DBRMLIB  DD DSN=DSND10.SDSNDBRM,DISP=SHR
//SYSUT1   DD UNIT=SYSDA,SPACE=(32000,(30,30)),DCB=(RECFM=VB,LRECL=133)
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
  SYSPROC.XSR_REGISTER
  SYSPROC.XSR_ADDSCHEMADOC
  SYSPROC.XSR_COMPLETE
  SYSPROC.XSR_REMOVE

In this example, the PARM passed to program DSNTRVFY directs it to verify the routines specified in ddname SYSIN.

In order to test your XML schema repository, job DSNTIJRV might generate error SQLCODEs in WLM task logs and trace records that can be ignored. Examine the ddname SYSPRINT summary reported by message DSNT040I to determine whether your XML schema repository is successfully set up. Reasons for failures can also be found in ddname SYSPRINT.