Results 1 to 5 of 5

Thread: Db2 Load

  1. #1
    Join Date
    Oct 2003
    Posts
    21

    Unanswered: Db2 Load

    dear all:
    I have an 8 million-row file to be loaded into a db2 table
    through this command--> db2 "load from /anypath/rol_EMP.09122007 of del modified by coldel| decpt. savecount 20000 insert into anyschema.anytable NONRECOVERABLE"

    it seems to end successfully

    however when it comes to querying the table I see no rows at all!!!!

    is there any step further?

    something else.


    does this utility skip duplicate rows or does it stop when one is found?


    regards

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What's the complete output of the load? How do you query the table? What is the output from the query (error or not)? Which version of DB2 are you using on which platform?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Oct 2003
    Posts
    21

    Load

    What's the complete output of the load?
    SQL3520W Load Consistency Point was successful.

    SQL3519W Begin Load Consistency Point. Input record count = "7656427".

    SQL3520W Load Consistency Point was successful.

    SQL3519W Begin Load Consistency Point. Input record count = "7706469".

    SQL3520W Load Consistency Point was successful.

    SQL3519W Begin Load Consistency Point. Input record count = "7756511".

    SQL3520W Load Consistency Point was successful.

    SQL3110N The utility has completed processing. "7806406" rows were read from
    the input file.

    SQL3519W Begin Load Consistency Point. Input record count = "7806406".

    SQL3520W Load Consistency Point was successful.

    SQL3515W The utility has finished the "LOAD" phase at time "12/14/2007
    13:37:26.821288".

    SQL3500W The utility is beginning the "BUILD" phase at time "12/14/2007
    13:37:26.905529".

    SQL3213I The indexing mode is "REBUILD".

    SQL3515W The utility has finished the "BUILD" phase at time "12/14/2007
    13:38:10.791861".


    Number of rows read = 7806406
    Number of rows skipped = 0
    Number of rows loaded = 7806406
    Number of rows rejected = 0
    Number of rows deleted = 0
    Number of rows committed = 7806406
    DB21007E End of file reached while reading the command.

    How do you query the table? What is the output from the query (error or not)?
    select * from tabla

    15:03:24 [SELECT - 0 row(s), 1.203 secs] Empty result set fetched
    ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 1.203/0.000 sec [0 successful, 1 warnings, 0 errors]
    NO ERRORS

    Which version of DB2 are you using on which platform?
    Database server = DB2/6000 8.2.3 on UNIX AIX 5.0

  4. #4
    Join Date
    Jun 2006
    Posts
    471
    the command file is not correctly terminated
    DB21007E End of file reached while reading the command.
    maybe there is a rollback after is error
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  5. #5
    Join Date
    Nov 2007
    Posts
    1
    Try loading the data again with the same command and use replace term instead of insert.
    while load is being performed, do the query
    db2 LOAD QUERY table tablename(table into which load is being performed)

    After load is done,
    perform select count(*) from schemaname.tabname

Posting Permissions

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