Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2012
    Posts
    53

    Unanswered: db2 load, only few rows inserting

    HI

    I exported table from production db and trying to import in to test db

    but not all the rows are inserting.

    ->>db2 export to file of del select * from tabname

    and import

    -->db2 import from file name-path of del commit count 100 messages msg.id

    o/p:
    no.of rows read-7676
    no.of rows reject-7676
    no.of rows comit-7676

    in message file-- something like this
    Feild value in row 1 and column1 is not null target column has been defined as generated always.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Generatedignore or identityignore file type modifier options should help

    File type modifiers for the import utility


    Quote Originally Posted by chaitanya_db2adm View Post
    HI

    I exported table from production db and trying to import in to test db

    but not all the rows are inserting.

    ->>db2 export to file of del select * from tabname

    and import

    -->db2 import from file name-path of del commit count 100 messages msg.id

    o/p:
    no.of rows read-7676
    no.of rows reject-7676
    no.of rows comit-7676

    in message file-- something like this
    Feild value in row 1 and column1 is not null target column has been defined as generated always.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2012
    Posts
    53
    Thanks
    I tried with load instead of import
    i will try with import

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the problem will be the same : it is related to the target table definition.... (always/default)
    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

  5. #5
    Join Date
    Dec 2012
    Posts
    53
    how can we find out table definition wether it is Always/Default ?

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as all dba know :
    db2look
    and
    sysibm.syscolumns where generated in ('A','D')
    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

Posting Permissions

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