RE:

["Norbut, Jim" <Jim.Norbut@xxxxxxxxxxxxxxx>]

Indeed......just did find 

QSYS2

completely missed that one.

Just may be able to do it myself....i'm hoping.

Jim


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Loyd Goodbar
Sent: Tuesday, June 08, 2010 2:39 PM
To: Midrange Systems Technical Discussion
Subject: Re:

Have a look at the SYS* files in QSYS2, such as SYSTABLES, SYSCOLUMNS,
etc.
You need to redevelop this script for IBM DB2. This script is VERY
specific
to the workings of SQL Server.

DB2 on OS/400 / i5/OS / i/OS doesn't have its own version, but is tied
to
the OS. (Disregarding PTFs.) Is there a minimum version of the IBM
operating
system you should run?

Running DB2 on IBM is different from SQL Server, things work
differently.
Some of the information is not applicable, such as checking for the
sample
databases pubs and northwind.

I would be less worried about translating the script, and ask what the
audit
is trying to achieve. What are the risks being identified or mitigated?
Then
develop an appropriate DB2 script. You may run a combination of SQL
scripts
and OS commands to achieve similar information.

HTH,
Loyd



On Tue, Jun 8, 2010 at 2:07 PM, Norbut, Jim
<Jim.Norbut@xxxxxxxxxxxxxxx>wrote:

> Our Microsoft SQL admin has this "quarterly DB audit script" which he
> runs on our Microsoft SQL  boxes
>
> And uses internal database names from Microsoft sql to get information
.
> I am looking for something comparable to appease our auditors for the
> iSeries
>
> I've been given the name of a product called BrotherWatchdog
>
> But at $10k it's a bit pricey.
>
>
>
> I've looked around on some iSeries sites for some example of something
> close
>
> Using DB2 nomenclature....and internal system table to query off of.
>
>
>
> But either I am looking in the wrong spot or it something I just don't
> know where to look
>
>
>
> Is creating a script like this which get info from system internal
> tables
>
> Even realistic w/o getting a specialized utility/product.