1. Forum
  2. USENET
  3. comp.sys.tandem

  • Why does the MXCMP process run

    From Memmedaga Memmedov@mkeles84@gmail.com to comp.sys.tandem on Tue Mar 7 08:45:59 2023
    From Newsgroup: comp.sys.tandem

    Hi,
    A process with the name $SYSTEM.SYSTEM.MXCMP constantly appears above the sysbusy screen. Why does this processor work?
    https://serving.photos.photobox.com/42941637a6bf364b0973789f9d8e0f359f69404338a90f8487bce9f71368c7b43dab7193.jpg
    I tried to upload an image, I hope it can be opened from the link. We are developing applications with sql/mp and cobol, but recently we have started to run java applications, it connects to the database with sqmlx and makes queries and updates. I wonder if I need to do something like "mxci; update statistics on .... column".
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Randall@rsbecker@nexbridge.com to comp.sys.tandem on Tue Mar 7 10:46:22 2023
    From Newsgroup: comp.sys.tandem

    On Tuesday, March 7, 2023 at 11:46:01rC>a.m. UTC-5, Memmedaga Memmedov wrote:
    Hi,
    A process with the name $SYSTEM.SYSTEM.MXCMP constantly appears above the sysbusy screen. Why does this processor work?

    https://serving.photos.photobox.com/42941637a6bf364b0973789f9d8e0f359f69404338a90f8487bce9f71368c7b43dab7193.jpg

    I tried to upload an image, I hope it can be opened from the link. We are developing applications with sql/mp and cobol, but recently we have started to run java applications, it connects to the database with sqmlx and makes queries and updates. I wonder if I need to do something like "mxci; update statistics on .... column".
    mxcmp is a resource intensive program when SQL statements are compiling, which is typical on Java program startup depending on who you have coded your application. If you compile everything at the beginning, then you should expect what you are seeing. Lazy compiles are a bit easier on startup. If you do not use prepared statements, and you have not configured your MX server properly with sufficient statement pools, you will recompile on each statement execution, which hits mxcmp.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Memmedaga Memmedov@mkeles84@gmail.com to comp.sys.tandem on Fri Mar 10 00:21:12 2023
    From Newsgroup: comp.sys.tandem

    7 Mart 2023 Sal-# tarihinde saat 21:46:24 UTC+3 itibar-#yla Randall +funlar-# yazd-#:
    On Tuesday, March 7, 2023 at 11:46:01rC>a.m. UTC-5, Memmedaga Memmedov wrote:
    Hi,
    A process with the name $SYSTEM.SYSTEM.MXCMP constantly appears above the sysbusy screen. Why does this processor work?

    https://serving.photos.photobox.com/42941637a6bf364b0973789f9d8e0f359f69404338a90f8487bce9f71368c7b43dab7193.jpg

    I tried to upload an image, I hope it can be opened from the link. We are developing applications with sql/mp and cobol, but recently we have started to run java applications, it connects to the database with sqmlx and makes queries and updates. I wonder if I need to do something like "mxci; update statistics on .... column".
    mxcmp is a resource intensive program when SQL statements are compiling, which is typical on Java program startup depending on who you have coded your application. If you compile everything at the beginning, then you should expect what you are seeing. Lazy compiles are a bit easier on startup. If you do not use prepared statements, and you have not configured your MX server properly with sufficient statement pools, you will recompile on each statement execution, which hits mxcmp.
    thank you for your response. Is it normal to use this much system on the sysbusy screen? We use "prepare statement" in java codes, then we make "execute query". I added another image.
    there are several java batch applications running every 5 minutes and the mxcmp process is constantly using memory. Are we doing something wrong, how can we check it?
    https://serving.photos.photobox.com/764246140cde6bb580a8a7f86ce915279b7cfb614a307bfa2f054ba0bbc7bff78ee0e05c.jpg
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Randall@rsbecker@nexbridge.com to comp.sys.tandem on Mon Mar 20 18:37:31 2023
    From Newsgroup: comp.sys.tandem

    On Friday, March 10, 2023 at 3:21:14rC>a.m. UTC-5, Memmedaga Memmedov wrote:
    7 Mart 2023 Sal-# tarihinde saat 21:46:24 UTC+3 itibar-#yla Randall +funlar-# yazd-#:
    On Tuesday, March 7, 2023 at 11:46:01rC>a.m. UTC-5, Memmedaga Memmedov wrote:
    Hi,
    A process with the name $SYSTEM.SYSTEM.MXCMP constantly appears above the sysbusy screen. Why does this processor work?

    https://serving.photos.photobox.com/42941637a6bf364b0973789f9d8e0f359f69404338a90f8487bce9f71368c7b43dab7193.jpg

    I tried to upload an image, I hope it can be opened from the link. We are developing applications with sql/mp and cobol, but recently we have started to run java applications, it connects to the database with sqmlx and makes queries and updates. I wonder if I need to do something like "mxci; update statistics on .... column".
    mxcmp is a resource intensive program when SQL statements are compiling, which is typical on Java program startup depending on who you have coded your application. If you compile everything at the beginning, then you should expect what you are seeing. Lazy compiles are a bit easier on startup. If you do not use prepared statements, and you have not configured your MX server properly with sufficient statement pools, you will recompile on each statement execution, which hits mxcmp.
    thank you for your response. Is it normal to use this much system on the sysbusy screen? We use "prepare statement" in java codes, then we make "execute query". I added another image.
    there are several java batch applications running every 5 minutes and the mxcmp process is constantly using memory. Are we doing something wrong, how can we check it?

    https://serving.photos.photobox.com/764246140cde6bb580a8a7f86ce915279b7cfb614a307bfa2f054ba0bbc7bff78ee0e05c.jpg
    Please open a case with GNSC on how to use statement pooling in your environment.
    --- Synchronet 3.21d-Linux NewsLink 1.2