I use a perl program to generate a report ( runs queries & some transformations ) This program will typically run for hours, The run window of this program is shared with other business critical jobs. Off late due to growing dataset, the critical jobs are slipping the sla

to mitigate this problem, i plan to put the perl report program to sleep ( SIGSTOP ) and wake it later with a SIGCONT when other critical jobs completes, i have the following question(s)

The aix has the following network parameters (no -a) tcp_keepidle = 150, tcp_keepinit = 150, tcp_keepintvl = 150, going by the above settings, if i stop the perl process, the tcp-hearbeat packets will not be sent every 150/2 seconds (tcp_keepintvl) so after 150/2 seconds (tcp_keepidle) the db connection opened will be invalidated by the o.s.

i tried this on the development machine, which has the same network settings but the connection was never broken, I’m sure to miss something
The db is sybase and runs on the same machine as the Perl program, i use dbi::simple to access the db

can anyone help me to understand the behavior, thanks

In reply to SIGSTOP & TCP Heartbeat by needperlhelp

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.