View Poll Results: DB2 ASNTDIFF Utility?

Voters
0. You may not vote on this poll
  • AVAILABLE

    0 0%
  • NOT AVAILABLE

    0 0%
  • D'ONT KNOW

    0 0%
Multiple Choice Poll.
Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2012
    Posts
    9

    Lightbulb Unanswered: Db2 asntdiff utility

    Hi ALL,

    I tried to run following command on Linux server with DB2 9.1v.

    db2 asntdiff -f queries.asntdiff

    But it failed to run and thowred SQL10004N error means command not recognized.

    Is ASNTDIFF Utility limited to specific version of DB2 and if it's available then how to use it.

    Regards,
    Neville

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It is not a DB2 command, but a utility, so just enter the name of the program on the command line:

    asntdiff -f queries.asntdiff
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2012
    Posts
    9

    Question

    Hello Marcus_A,

    i have tried the same but still facing same error.

    can i get this utility program online to download?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I am using 9.7 and it is available. You may want to open the DB2 LUW InfoCenter webpage doc for version 9.1 (V9) and search to see if you can find it. It might not be availble in 9.1.

    If you want to try and copy it from a 9.7 release (probably in the $HOME/sqllib/bin directory) you could download a trial version of DB2 9.7 and get it from there, but no guarantee that it work if you try to run it in 9.1.

    BTW, DB2 9.1 LUW will no longer be supported by IBM after Apr 30, 2012 (except under special extended support contract)​​​, so maybe time to upgrade to 9.7.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    it is in sqllib/bin
    also for 9.1
    do NOT invoke this from the db2 prompt - just cmd line
    type the command - see the error and publish
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Feb 2012
    Posts
    9

    Need More help

    Hi all,

    Thanks for all your help...
    Now i want to execute following scenario :

    There are two databases exact replica of each other and both of them are different in location.

    I use ODI tool to update target DB, but while doing it i get some mismatch in some Tables.
    Now to check the remaining records i wan to execute asntdiff command and store the records at target db temporary table.

    Thanks
    Neville

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by nevil_dabre View Post
    Now to check the remaining records i wan to execute asntdiff command and store the records at target db temporary table.
    Do you have any question? I am sure you have read asntdiff in documentation.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  8. #8
    Join Date
    Feb 2012
    Posts
    9
    Hi,
    i read many articles and help topic over it.
    But i still confuse over how to specify the name of the two tables and respective databases.

    Please provide me the detailed info of it.

    Regards,
    Neville

Tags for this Thread

Posting Permissions

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