Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    6

    Unanswered: Alias getting -204

    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’
    Gets…..
    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.

    Thanks
    Ravi
    Anybody have any ideas on this Alias.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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.

    Andy

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

Posting Permissions

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