× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.