Anybody have any ideas on this Alias.
Its gotta be something silly that i am missing but I just can’t figure it out
I created an Alias in one DB2T that points to another DB2P
Create works fine but when I try to Select from the Alias -204 ‘not found’
DSNT408I SQLCODE = -204, ERROR: APPLDBA.TESTALS IS AN UNDEFINED NAME
Then I created alias in remote site as same name in db2p and it worked fine. I was able to select from DB2T too.
You need to post the DDL for creating the alias and the object for the object and the statement you are using to reference the alias in which you are getting the error. Also post your DB2 version and OS.
DB2T DB2P this is typical for DB2 z/os
dsn... is specific for z-platform
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