XMA:Update all statistics abends with error 1120

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 =_SQL_CAT_HEAP_LIMIT, CLASS MAP, FILE M128

Below are the steps to address the SQL Error -1120 from the XMA_SQLCOMPALL
1. Run the XMA_MANAGER macro to stop XMA Pathway via Pathway Menu option 3 (Stop).
2. Add the =_SQL_CAT_HEAP_LIMIT define
TACL> delete define =_SQL_CAT_HEAP_LIMIT
TACL> add define =_SQL_CAT_HEAP_LIMIT, CLASS MAP, FILE M128
3. Within the XMA_MANAGER macro, select Database Menu option 1 (Update Statistics)
Or run the XMA_SQLCOMPALL macro at TACL
4. Validate the output of the Update Statistics
5. Start the XMA Pathway via Pathway Menu option 2 (Cool Start)
6. Delete the =_SQL_CAT_HEAP_LIMIT define
TACL> delete define =_SQL_CAT_HEAP_LIMIT

Note:
SQLCAT has been changed to use a flat segment that can grow up to 1119MB in T9194ADU and later;
ADD DEFINE =_SQL_CAT_HEAP_LIMIT, CLASS MAP, FILE M1119.
Please don't set the heap size to any value greater than 1119, this will cause the DEFINE to be ignored.

    • Related Articles

    • 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: 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: XUA Mover abends when processing XUA protocol types

      Solution: Upgrade to XMA 2.45 or other Cause: XMA 2.43 and older could not properly extract protocol from XUA audits The issue is addressed in XMA Version 2.45 * ITID 245-13395 Update to Extract protocol type from XYGATE User Authentication (XUA) ...