ERROR DESCRIPTION:                                               
Hints and Tips for XML extenders for DB2 for OS 390, version 7. 
Includes documentational changes.                                
LOCAL FIX:                                                       
1)The DB2 XML Extender requires the XML Toolkit to be installed  
  as a prerequisite.                                             
  You can obtain the XML Toolkit by ordering a tape(SMP/e        
  install or downloading from the following URL               
     http://www.ibm.com/servers/eserver/zseries/software/xml  
                                                  /download/  
  There are two download package options for XML Toolkit,     
   SMP/E and non-SMP/E.  Please see Info APAR II13454 or      
   additional details regarding the XML toolkit.                                                           
2) Please make sure to install XML toolkit ( 1.3 )            
   if you have applied UQ65515 to                             
   XML extenders .Failure to do so will result in             
most XML Extender Stored procedures (and UDFs )such as     
DB2XML.DXXENABLEDB , failing with                          
      CEE3501S The module IXM4C35 was not found            
while trying to  run the ENABLE SERVER function.           
If you do not have UQ65515 installed,  please make sure to 
install XML Toolkit 1.2.                                   
Failure to do so will result in message                    
           CEE3501S The module IXM4C33 was not found.      
XML extenders at PTF level UQ65515 will not work with XML  
Toolkit 1.4.           
3) Prior to running job DXXGPREP , verify that your WLM envt.   
   is set up.  Your WLM STEPLIB concatenation needs to contain: 
        hlq.SDXXLOAD  The XML Extender load library             
        hlq.SDSNLOAD  The DB2 load library                      
        hlq.SIXMMOD1  The XML Toolkit load library              
   or the libraries must be placed in some accessible           
   location, e.g., LPA.                                          
                                                               
4)  After applying UQ65515, you may find  that OPUT  
    for members DXXRDBR and DXXRDDS fail in job DXXGPREP         
    as they are missing. You can either ignore these message and 
    continue or request a modified DXXGPREP job by calling       
    XML extender for OS/390 Support Personnel.                   
5)  During the APPLY of UQ65515 you may receive condition code   
    4 due to some unresolved references. This is expected        
    and will not effect the execution of this product.           
    These unresolved references are:                             
                                                                 
         Module          Symbol                                  
                                                        
         DXXDSCL   @@STERM8                             
         DXXDSCLL  @@STERM8                             
         DXXDSDB   @@STERM8                             
         DXXENCL   @@STERM8                             
         DXXENCLL  @@STERM8                             
         DXXENDB   @@STERM8                             
         DXXEXTBL  @ST00016                             
6)  During the APPLY of UQ65515 you may also  receive   
    MSGGIM23913W with RC=8 even though the apply job    
    ends with RC=4. This is OK and you can proceed with 
    the APPLY.                                             
7)  The JCL for DXXGPREP  points to incorrect last node    
    names and currently reads as                           
      //TSOBATCH PROC DXXFQP=DXX,DB2LEV=DB2A               
      //STEP01  EXEC PGM=IKJEFT01,REGION=2048K,DYNAMNBR=20 
      //STEPLIB  DD DSN=&DB2LEV..DSNLOAD,DISP=SHR          
      //       DD DSN=&DB2LEV..TESTLIB,DISP=SHR            
      //DBRMLIB  DD DSN=&DXXFQP..DBRMLIB,DISP=SHR          
      //       DD DSN=&DB2LEV..DBRMLIB,DISP=SHR            
    This should read as                                    
     //STEPLIB  DD DSN=&DB2LEV..SDSNLOAD,DISP=SHR           
                                                              
       //        DD DSN=&DB2LEV..TESTLIB,DISP=SHR             
       //DBRMLIB  DD DSN=&DXXFQP..SDXXDBRM,DISP=SHR           
                                                              
       //         DD DSN=&DB2LEV..SDSNDBRM,DISP=SHR           
8)   The step , Put the DAD on HFS in job DXXGPREP currently  
     reads as                                                 
       //**************************************        
       //*Put the DAD on HFS                        
       //**************************************     
       //*                                          
       //GETOUT EXEC PGM=IKJEFT01                   
       //SYSPRINT DD SYSOUT=*                       
       //SYSTSPRT DD SYSOUT=*                       
       //SYSTSIN DD *                               
         MKDIR 'dxx/sample/dad'MODE(7,5,5)          
         OPUT 'DXX.JDB771X.ADXXDAD(DXXGCODA)' -     
         'getstart_xcollection.dad'          
      /*                                            
    This should read as                             
      //**************************************      
      //*Put the DAD on HFS                         
      //**************************************      
      //*                                           
      //GETOUT EXEC PGM=IKJEFT01                    
      //SYSPRINT DD SYSOUT=*                        
      //SYSTSPRT DD SYSOUT=*            
      //SYSTSIN DD *                                        
         MKDIR 'dxx/sample/dad'MODE(7,5,5)                   
         OPUT 'DXX.JDB771X.ADXXDAD(DXXGCODA)' -              
         'dxx/sample/dad/getstart_xcollection.dad            
       /*                                                    
9)  XML extenders for OS/390 no longer allows the usage of   
    keyword 'using' while specifying tablespace names during 
    enable server.                                           
      In the 'XML Extender Administration and Programming    
      manual, version 7 (SC26-9949-00), under Chapter 3:    
      'Preparing to use the XML Extender: Administration':       
     under the section: 'Tasks that the DXXGPREP job performs'  
     the topic: "Enables the Db2 system to XML specifying the   
     following options" must read as                            
      ENABLE_SERVER -a V71A wlm enivornment WLMENV1             
   There are other examples in the Admin and Programming        
   manual such as                                               
      dxxadm 'enable_server -a SUBSYS1 using tbspc1,tbspc2 wlm  
      environment  envir233' ASIS                               
      where the keyword "using" should not be used.         
10.   XML extenders requires that the maximum length of           
      subsystem name is 4 bytes.                                  
11.Additional Information regarding XML extenders can be found    
   in the redbook, DB2 for OS/390 and z/OS Powering the World's   
   e-business solutions, in the chapter XML and DB2 XML Extender  
      The URL ( which extends into the next 3 lines) is:          
          http://publib-b.boulder.ibm.com/Redbooks.nsf/           
          9445fa5b416f6e32852569ae0bb65f/096799d5da59             
         61d485256a060071debf?OpenDocument&Highlight=0            
    Book Number:SG24-6257                                      
12. The Latest version of the wizard can be downloaded from    
       http://www.ibm.com/software/data/db2/extenders/xmlext 
       downloads.html                                          

 
ERROR DESCRIPTION:                                              
HINTS AND TIPS FOR XMLTOOLKIT. ---XMLTOOLKIT IS A PRE-REQUISITE 
REQUIRED TO INSTALL DB2 XML EXTENDERS, VERSION 7                
(ADDITIONAL SEARCH WORDS : XML TK, 5655D4401,5740XYR06,HXML140, 
JDB771X)                                                        
LOCAL FIX:                                                      
1)The DB2 XML Extender requires the XML Toolkit to be installed 
  You can obtain the XML Toolkit by ordering a tape ( SMP/e      
  install) or download it from the following URL                 
     http://www.ibm.com/servers/eserver/zseries/software/xml     
     /download/                                                  
2) There are two download package options for XML Toolkit,SMP/E  
   (orderable and downloadable) and non-SMP/E(downloadable).     
3) IBM strongly recommends the SMP/E install option for DB2      
   XML toolkit. You can order the XML toolkit as a CBPDO  or     
   serverpac by calling 1-800-IBM-CALL.                          
4) DB2 XML extenders prior to PTF UQ65515 is dependent on        
   XML Toolkit V1R2 (FMID HXML120); DB2 XML EXTENDER          
   with PTF UQ65515 applied is dependent on XML toolkit       
   V1R3 (FMID HXML130). XML Extender with PTF UQ65515         
   applied WILL NOT function with XML TOOLKIT 1.4.            
   (FMID HXML140).                                            
5) Customers ordering XML toolkit as an SMP/e install version 
   will be sent releases 4,3 and 2. Instructions will be      
   provided to install different releases.                    
   The default Install procedure will install                 
   previous releases as well as the latest release,           
   if the prior releases were not installed.                
6) Customers who wish to do a non-SMP/e install for the XML 
   toolkit will see two files for the C++ parser.           
     . IXMC351B.tar (23.8M)                                 
     . IXMC351B-UW87032.tar (27.3MB).                       
   Customers will need to download the second file.         
   They should make sure to link edit the modules into      
   USERID.SIXMMOD1. Please refer to the information below   
      V1R3 XML PArser, C++ Edition:                         
        Edit the file USERID.HXML130.JCLIN. This job will   
      link edit the load modules in the [userid].AIXMMOD1    
      dataset into[userid].SIXMMOD1. Update the high level   
      qualifier on the dataset in the AIXMMOD1 and           
      SIXMMOD1 DD statements so that it reflects [userid]    
      instead of SYS1 (unless authorized to use SYS1         
      datasets).                                             
      Submit the JCL to link-edit the modules into           
      [userid].SIXMMOD1. Once this has successfully          
      completed you may erase the [userid].AIXMMOD1      
      file since it is no longer needed.