At IBM i 7.5 Management Central is no longer supported. In fact if you try
STRTCPSVR SERVER(*MGTC)
CPF9898: SERVER *MGTC NOT SUPPORTED.
TCP1A10: MGTC server not started.
TCP1A77: STRTCPSVR completed successfully; however errors occurred.
WRKLIB LIB(QMGTC*)
shows: QMGTC, QMGTC2
CREATE TABLE QTEMP.QMGTCUNION AS (
select *
from table(OBJECT_STATISTICS(
'QMGTC',
'*ALL'
)) x) WITH DATA;
INSERT INTO QTEMP.QMGTCUNION (
select *
from table(OBJECT_STATISTICS(
'QMGTC2',
'*ALL'
)) x);
SELECT OBJLIB, SUM(OBJSIZE) AS LIBRARY_SIZE, MAX(CHANGE_TIMESTAMP) AS LAST_CHANGED
FROM QTEMP.QMGTCUNION
GROUP BY OBJLIB;
Returns:
| QMGTC2 |
113394212864 |
2023-03-31 00:00:28.000000 |
| QMGTC |
609210368 |
2023-03-11 21:33:36.000000 |
The last change date on QMGTC is the date when we migrated to our Power 10.
But QMGTC2 has 113GB and it's changing.
That midnight timestamp is not from any WRKJOBSCDE entries but it does match CFGPFRCOL<F4> CYCTIME
According to
SELECT OBJLIB, OBJNAME, OBJTYPE, OBJSIZE, CHANGE_TIMESTAMP
FROM QTEMP.QMGTCUNION
ORDER BY OBJSIZE desc;
Almost all of the largest objects are *MGTCOL objects .
According to the following, we've got them going back for years, but the most recent was at midnight:
SELECT OBJLIB, OBJNAME, OBJTYPE, OBJSIZE, OBJCREATED
FROM QTEMP.QMGTCUNION
WHERE OBJTYPE='*MGTCOL'
ORDER BY OBJCREATED;
I'm assuming I can delete the older ones.
Should it still be collecting this stuff? If so, is the library name a misnomer?
------------------------------
Robert Berendt IBMChampion
------------------------------