Re: identify/list any duplicate objects from any two libraries.

Rob,

Need to tweak.
12,000 items.
Not accounting for object, attribute types.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, February 09, 2015 1:21 PM
To: Midrange Systems Technical Discussion
Subject: Re: identify/list any duplicate objects from any two libraries.

RTVDSKINF

WITH t1 AS (
SELECT DIOBNM, COUNT(*) AS NUMBEROF
FROM QUSRSYS/QAEZDISK q
GROUP BY DIOBNM
HAVING COUNT(*)>1 )
SELECT q.DIOBNM, DioBLI, DIOBTP, DiOBAT, DIOBTX, t1.numberof FROM QUSRSYS/QAEZDISK Q JOIN T1 ON q.diobnm = t1.diobnm WHERE DIOBLI<>' ' AND Q.DIOBNM<>' '
ORDER BY Q.DIOBNM, DIOBLI, DIOBTP


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steinmetz, Paul"<PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 02/09/2015 12:53 PM
Subject: identify/list any duplicate objects from any two
libraries.
Sent by: "MIDRANGE-L"<midrange-l-bounces@xxxxxxxxxxxx>



In reference to the duplicate object LIBLIST in QSYS2,

What is the quickest and easiest way to identify/list any duplicate
objects from any two libraries?

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.com/