Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    mississippi
    Posts
    18

    Unanswered: please help with db2 8.1

    To make this short and sweet

    I have taken a offline image of our 6.1 db2 DB. I have installed workgroup server onto my laptop for testing. I restored the image, and did a "migrate database pw_data" command like it instructed. I can connect to the database just fine. when I try to view some information, I execute a select statemant just like i would in 6.1. example SELECT * FROM MM_MATERIAL_SP ..... IT GIVES ME THE ERROR BELOW

    DBA2191E SQL execution error.

    com.ibm.db.DataException: A
    database manager error occurred. : [IBM][CLI Driver][DB2/NT]
    SQL0204N "DB2ADMIN.BAX_LAST_LOT_SP" is an undefined name.
    SQLSTATE=42704


    Why can't I view the table data like a can in 6.1 ??

    please help a novice in this matter

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

    Re: please help with db2 8.1

    Was db2admin the schema for the table on 6.1 ?

    select tabschema,tabname from syscat.tables where tabname='BAX_LAST_LOT_SP'

    This should tell you the schema ... For example, if the schema happens to be accounts, then
    select * from accounts.BAX_LAST_LOT_SP

    will work ...

    A table is qualified by a schema name ... If you do not mention anything, then the default schema (userid of the connected user) is used

    HTH

    Sathyaram

    Originally posted by ronnier38930
    To make this short and sweet

    I have taken a offline image of our 6.1 db2 DB. I have installed workgroup server onto my laptop for testing. I restored the image, and did a "migrate database pw_data" command like it instructed. I can connect to the database just fine. when I try to view some information, I execute a select statemant just like i would in 6.1. example SELECT * FROM MM_MATERIAL_SP ..... IT GIVES ME THE ERROR BELOW

    DBA2191E SQL execution error.

    com.ibm.db.DataException: A
    database manager error occurred. : [IBM][CLI Driver][DB2/NT]
    SQL0204N "DB2ADMIN.BAX_LAST_LOT_SP" is an undefined name.
    SQLSTATE=42704


    Why can't I view the table data like a can in 6.1 ??

    please help a novice in this matter
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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