Re: Removing references to a library in your library list.

Rob,


select data_area_name, data_area_library, data_area_value
from qsys2.data_area_info
where data_area_value like '%WEBTOP%';

Does that run very slowly for you ?

I tried it a few times with different values and it took minutes, I added
a specific library to the where clause and it still took many seconds.

Thanks

Don





From: "Rob Berendt" <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 25/01/2022 10:52 PM
Subject: Removing references to a library in your library list.
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



Sharing this from bpcs-l...

Sometimes you want to obsolete a library from your system. For example,
let's say you never fully implemented WEBTOP and you want to remove it and
remove Websphere because of log4j issues. Common places for that library
to appear is in job descriptions and data areas. If you are current on
your OS and PTF's you could run these simple steps to find all occurrences
of these.

SELECT *
from qsys2.job_description_info
where library_list like('%WEBTOP%')
;

select data_area_name, data_area_library, data_area_value
from qsys2.data_area_info
where data_area_value like '%WEBTOP%';

For more information, including what level of the OS and PTF's required,
check out:
https://www.ibm.com/support/pages/node/1119123


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com