XMA: how to resize DETSEIND

XMA: how to resize DETSEIND

To resize DETSEIND,
  1. Turn on the screen capture.
 
  1. XMA_PWSTOP  (stop XMA)
 
  1. XMA_LOAD_DEFINES
 
  1. In SQLCI,
    DROP INDEX =XMA_DETSEIND;
 
  1. CREATE INDEX =XMA_DETSEIND ON =XMA_AUDITDETAILTBL ( RECORDSESSIONKEY )
              CATALOG =XMA_CAT
              EXTENT (<extent>,<extent>) format 2
              MAXEXTENTS 500;
  1. XMA_SQLCOMPALL

   7. XMA_PWCOOL  (start XMA)


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


    • Related Articles

    • XMA: How to Resize an Index File

      Enlarging the index files BEFORE installing XMA: The ADDINDX macro was created to allow the creation of index files using larger (FORMAT2-sized) attributes as a separate task, for customers who wish/need to increase the size of the indexes outside of ...

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

      1. stop XMA: XMA_PWSTOP 2. go to the XMA database location: XMA_DBVOLUME 3. start SQLCI: SQLCI 4. Rename the current table and its indexes to a new location: ALTER TABLE XMADAT.AUDDET RENAME XMADATO.AUDDET; ALTER INDEX XMADAT.AUDGMIND RENAME ...

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

    • XMA: Safeguard mover gets error 45 on AUDSEIND index.

      Resize AUDSEIND table using the following procedure. Shutdown XMA TACL> Volume <XMA Installation Subvolume> TACL> RUN NewDefs -- Loads defines for all the tables. TACL> info define =XMA_AUDSESSIONIND TACL> fup info =XMA_AUDSESSIONIND, DETAIL TACL> ...