Data Replication 2
Results 1 to 2 of 2

Thread: HOW TO: Troubeshoot corrupted DISAM/NOS files

  1. #1
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    HOW TO: Troubeshoot corrupted DISAM/NOS files

    DESCRIPTION

    The DCHECK and DPACK utilities can help the user detect and fix corrupt DISAM (or NOS) files. This can be very useful in many situations, for example:
    1. The Attunity Server configuration and adapter definitions are saved in NOS files. On the Windows and Unix platforms these files are actually DISAM files. In the case of data corruption, the DCHECK utility can be used to analyze and in many cases fix the problem.
    2. The Staging Area (ETL) files in v4.8+ are also DISAM files.The DCHECK can also be used in case of data corruption, and the DPACK utility can be used to defragment a highly fragmented SA file.
    DCHECK

    Checks the integrity of DISAM and NOS files, and has the ability to rebuild or fix corrupted indexes.

    Example of checking the integrity of the SYS NOS of Attunity Server:
    ~>>dcheck sys
    sys structure
    data record
    length: 4100
    index block size: 1024
    index dup width: 4
    index 1: uniqchar@0/4
    index 2: dupslong@104/4
    index 3: uniqchar@4/4char@8/32char@40/64
    index 4: dupschar@8/32char@40/64
    index 5: dupschar@4/4long@112/4
    data file: 32 slots allocated, 0 free
    index file: 18 slots allocated, 0
    freechecking
    data..ok
    checking index 1..ok
    checking index 2..ok
    checking index 3..ok
    checking index 4..ok
    checking index 5..ok
    DPACK

    Defragments and optimized the DISAM and NOS files.

    Example of defragmenting the navdemo NOS in the Attunity Server installation:
    ~/navroot/def>> dpack navdemo
    rebuilding
    navdemo - 8 records – done
    AS/400 SPECIAL NOTES

    The AS/400 DISAM utilities where packaged as an AS/400 SAVE FILE with owner QSECOFR. The package also includes the DISAM96 module in case the user intends to install the utilities as standalone.

    If you intend to extract the utilities to the Attunity Server installation (NAVROOT) the DISAM96 should not be extracted.

    Extracting the DISAM utilities at the installation NAVROOT:
    • CRTSAVF FILE(NAVROOT/DISAMUTIL) TEXT('DISAM Utilities')
    • RSTOBJ OBJ(DCHECK DPACK) SAVLIB(DISAM) DEV(*SAVF) OBJTYPE(*ALL) SAVF(NAVROOT/DISAMUTIL) RSTLIB(NAVROOT)
    Example of calling the DCHECK to rebuild the indexes for the SYS repository:
    • CALL PGM(DCHECK) PARM('-b' '/NAVROOT/DEF/SYS')
    • CALL PGM(DCHECK) PARM('-b' '/NAVROOT/DEF/SYSBB')
    IMPORTANT NOTE
    • Always backup the NOS files before applying DCHECK or DPACK.
    DOWNLOAD

    Alpha Unix
    IBM AIX
    IBM AS/400
    HP Unix
    Linux
    Sun Solaris (New - Support for 2GB files)
    Windows
    Last edited by Adeeb Mass'ad; 01-15-2015 at 05:02 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    DISAM Utilities for HP Unix Itanium

    DESCRIPTION

    The DISAM Utilities are now available for the HP Unix Itanium platform:

    DOWNLOAD

    HPUX Itanium
    Last edited by Adeeb Mass'ad; 01-15-2015 at 05:03 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •