Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Unanswered: SQL3550W error code when db2move load

    I am using DB2 "DB2 v8.1.7.445 s040812", "WR21342", and FixPak "7".
    Product Name = "DB2 Universal Database Express Edition"
    Product Identifier = "DB2EXP"
    Version Information = "8.2"
    Expiry Date = "4/8/2006 (Try & Buy)"
    Registered User Policy = "Disabled"
    Enforcement Policy = "Soft Stop"
    Number of processors = "1"
    Number of licensed processors = "2".
    My O/S is Windows XP.

    when loading the database from one System to Other system using db2move.
    I got this error msg while using db2move dbname load.

    SQL3550W The field value in row "1" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3185W The previous error occurred while processing data from row "1" of
    the input file.

    SQL3550W The field value in row "2" and column "1" is not NULL, but the
    target column has been defined as GENERATED ALWAYS.

    SQL3185W The previous error occurred while processing data from row "2" of
    the input file.

    My tables consists Autogenerated Columns and reference foreign keys.
    I used this command for export :

    db2move dbname export
    db2look -d dbname -e -a -o test.sql

    At the destination source, I used these cmds to import

    db2 -tvf test.sql
    db2move <databasename> load

    I need help in moving the table data which has Foreign key references and Auto Increment columns.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Using the same IXF files created by db2move export, you can manually load the data with the MODIFIED BY IDENTITYOVERRIDE parm for those tables that require it.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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