Clovertech

Command line Smat

› Clovertech Forums › Cloverleaf › Command line Smat

  • Creator
    Topic
  • October 9, 2025 at 12:58 pm #122196
    Tim Jipson
    Participant

      Are there any Cloverleaf commands to access SMATDB files?

      Basically I want to delete all A08s from SMAT older than a week, maybe a couple days. We regularly have 100k adt in a single daily smatdb file, I can’t think of a single time that I’ve been asked about an A08 older than a week and removing them would speed up searches for other msg types dramatically.

    • Creator
      Topic
    Viewing 5 reply threads
    • Author
      Replies
      • October 9, 2025 at 1:53 pm #122197
        Jim Kosloskey
        Participant

          Charlie Bursell wrote the attached some time ago. I believe this is the latest version.

          Attachments:
          You must be logged in to view attached files.

          email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

        • October 9, 2025 at 2:12 pm #122199
          Tim Jipson
          Participant

            I actually just found “smatdbdelete”, I think this is what I need. Would anyone have the proper syntax for this command?

             

          • October 9, 2025 at 2:14 pm #122200
            Tim Jipson
            Participant

              Thanks Jim, I’ll check that out

            • October 9, 2025 at 5:42 pm #122201
              Tim Jipson
              Participant

                Jim, All that script does is read messages out of smat and then creates a new file. I need to modify the smatdb file. I opened a ticket with Infor, hopefully I’ll get some useage info for smatdbdelete.

              • October 9, 2025 at 6:12 pm #122202
                Jim Kosloskey
                Participant

                  The conundrum here for Infor, I suspect, is SMAT is supposed to be the accurate representation of the messages that passed through that Thread. Allowing deletion of entries would open up the question of the accuracy of the SMAT.

                  What would happen if you had to prove a message you deleted actually traversed the thread? Will you keep another audit repository for that situation? How will that fit into the methodology your shop uses to troubleshoot? You may have already thought of the above so ignore if you want.

                  email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

                • October 9, 2025 at 6:26 pm #122203
                  Jim Kosloskey
                  Participant

                    Tim,

                    I found some help file that indicates:

                    smatdbdelete smatdbhandle ?deleteCondition?

                    The deleteCondition is to be an SQL WHERE statement describing the conditions for deletion.

                    I suspect this module is to be called via another Tcl Proc so you will need to construct the wrapper. Perhaps use Charlie’s code modified to add a deletion option and exploit the other code to get to the point of deletion.

                    email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

                    • October 9, 2025 at 6:33 pm #122204
                      Jim Kosloskey
                      Participant

                        There is more regarding the Tcl API for SMATdb here:

                        docs/clis_2022.09_clfisolh_op_en-us.pdf

                        Find that file in your /integrator directory path as indicated above. This is what is available in 2209, hopefully it exists in your release. If it does not email me and I will see what I can do.

                        email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

                  • Author
                    Replies
                  Viewing 5 reply threads
                  • You must be logged in to reply to this topic.