XMA: Update Statistics Macro doesn't work when the XMA Tables are partitioned.

XMA: Update Statistics Macro doesn't work when the XMA Tables are partitioned.

Customer needs to execute the UPDATE STATISTICS by following the below steps. 

  •    VOLUME  <XMA VOLUME> (Ex., VOLUME $SYSTEM.XYGATEMA)
  •    RUN XMA 
  •    RUN NEWDEFS
  •    UPDATE ALL STATISTICS FOR TABLE =XMA_AUDSESSIONTBL  NO RECOMPILE PROBABILISTIC;
  •    UPDATE ALL STATISTICS FOR TABLE =XMA_AUDITDETAILTBL NO RECOMPILE PROBABILISTIC;
  •    UPDATE ALL STATISTICS FOR TABLE =XMA_SYSLOGQ        NO RECOMPILE PROBABILISTIC;

If you are unable to locate the solution needed or if you need additional assistance please Click Hereto open a case from our Customer Care Portal.



  

    • Related Articles

    • XMA:Update all statistics abends with error 1120

      Use the =_SQL_CAT_HEAP_LIMIT, FILE M<nnnn> define to enlarge the default amount of memory (16 MB) that SQLCAT reserves for these kinds of structures. For example, the following DEFINE allows the heap to grow to 128MB: TACL> ADD DEFINE ...

    • XMA: running UPDATE STATISTICS on an empty table

      UPDATE STATISTICS should be done at least there is one row or more in a table. However keep in mind that if you do update statistics on a small table you will need to update them frequently as the table grows in size to ensure you get efficient plans ...

    • XMA: XMA_MANAGER macro fails with [Check_SQLCompileNeeded] error

      The XMA SQL database needs to be recompiled for this error to be resolved. 1) stop XMA XMA_PWSTOP 2) Update the database statistics and re SQLCOMPILE all the XMA programs XMA_SQLCOMPALL 3) Start XMA XMA_PWCOOL If you are unable to locate the solution ...

    • XMA:Ways to address SQL error due to error 45 in AUDDET or AUDSESS

      Below are the Steps for ?Option 1? clean up the obsolete data records: Step: Option 1.0. Logon as an owner of XMA installation and install XMA macro at TACL Step: Option 1.1. Stop XMA Pathway by running the XMA_PWSTOP macro at TACL (or at the ...

    • XMA: SLSENDER is busy

      Use the XMA_SQLCOMPALL macro to generate a new optimized query plan, which will then be used when compiling the objects. TACL> VOLUME $SYSTEM.XYGATEMA TACL> RUN XMA INSTALL TACL> XMA_PWSTOP TACL> XMA_SQLCOMPALL TACL> XMA_PWCOOL The XMA_SQLCOMPALL ...