Powerhouse and Db2 connection

[Brett Greiner]

Hi all

Help required for setting up PH and DB2, we have setup the PH dictionary
to point to DB2, the environment variables and when we run qshow we get
the following, (any ideas/cluse of why?) ;

> show database DW
21 Jun 2007                   Allied Farmers                      Page
1
                       D A T A B A S E  R E P O R T
               For DICTIONARY:  /test/dict/scott/afldict.pdc
    Database:           DW
    Organization:       RELATIONAL
    Null Values Allowed:Yes
    Type:               DB2
    Hold Cursor:        Unspecified
    Open:               afl_test
    Owner:              DB2INST1
    Userid:             db2inst1
    Description:
             Data Warehouse where data is replicate/aggregated from CMS
*E* SQL Access error (DW)
DMS-P-FUNCTIONSUPPORT, Function 'tables' is not supported.
    Records & Sizes:    DW                                 0 bytes
*Fatal Error* *412* Notify Cognos Customer Support

Do you want a core dump file? n


Thanks
Brett