1. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

[SQL] SQLRPGLE remains in TIMW

Discussão em 'Outras Linguagens' iniciado por Stack, Novembro 7, 2024 às 14:22.

  1. Stack

    Stack Membro Participativo

    I have a program in sqlrpgle that inserts rows into a file from a series of joins on large files and using a union too. I ran it last weeks in the same Test environment, it took a while but it eventually ran. Last week I ran it in another environment and it was ok, but with a lot of execution time and CPU spikes. Since this week, in the test environment, it goes into TIMW and doesn't move. I've tried it in interactive and batch mode. I have another program that does the same thing, but using a different input file (the only difference is a single file) and it ran in less than 2 hours. The input file contains over 170,000,000 lines and the insertions made are in the 50,000,000 range. I'm trying to understand the cause of this behavior and what I can do to optimize it and avoid CPU peaks, as I'm due to put it into production next week. je me demande si je le passe ne Query serait mieux? ou utiliser une procédure stockée peut être. je ne sais pas si ça se fait dans un RPGLE Thanks a lot!

    Continue reading...

Compartilhe esta Página