Recall: [DB2-L] Cross System Loader between V8 and V9

Frank Crissy

Recall: [DB2-L] Cross System Loader between V8 and V9
Crissy, Frank would like to recall the message, "[DB2-L] Cross System Loader between V8 and V9".

The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Sherri Sterling

DB2 9
(in response to Frank Crissy)
I have been tasked with reporting all SYSADM changes whether it be data or
DML. Has anyone done this and can recommend a easy way of doing this
task?

Sherri Sterling
Bureau of the Public Debt
DB2 Systems Programmer
304-480-7585

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Raymond Bell

Re: DB2 9
(in response to Sherri Sterling)
In order:

No.
Get an ISV product.

Well, you did say 'an easy way'. Doing it by hand... oooh, gives me the shudders. And not just 'cause it's snowing here. :o)

Cheers,


Raymond

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: 01 December 2010 12:57
To: [login to unmask email]
Subject: [DB2-L] DB2 9

I have been tasked with reporting all SYSADM changes whether it be data or DML. Has anyone done this and can recommend a easy way of doing this task?

Sherri Sterling
Bureau of the Public Debt
DB2 Systems Programmer
304-480-7585
________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Phil Grainger

Re: DB2 9
(in response to Raymond Bell)
Hopefully you have a log analysis tool of some sort

If you do, it's just as case of looking for all changes done by your SYSADMs

If you don't...... I think you need one :)
Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk <blocked:: http://www.cogito.co.uk >

Attend IDUG 2011 - the premiere events for DB2 professionals.
IDUG North America < http://www.idug.org/na > , 2-6 May, Anaheim California
IDUG EMEA < http://www.idug.org/emea > , 14-18 November, Prague Czech Republic


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: 01 December 2010 12:57
To: [login to unmask email]
Subject: [DB2-L] DB2 9

I have been tasked with reporting all SYSADM changes whether it be data or DML. Has anyone done this and can recommend a easy way of doing this task?

Sherri Sterling
Bureau of the Public Debt
DB2 Systems Programmer
304-480-7585
________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Steen Rasmussen

Re: DB2 9
(in response to Phil Grainger)
I will ditto what Raymond said - get a tool if you don't already have
one.

If you want to take the hard path, you will need to write a routine to
scan through the LOG to identify which records were created by the
SYSADM users listed in the catalog.

When I was a DBA, I used a log tool (you can guess which one) to resume
processing from the prior day, extracting everything the SYSADM users
did into a report, which then could be retrieved upon request. The only
caveat using the log is that SELECTs are not reported, and AUDIT ALL on
tables are often not a sufficient solution, so I used CA Detector to
report on these statements (and BMC Apptune as well as IBM QM can do the
same).



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified database Administrator - DB2 9 DBA for z/OS





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
[login to unmask email]
Sent: Wednesday, December 01, 2010 6:57 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 9



I have been tasked with reporting all SYSADM changes whether it be data
or DML. Has anyone done this and can recommend a easy way of doing this
task?

Sherri Sterling
Bureau of the Public Debt
DB2 Systems Programmer
304-480-7585

________________________________

Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roger Hecq

Re: DB2 9
(in response to Steen Rasmussen)
Is this a one-time task or an ongoing process? Either way, the only
reasonable or cost effective way is with one of the log analysis tools.
I know of at least 4 good ones from the DB2 tool vendors.

Roger Hecq
MF IB USA DB Support
203-719-0492 / 19-337-0492



________________________________

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of
[login to unmask email]
Sent: Wednesday, December 01, 2010 7:57 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 9


I have been tasked with reporting all SYSADM changes whether it be data
or DML. Has anyone done this and can recommend a easy way of doing this
task?

Sherri Sterling
Bureau of the Public Debt
DB2 Systems Programmer
304-480-7585

________________________________


Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv