Omegamon 300 XE to PE conversion SMF database

Richard Gugel

Omegamon 300 XE to PE conversion SMF database
We have been using the Omegamon extractor to load DB2 SMF data into the Candle tables. I'm switching the jobs to load the DB2PM tables in a few weeks leaving the old data in the candle tables. I've got a number of queries that I would like to convert to the new columns and tables. I was wondering if anyone before me has written and edit macro or something like that to assist in converting these SQL's to the new columns. I realize that there are a number of columns that don't exist in the DB2 PM tables for example START_HOUR so I don't expect 100 percent conversion but even 90 percent would be nice. I didn't see anything in the Deep blue dive Redbook or in the documentation, but then I may have missed it.


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms