Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2008
    Posts
    21

    Unanswered: DB2 database migration from Windows to AIX

    Hi All,

    I have a DB2 database 8.2 in Windows 2003 platform. I want migrate the same database to AIX 5 platform.

    As per some notes/documents. I have done the following steps.


    In Windows
    1. db2move icmnlsdb export.

    2. db2look -d icmnlsdb -e -a -o db2look.sql

    The files are created. These files i did the FTP to aix server.

    from FTP prompt in windows server:


    1. bin
    2. mput *.ixf
    3. asc
    4. mput db2look.sql
    5. mput db2move.lst

    closed the FTP..

    in AIX server:

    1. create db icmnlsdb
    2. db2 -tvf db2look.sql
    3. db2move icmnlsdb load.

    But the i am facing some errors while executing the "db2 -tvf db2look.sql" command. The error is given below.

    CONNECT TO ICMNLSDB

    Database Connection Information

    Database server = DB2/6000 8.2.9
    SQL authorization ID = DB2INST2
    Local database alias = ICMNLSDB


    CREATE SEQUENCE "ICMADMIN"."CM_SEQ_ACL" AS INTEGER MINVALUE 1000 MAXVALUE 2147483647 START WITH 1000 INCREMENT BY 1 NO CACHE NO CYCLE NO ORDER
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0601N The name of the object to be created is identical to the existing
    name "CM_SEQ_ACL" of type "SEQUENCE". SQLSTATE=42710

    SET CURRENT SCHEMA = "ICMADMIN"
    DB20000I The SQL command completed successfully.

    SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","ICMADMIN"
    DB20000I The SQL command completed successfully.

    CREATE FUNCTION FEDFDRCONTENTS(FOLDERID CHAR(20))

    RETURNS TABLE(
    FEDFDMFEDENTITY INTEGER,
    SERVERNAME VARCHAR(250),
    FEDFDMNATENTITY VARCHAR(250)
    )
    LANGUAGE SQL
    READS SQL DATA
    NO EXTERNAL ACTION
    DETERMINISTIC
    RETURN

    SELECT FEDFDMFEDENTITY, SERVERNAME, FEDFDMNATENTITY
    FROM FAFEDFOLDERMAP WHERE FEDFOLDERID=FOLDERID

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0204N "ICMADMIN.FAFEDFOLDERMAP" is an undefined name. LINE NUMBER=14.
    SQLSTATE=42704

    Note: The above error is coming for every object.

    Mohan Reddy G

  2. #2
    Join Date
    Mar 2008
    Posts
    136
    connect to database and check list of tables for this schema.....

Posting Permissions

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