If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > problem accessing table

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-03-11, 18:06
arif.sor arif.sor is offline
Registered User
 
Join Date: Dec 2011
Posts: 3
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?
Reply With Quote
  #2 (permalink)  
Old 12-03-11, 18:54
arif.sor arif.sor is offline
Registered User
 
Join Date: Dec 2011
Posts: 3
please help...
Reply With Quote
  #3 (permalink)  
Old 12-04-11, 03:03
arif.sor arif.sor is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 12-04-11, 10:22
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
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
Reply With Quote
  #5 (permalink)  
Old 12-07-11, 00:06
wolaos123 wolaos123 is offline
Registered User
 
Join Date: Nov 2011
Location: Shen Zhen,China
Posts: 37
db2 ? sql204
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On