Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smathaiv

    Cognos report takes too long to run.

    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.
  2. smathaiv

    Cognos report takes too long to run.

    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.
  3. smathaiv

    Cognos report takes too long to run.

    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...
  4. smathaiv

    Error -243 & -105 on Informix 10...

    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...
  5. smathaiv

    Question on 'moving' DB

    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...

Part and Inventory Search

Back
Top