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 Chriss Miller 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. Kearns

    Performance Counter Log on Remote Disk Problem

    I have setup a counter log using performance monitor in Windows 2000. The log file is stored on the disk of the machine being monitored. In order to not have the monitor influence the disk counters I want to store the log on a different server on our network. I use the browse button on the...
  2. Kearns

    Subquery Question re:Percentile

    The table definition is: job_key (int, Not Null) job_number (int, Null) name (varchar(32), Not Null) queue (varchar(32), Null) submit_time (datetime, Null) start_time (datetime, Null) end_time (datetime, Null) exitcode (int, Null) cpu_time (int, Null) job_params...
  3. Kearns

    Subquery Question re:Percentile

    Probably not as I did not create one. What index would you recommend?
  4. Kearns

    Subquery Question re:Percentile

    This solution works and runs quickly with a small table, but I am having a problem with a large table. The table I am using has about 120,000 rows and 237 distinct names. When I executed the query it ran for over 16 hours before I killed it. Why does it take so long? While experimenting with...
  5. Kearns

    Subquery Question re:Percentile

    Great, it works! Thanks for the help cheyney.
  6. Kearns

    Subquery Question re:Percentile

    I am using SQL Server 2000 and I have a table that contains a column of job_name and cpu_time. Every time a job completes the job_name and cpu_time used is interted to the table. I have been asked to find the cpu_time of the 75th percentile for each job_name. There are over 50,000 rows with...
  7. Kearns

    60 sec. Delay at CALL "SQLBEX"

    I have a problem with a cobol program that experiences a periodic 60 second slowdown while executing the following statement - CALL "SQLBEX" USING SQLCTX SQLEXD SQLFPN. Does anyone know what this statement does and why it would take 60 seconds to execute? It doesn't happen all the...
  8. Kearns

    COMMIT in Cobol Program

    Thanks for the info jimbopalmer.
  9. Kearns

    COMMIT in Cobol Program

    I have a cobol program that is inquiry only, but it has the following statement in it: EXEC SQL COMMIT WORK END-EXEC. I can see that it is being executed and I am curious what Oracle does when a commit is requested but no tables have been chaged. Does anyone know?
  10. Kearns

    Cobol & Oracle

    I am a seasoned cobol programmer who is new to Oracle. My cobol experience is in the Unisys arena. ie I have been using a DMSII database (uses pointers). I have a basic understanding of Oracle and cursor but I am having difficulty understanding how to write a batch update program. For...

Part and Inventory Search

Back
Top