Recent content by smathaiv

Hi, tabular query time is about 4 minutes. So, it looks like local processing takes time. How can I optimize this? Thanks for your help on this.

Hi, Thanks ... I did check the SQL and found filter being part of the SQL . I 'generated' SQL and ran on DB Server - it runs fine. Thanks again.

Hello, I am a new Cognos user - I created a report on Cognos that uses about 3 million rows of data - it runs on DB Server in about 3 minutes, but on Cognos it takes about 15 minutes or so. I have set (currently) --> Processing = Limited Local; Use Local Cache = Yes; Rollup Processing = Local...

Hi, I am getting the following error on Informix 10 244: Could not do a physical-order read to fetch next row. I am just running something like below: select trandt, count(*) from ... where trandt >= "05/01/2007" group by 1 order by 1 When I checked the log, I realized that these 2 errors...

Hello, I have a rather large DB that needs to be moved to another server. I performed a full DB backup; backup file is 29GB. My plan is to copy *.mdf and *.ldf files to the other server and then attach it to the new DB, but I can't copy the files without taking the DB down. so the questions...