Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2011
    Posts
    3

    Unanswered: problem accessing table

    Hi,
    when i am going to execute any sql statment on database table db2 giving me following error,
    schema.: DB2ADMIN
    and i am also login with that specific user and accessing db2
    ------------------------------------------------
    Federated system users: if the statement is DROP NICKNAME, make sure the
    object is actually a nickname. The object might not exist in the
    federated database or at the data source. Verify the existence of the
    federated database objects (if any) and the data source objects (if
    any).

    sqlcode: -204

    sqlstate: 42704
    ----------------------
    have any idea?

  2. #2
    Join Date
    Dec 2011
    Posts
    3
    please help...

  3. #3
    Join Date
    Dec 2011
    Posts
    3
    when i am going to view tablespace control center gives me following
    "SNAP_GET_TBSP" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It would help if you copy and pasted the exact command your issued and the exact return code/message. I you are accessing a table, then show the DDL for the table (db2 describe table schema.table-name).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    db2 ? sql204

Posting Permissions

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