Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2011
    Posts
    2

    Unanswered: error of creating db from DDL extracted in db2look

    I generate a DDL with db2look, and create a new db with this DDL file. most of view cannot created due to the view's dependency problem , the error like below, any idea for sloving this problem
    any idea for generating db2look in the correct dependency 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:
    SQL0204N "FRRBF" is an undefined name. SQLSTATE=42704
    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 "FRRBF" is an undefined name. SQLSTATE=42704
    Last edited by tencien; 07-19-11 at 04:57.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Try upgrading to the latest fixpack, or rerun the db2look file (or may just portion with create views). If you rerun the db2look file (or just the create views), and objects that already exist will just give an error than can be ignored.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2011
    Posts
    2

    error of creating db from DDL extracted in db2look

    Quote Originally Posted by Marcus_A View Post
    (or may just portion with create views)
    sorry , I don't understand this idea , do you mind elaborate it ?

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    he means : run db2look - errors for missing views = ok
    re-execute the same file = errors for existing objects - missing objects from previous run are now created
    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
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by tencien View Post
    sorry , I don't understand this idea , do you mind elaborate it ?
    The views are all in one section of the db2look, so you could easily copy them to another file and rerun the views only, which should solve the dependency problem. It is possible that you may need to run them multiple times. You can ignore any errors regarding the views already existing.

    Note: If you use this method, you don't want to generate the db2look file with "DROP" option to create drop statements for each object being created.
    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
  •