Managed File Transfer

 View Only
  • 1.  IBM Control Center - Queued Processes Cleanup

    Posted Thu February 20, 2020 08:36 AM
    I know via the web console I can go to the Queued Processes monitor, select a row and click the 'Clear Process' button to clear it out from the Queued Processes monitor.

    Is there a way to do this in bulk other than manually clicking 'select all' and going page by page?  I'm assuming it would need to be done via SQL and hitting the database directly?

    ------------------------------
    Peter Milakovich
    ------------------------------

    #filetransfer
    #DataExchange


  • 2.  RE: IBM Control Center - Queued Processes Cleanup

    Posted Thu February 20, 2020 10:28 AM
    I've learned a few things since I posted yesterday.  First, is that you can increase the number of displayed rows in the queued processes monitor (up to 1000).  So if you increase the value up to 1000, you're able to select and manually clear up to 1000 processes at once from a single screen.  I was also provided the following sql solution from IBM:

    To get rid of Queued processes

    1. DELETE FROM CC_PROCESS WHERE STARTED < TO_DATE('2019/10/01' ,'yyyy/mm/dd')
    2. For this query perhaps pick a date that's 30 days in the past, or however far back you're retaining data in the EVENTS table (as opposed to 2019/10/1). This will get rid of all entries that are so old there's no data to summarize.
    3. UPDATE CC_PROCESS SET PROC_STATUS='user completed ns' WHERE PROC_STATUS NOT IN ('failed', 'success', 'user completed', 'errors') AND STARTED < TO_DATE('2019-10-31', '%Y-%m-%d')
    4. Pick a date for this query that guarantees only processes that should have finished but didn't get summarized (this query essentially does what clear process does)


    ------------------------------
    Peter Milakovich
    ------------------------------



  • 3.  RE: IBM Control Center - Queued Processes Cleanup

    Posted Thu June 02, 2022 03:34 PM
    Thank you so much. This has been a pain since a very long time.  
    Can you tell us how you changed it to 1000 instead of the default 25?

    ------------------------------
    Sameer
    ------------------------------



  • 4.  RE: IBM Control Center - Queued Processes Cleanup

    Posted Thu June 02, 2022 04:08 PM
    Ouch.  That post is two years old!  Wish I'd documented that piece as well.  I think it's in System Settings --> Properties.  I just can't remember where.  I know some properties are in the new gui and others are still kept in the old console.  I'll take a peek and see if I can jog my memory.

    ------------------------------
    Peter Milakovich
    ------------------------------



  • 5.  RE: IBM Control Center - Queued Processes Cleanup

    Posted Fri June 03, 2022 02:15 PM
    The process for clearing queued processes is both incomplete and out-of-date.  It should not be used as is.  In fact, you should not perform updates and/or deletes from the Control Center database tables without specific instructions from the Control Center support team.

    ------------------------------
    Dale Ander
    ------------------------------



  • 6.  RE: IBM Control Center - Queued Processes Cleanup

    Posted Fri June 03, 2022 02:15 PM


    ------------------------------
    Dale Ander
    ------------------------------



  • 7.  RE: IBM Control Center - Queued Processes Cleanup

    Posted Fri June 03, 2022 02:15 PM
    To change the number of rows displayed per table - at least for some tables, you have to update the "User Preferences" values under "User Settings" in the Web console.

    It depends on the version of Control Center you have, but for the one I have, if I click on my user ID over on the right hand side, a drop down menu appears, from where I can select "User Settings"

    ------------------------------
    Dale Ander
    ------------------------------