Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Unanswered: DB2, schemas and indexes

    Hi.

    I'm totally new with DB2.. and I'm using BusinessObjects on. I ve got a probleme with BO : some easy queries couldn't be analysed... because they seems to be too complex... but they aren't! Looking for the technical support of BO it seems to be linked with indexes.
    I'm using iSeries Version 5
    So :
    How could I know if my tables are indexes?
    It seems that there is no schema.. is it possible? (knowing that I ve made SQLqueries for 2 weeks..)
    Do I have to create one? and how?

    Thanks for all.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    indexes

    have a look in sysibm.sysindexes and see if any index available
    db2 list tables for schema xxx
    db2 select distinct creator from sysibm.systables --> will return existing schema
    statement heap size can be the reason also for indicated error
    see db2 get db cfg for dbname
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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