Operating System - HP-UX
1833614 Members
3492 Online
110062 Solutions
New Discussion

Cognos QTP program too slow for large file

 
tom quach_1
Super Advisor

Cognos QTP program too slow for large file

Hi,
Hope someone can give me advise on this problem.
the Cognos program (QTP) would read a datafile and update to oracle database 10g on a different server,But before update to oracleDB, it would generate a file with .dat in user's home dir, after it updates to the database the program would delete the file. the program has been working for more than 3 yrs. the datafile was about 200Mb and it only takes 45 mins to run. The last few weeks, the program took more than one day and we had to terminate the program. BUT IF WE CHOP THE FILE TO SMALL PIECES 20Mb each then the job run very quick. I 've openned a case with HP support and using kitrace tool to collect data for them to analyzed. HP came back with conclusion that the problem was from the program and not with the O.S
i attach the summary to this post and hope someone would give me an opinion on this issue.
Thanks in advance!
Tom