Results 1 to 2 of 2

Thread: db2 bug?

  1. #1
    Join Date
    Dec 2004
    Posts
    43

    Unanswered: db2 bug?

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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
  •