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
------------------------------
Original Message:
Sent: Thu June 02, 2022 03:34 PM
From: Sameer
Subject: IBM Control Center - Queued Processes Cleanup
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
Original Message:
Sent: Thu February 20, 2020 10:27 AM
From: Peter Milakovich
Subject: IBM Control Center - Queued Processes Cleanup
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
- DELETE FROM CC_PROCESS WHERE STARTED < TO_DATE('2019/10/01' ,'yyyy/mm/dd')
- 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.
- 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')
- 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
Original Message:
Sent: Wed February 19, 2020 04:09 PM
From: Peter Milakovich
Subject: IBM Control Center - Queued Processes Cleanup
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