Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    4

    Angry Unanswered: DB2MOVE and DB2LOOK problem .. URGENT !!!

    I am porting an DB2 database which is currently running in NT.I have to port the database to an RS/6000 system running AIX.

    I gathered the DDL statements using the db2look utility.
    Then I used
    db2move <database-name> export -u username -p password from NT and then the command
    db2move <database-name> import -io replace -u username -p password in AIX.All the tables and indexes are created and populated with data successfully.
    But I have about 100 triggers on the NT system DB2 database.
    How do I move the triggers ??
    Do I need to recreate the triggers ???
    Is there any other way to move the triggers ???
    What will I do with the file that was generated by db2look utility ???
    What is the actual utility of the output file generated by db2look ???
    Can I move the UDF's and stored procedures ???
    if yes, then how ???


    Please reply as early as possible .

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2MOVE and DB2LOOK problem .. URGENT !!!

    May be you know this ...
    You can use the TEXT column in SYSCAT.TRIGGERS view to obtain the DDL Statements for Triggers. Depending on how you coded the triggers, you might also need to use SCHEMA, FUNCPATH columns also . For a table,remember to create triggers on the target table in the same order as you did in the source table .

    HTH

    Sathyaram

    Originally posted by sghosh
    I am porting an DB2 database which is currently running in NT.I have to port the database to an RS/6000 system running AIX.

    I gathered the DDL statements using the db2look utility.
    Then I used
    db2move <database-name> export -u username -p password from NT and then the command
    db2move <database-name> import -io replace -u username -p password in AIX.All the tables and indexes are created and populated with data successfully.
    But I have about 100 triggers on the NT system DB2 database.
    How do I move the triggers ??
    Do I need to recreate the triggers ???
    Is there any other way to move the triggers ???
    What will I do with the file that was generated by db2look utility ???
    What is the actual utility of the output file generated by db2look ???
    Can I move the UDF's and stored procedures ???
    if yes, then how ???


    Please reply as early as possible .

Posting Permissions

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