XMA: running UPDATE STATISTICS on an empty table

• Related Articles

• 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: 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 ...

• 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: SYSLOGQ table is full - how to rebuild and resize the SYSLOGQ table

  The steps below can be used to rebuild and resize the SYSLOGQ and its associated index. Stop XMA pathway (Where $<vol> is the disk volume where XMA is installed) RUN $<vol>.XYGATEMA.XMA INSTALL XMA_PWSTOP Go to the XMA database location XMA_DBVOLUME ...

• XMA: AUDSESS table is full - how to rebuild and resize the AUDSESS table

  The steps below can be used to rebuild the AUDSESS table and its indexes. This process rebuilds the table and indexes and then reloads the old data, so nothing is lost. Initial sizing suggestions are provided and can be modified as needed. 1. Logon ...