MustGather: OmniFind Text Search Server for Db2 for i

Before engaging support in a detailed investigation of the problem at hand, make sure that the most current PTFs are installed for OmniFind on your system.  Refer to the following URL to find the list of PTFs for their matching OmniFind version:

OmniFind Text Search Server PTF information

Note: All commands that are used to collect the documentation need to be run by a user with a *SECOFR User Class.

I. Problem Summary Information:

• What SYSPROC.SYSTS* Procedures were used (for example to create an Index) with what Options?
• What SQL Statements to search (CONTAINS, SCORE) an OmniFind Index are involved?
• What Jobs are affected?

• Install or Update QMGTOOLS by using this technote: MustGather: How to obtain and Install QMGTOOLS and keep it current
• Run this SYSSNAP (this command can take a while):

  QMGTOOLS/SYSSNAP OUTPUT(*IFS) LICLOGS(Y) QHST(Y) SRVDOCS(Y) IFSDIR('/tmp/OFMG')
  Please make a note of the filename created:
  e.g. Zip file created: /tmp/OFMG/MCEAS2L4_SYSSNAP_202108031514.zip

• STRQSH

  Within Qshell run:

• /QOpenSys/QIBM/ProdData/TextSearch/ofHealthCheck.sh -all -output /tmp/OFMG/OFHC-all.txt
  
  /QOpenSys/QIBM/ProdData/TextSearch/ofHealthCheck.sh -user -output /tmp/OFMG/OFHC-user.txt
  
  /QOpenSys/QIBM/ProdData/TextSearch/ofHealthCheck.sh -env -output /tmp/OFMG/OFHC-env.txt
  
  export -s QIBM_CCSID=1208
  
  ls -lRa /QOpenSys/QIBM/ProdData/TextSearch >/tmp/OFMG/OFls.txt
  
  db2 "select Table_Name, Number_Rows, System_Table_Name  from qsys2.systablestat where Table_Name
    LIKE 'QDBTS%' and Table_Schema='QSYS2'" >/tmp/OFMG/OFstagingtables.txt
  
  db2 "select Job_Name, Java_Home, User_Directory, Current_Heap_Size, Max_Heap_Size
     from qsys2.jvm_info where Job_name LIKE '%/QDBTS/%'" >/tmp/OFMG/OFJVM.txt
  

  F3 to exit Qshell

III. GATHERING an OmniFind Trace when the problem is re-createable

1. In the Job that is used to re-create the problem:

   ADDENVVAR ENVVAR(QIBM_OMFTRACE) VALUE('11 /tmp/OFMG/OFTrace.txt') LEVEL(*JOB)

   When Access Client Solutions - Run SQL Scripts is used to re-create the problem, that cl-command can be run with prefix CL:
   
2. Re-create the problem

3. DSPJOBLOG OUTPUT(*PRINT)

1. WRKJVMJOB JOB(QDBTS/*ALL)

2. Option 12 for each job found

V. Spool Data

DSPUSRPRF USRPRF(QDBTS) OUTPUT(*PRINT)

DSPUSRPRF USRPRF(<User using Omnifind>) OUTPUT(*PRINT)

DSPJOBLOG JOB(<Job where a problem occurred>) OUTPUT(*PRINT)

CRTSAVF QGPL/OFMGOBJ

SAVOBJ OBJ(SYSTXT*) LIB(QSYS2) DEV(*SAVF) OBJTYPE(*FILE) SAVF(QGPL/OFMGOBJ) DTACPR(*MEDIUM)

STRQSH

within Qshell run:

cd /QOpenSys/QIBM/ProdData/TextSearch

jar -cfM /tmp/OFMG/OFMGIFS.zip /tmp/OFMG/OF*.txt server*/log/* server*/bin/server.out
  server*/config/*.txt  server*/config/*.xml server*/config/*.properties server*/javacore*

SETASPGRP <myiasp>

STRQSH

export -s QIBM_CCSID=1208

ls -lRa /<myiasp>/QOpenSys/QIBM/ProdData/TextSearch >>/tmp/OFMG/OFls.txt

db2 "select Table_Name, Number_Rows, System_Table_Name  from qsys2.systablestat where Table_Name
  LIKE 'QDBTS%' and Table_Schema LIKE 'QSYS2%'" >>/tmp/OFMG/OFstagingtables.txt

CRTSAVF QGPL/OFMGOBJIAS

SAVOBJ OBJ(SYSTXT*) LIB(QSYS2<number of IASP e.g. 00033>) DEV(*SAVF) 
  OBJTYPE(*FILE) SAVF(QGPL/OFMGOBJIAS) DTACPR(*MEDIUM) ASPDEV(*CURASPGRP)

STRQSH

within Qshell run:

cd /<myiasp>/QOpenSys/QIBM/ProdData/TextSearch

jar -ufM /tmp/OFMG/OFMGIFS.zip server*/log/* server*/bin/server.out
  server*/config/*.txt  server*/config/*.xml server*/config/*.properties server*/javacore*

FTP2IBMCMD INPUT(*IFS) CASENBR(<your case number>) IFSFILE('/tmp/OFMG/*.zip')

FTP2IBMCMD INPUT(*SAVF) CASENBR(<your case number>) SAVEFILE(QGPL/OFMGOBJ)

when an IASP is involved:
FTP2IBMCMD INPUT(*SAVF) CASENBR(<your case number>) SAVEFILE(QGPL/OFMGOBJIAS)

RMVDIR DIR('/tmp/OFMG') SUBTREE(*ALL)

DLTF QGPL/OFMGOBJ*