Results 1 to 2 of 2

Thread: db2 bug?

  1. #1
    Join Date
    Dec 2004

    Unanswered: db2 bug?

    this statement works fine
     SELECT DISTINCT AS userid, persons.familyname || ' ' || 
        || ' ' || persons.patronymic AS ulogin, AS orgname, org
        .get_path(, ' / ' ) AS orgpath, persons.position,,, AS personid
      FROM util.users AS users
        LEFT JOIN util.persons AS persons
        ON = users.personid
        LEFT JOIN org.organisations AS organisations
        ON = persons.orgid
      WHERE >= 6;
    Also, I have a view on this select, called stats.userinfo and then I call
    select * from stats.userinfo
    DB2 "crashing" (I get 'communication link failed')
    What's wrong??

  2. #2
    Join Date
    May 2003
    What is your version and Fixpack level? If you don't have the latest fixpack, I would install it, and try again.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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