XMA: Changing the spooler collector for an XMA database cleanup or archive job

XMA: Changing the spooler collector for an XMA database cleanup or archive job

To change the name of the spooler collector used for an existing XMA database cleanup or archive job:

1. Edit the MACONF file and change the COLLECTOR value to the desired spooler collector name
 
2. Enter SQLCI and delete the existing collector information for any XMA auto-cleanup,  or auto-archive     job from the PARAMS table:
 
TACL> VOLUME $<Volume>.XYGATEMA                  ($<vol> = the disk volume where the XMA database is located)
TACL> XMA
TACL> XMA_DBVOLUME
 
    To delete the existing spooler collector value for the database auto-cleanup: 
 
TACL> SQLCI;DELETE FROM XMADAT.PARAMS WHERE PARAMVALUE = "$<col>.#CLEANDB" AND PARAMNAME = "SPOOLERLOC" AND SERVERCLASSTYPE = "HKEEPER";EXIT;
 
     (Where $<col> is the name of the collector that you want to change, e.g. $S)
 
     To delete the existing spooler collector value for the auto syslog queue cleanup:
 
TACL> SQLCI; DELETE FROM XMADAT.PARAMS WHERE PARAMVALUE = "$<col>.#CLEANSL" AND PARAMNAME = "SLSPOOLERLOC" and SERVERCLASSTYPE = "HKEEPER";EXIT;
  
     (Where $<col> is the name of the collector that you want to change, e.g. $S)
 
  To delete the existing spooler collector value for the auto archive:
 
TACL> SQLCI;DELETE FROM XMADAT.PARAMS WHERE PARAMVALUE = "$<col>.#ARCHIVE" AND PARAMNAME = "ARCHSPOOLERLOC" and SERVERCLASSTYPE = "ARCHIVE";EXIT
 
       (Where $<col> is the name of the collector that you want to change, e.g. $S)
 
Following the deletion of the existing spooler information from the PARAMS table, all cleanup and archive jobs will use the spooler collector name specified in the MACONF file.  
 
If you would like to write the new collector information to the PARAMS table, proceed with steps 3, 4 and 5.
 
  
3. Change the auto cleanup setup in XMA_MANAGER
 
    Example:
 
     a.  xma_manager
  
     b. Option 3, Database
 
     c. Option 4, Auto cleanup setup
 
     See:
 
      To modify any of the items below choose an option
       otherwise select R to continue:
 
     1:   Maximum age of data to be retained            :28
     2:   Cleanup program start time in HH:MM         :00:30   
     3:   Cleanup output spooler location                    :$S.#CLEANDB
     4:   Cleanup process priority                                :99
     X:   Exit
     R:   Run
 
     Selection ?
 
   Update all options that you wish to change, then option R to save.  Even if no options are changed, select option R to ensure that this information is written to the PARAMS table.
 
4. Change the Auto Cleanup Syslog Queue collector setting
 
     From the Database Management Menu, select option 15, Auto Cleanup Syslog Queue and proceed to
     change the desired options.  On completion select R to save.   Even if no options are changed, select  
     select option R to ensure that this information is written to the PARAMS table.
 
 5. Change the Auto Archive Setup collector setting
 
     This step is not necessary if you do not have any archive jobs
 
   From the Database Management Menu, select option 16, Auto Archive Setup and proceed to
   change the desired options.  On completion select R to save.  Even if no options are changed, select
   option R to ensure that this information is written to the PARAMS table.

If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.