This directory contains an example of POST PROCESSING UDP to be used to perform database
maintenance on a target table. It should be called by the Business View
whose target table requires maintenance after a load. 

There are three files in this directory:
                                                                    
iwhdb2cl.bat -- this is really the only new udp.  It's only function    
                is to invoke the DB2 command line processor environment and run      
                a user-specified batch program in that environment.                  
                                                                        
iwhrunst.bat -- invoked by iwhdb2cl.bat.  This .bat runs DB2 RUNSTATS.  
                It is in response to a requirement by Carle Clinic to   
                be able to run RUNSTATS at the completion of a BV.      
                                                                        
iwhreorg.bat -- invoked by iwhdb2cl.bat.  This .bat runs DB2 REORG and  
                then RUNSTATS.                                          
                This is in response to a requirement from the VISWARE   
                forum for a UDP to reorganize indexes after a           
                populate request.                                       

See the comments included in these files for detail about their processing.

To use them as POST-PROCESSING UDPs, perform the following:

1- Copy the above three files in a directory of the agent site where the Business View run.
You may want to rename the sample files and tailor them to your environment.
2- Open the SChedule page of the Business View and press the Program button.
3- Fill the page with the full path of the iwhdb2cl.bat file (D;\iwh\bin\iwhdb2cl.bat 
if this is where the file has been copied). Select BAT in the top Radio buttons.
In Parameters, enter the full path of the bat file you will use (iwhrunst.bat, iwhreorg.bat
or the customized version you may have created).
4- Press OK and save the Business View.
                                                                       
