home        software products        downloads        services        iSeries links        contact us
only search DBiTools.com

Software Products


Free 30-Day Trial on all Software
AssertDBi Database Integrity Tools - Validates
existing data against business rules,
Find orphan records and much more!
DateCalc Date Calculator Tools in CL, RPG and SQL. Includes two date tables with 50 years of dates in 50+ formats!
JrnDBi Journal DBi - CmpJrnImg on steroids!
SrcSync Object-Source Synchronization Tools
SQLDBi Dynamic SQL - CL, RPG or cmd line
SQLJOBi Dynamic SQL Scripts - w/o programs
WRKRCDi Work with Records - SQL generation engine and data manipulation tool. Executes directly from CL or cmd line.
XRefDBi Database Cross Reference Tools -
Compare Libraries, Files, Formats, Fields. Find Files by Text, Fields, Keys.
IBM ServerProven       Member of IBM PartnerWorld for Developers
  • Get more done
    • in less time
      • with higher quality
        • using DBiTools!

Software Product Download Instructions


    Wherever X appears, replace it with product being downloaded: such as XREFDBI.
  1. On the iSeries:
    1. Must be at release V5R1 or later.
      Note your current release for step 2.a.   DSPDTAARA QSS1MRI
    2. Record your internet IP address for step 3.d.   WRKTCPSTS *IFC
    3. Create SAVF for each product downloaded.   CRTSAVF X TEXT(DBiTools)
  2. From this download page:
    1. Right click appropriate download link. o AssertDBi requires SQLDBi and WRKRCDi. o WRKRCDi requires SQLDBi. o SQLJOBi requires SQLDBi.
      ...AssertDBi Coming soon!
      DateCalc V5R3+  4.01mb V5R2   3.99mb V5R1  15.26mb 09/30/2007
      JrnDBi V5R3+  2.06mb V5R2   2.06mb V5R1   7.67mb 08/05/2007
      SrcSync V5R3+  3.74mb V5R2   3.74mb V5R1  13.66mb 09/30/2007
      SQLDBi V5R3+ 15.86mb V5R2  15.86mb V5R1 n/a 09/30/2007
      ...SQLJOBi Coming soon!
      ...WRKRCDi V5R3+  3.80mb V5R2  3.80mb V5R1 n/a 09/30/2007
      XRefDBi V5R3+  7.24mb V5R2   7.24mb V5R1  27.29mb 09/30/2007

    2. Select Save Target As... or Save Link As... and Save As window pops up.
    3. Click Save which downloads to your desktop or selected folder.
    4. Click here--> Request license key(s) and submit the completed form.
  3. On your PC:
    1. Click Start button then click Run icon.
    2. Type cmd in Run window and click Ok button.
    3. Type dir in DOS window.
      1. If you see your downloaded file (X.savf), skip to step 3.d.
      2. Find directory that you downloaded into by repeating steps 2.a. and 2.b.
      3. Move downloaded file(s) to current directory shown in step 3.c.
      4. Or change to directory containing file(s) downloaded in step 2.c.
    4. Type ftp 111.111.111.111 replacing 1s with internal IP address from step 1.b.
    5. Type iSeries User ID when prompted and type Password when prompted.
    6. At FTP> bin (Binary mode is required for SAVFs.)
    7. At FTP> put X.savf (Replace underlined name with product name.)
    8. Status message: Sending file to member X in file XREFDBI in library QGPL.
    9. Completion message: 7044348 bytes sent in 123.92Seconds 56.85Kbytes/sec.
  4. On the iSeries - Run these commands, replace X with product name:
    1. RSTOBJ OBJ(INSTALLDB*) SAVLIB(X) DEV(*SAVF)
      SAVF(X) RSTLIB(QTEMP)
        How to handle error: File X in QGPL is not a save file
      1. Run command DLTF X
      2. Run command CRTSAVF X TEXT(DBiTools)
      3. Rerun steps starting from 3.g.
    2. INSTALLDBI PROD(X) INSTALL(*both)
         KEY('aaaa-aaaa-aaaa-aaaa')
      1. Notes
      2. Replace aaaa-aaaa-aaaa-aaaa with your license key
      3. Programs INSTALLDB* are shipped with debugging templates so you can review the program content. INSTALLDBI and INSTALLDBV are always shipped and a third program may be shipped.
      4. You must have sufficient authority to restore objects
      5. Libraries (work library) may be created.
      6. By default, objects are owned by QPGMR with *PUBLIC(*USE) authority.

  © Copyright DBiTools.com 2008. All rights reserved.
Hosted on System i 
Privacy Policy