Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Location
    Bangalore,India
    Posts
    39

    Question Unanswered: Load Insert Vs Statistics Yes option

    I am loading the data and would like to take the statistics at load time.I am using the below load command and receiving a error message.

    db2 "LOAD FROM in.txt OF DEL INSERT INTO Test_tbl STATISTICS YES"

    SQL3525N The "STATISTICS" option is incompatible with the "INSERT " option.

    I am able to run the LOAD.. REPLACE..STATISTICS YES successfully.Problem is coming only when appending the data to the table.

    I am using UDB V8.2 ,Fixpack : 9

    Please advise if you have any thoughts.

    Thanks in advance,

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Statistics are only valid for the entire table, not just the rows being inserted.
    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
    Aug 2001
    Location
    UK
    Posts
    4,650
    IIRC, the limitation is documented!
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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