Collection names - any ideas?

Raymond Bell

Collection names - any ideas?
Yo Missy,

My guess is Platinum too, but I'm not 100%. Academic, really; SMF shows
they're not used, so I've released them into the wild i.e. freed them.
Saved the bind statements, just in case. Not much use without the DBRM
library (or is that package library these days?) but old habits die hard.

Cheers,


Raymond Bell
Database Administrator

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: 31 December 2003 15:42
To: [login to unmask email]
Subject: Re: Collection names - any ideas?


Raymond,

Hey - Happy New Year. I'd lean towards Platinum. Our Database is PTDB &
many of the collections look similar to ours. The DTMM looks like - maybe
- Development, ? If you used to have the Platinum suite & no longer do,
that's what I'd think.

Missy Case
FDR
701-275-6358




"Bell, Raymond"
<[login to unmask email] To:
[login to unmask email]
DG.COM> cc:
Sent by: DB2 Data bcc:
Base Discussion Subject: Collection names -
any ideas?
List
<[login to unmask email]
ORG>


12/31/03 04:03 AM
Please respond to
DB2 Database
Discussion list
at IDUG






Colleagues,

Just a quickie. I'm trying to track down the origin of a couple of
collection names we have here. I think they belong to products we don't
have installed anymore. The removal seems to have left these behind.
Anyway, do any of you know what product these collections are from?

DTMM_COLLECTION
PI1BDD_COLLECT
PI1CDD_COLLECT
PTDM_COLLECTION
PTMM_COLLECTION

There's also a coupla plans involved:

PTDMI1, PTMMI1, PI1BDD, PI1CDD

(s?)Trolling thru the SMF records shows no execution of these wee beasties
for a coupla months, so their days are numbered. I suspect at one stage we
had some CA/Platinum products installed but no one here is admitting as
much. I could be way off base here, but that's where my money is.

Anyway, if someone knows where these things may have come from I'd love to
hear your opinions. Particularly those of any long-lost colleagues that
may
or may not refer to themselves as dinosaurs... (David, if you stay under
that rock you'll never get warm enough to move about).



Raymond Bell
Database Administrator


This e-mail (and any attachments) may contain privileged and/or
confidential information. If you are not the intended recipient please do
not disclose, copy, distribute, disseminate or take any action in reliance
on it. If you have received this message in error please reply and tell us
and then delete it. Should you wish to communicate with us by e-mail we
cannot guarantee the security of any data outside our own computer systems.
For the protection of Legal & General's systems and staff, incoming emails
will be automatically scanned.

Any information contained in this message may be subject to applicable
terms and conditions and must not be construed as giving investment advice
within or outside the United Kingdom.

Representative only of the Legal & General marketing group, members of
which are regulated by the Financial Services Authority for the purposes of
advising on life assurance and investment products bearing Legal &
General's name.
Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London,
EC4N 4TP.
Registered in England no: 166055.

----------------------------------------------------------------------------
-----

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

David S Waugh

Re: Collection names - any ideas?
(in response to Raymond Bell)
Raymond:

I might be wrong about this, but I don't remember seeing any Platinum collections/plans/packages like this, and I've been installing it for customers for a long, long time.

It's more likely that they're from one of three things:
1. Someone came in and taught a class. These are leftovers.
2. Some Vendor came in and gave a product demo. These are leftovers.
3. Someone there was playing around with packages & collections shortly after they were introduced (in 2.3??), and didn't clean up after themselves.

If I were a betting man, I'd bet on #3. Especially with names like ..._COLLECTION

If the tables these plans/packages depend upon are the DB2 Sample Tables, that would be stronger evidence it's one of the three.

If the tables they depend upon are no longer in existance (and the DBRM libraries are gone as well), I'd say you're pretty safe to just FREE them. However, I'd recommend trying to re-create the BIND parameters and save them (and the DBRM libraries) before you drop anything, just in case. Oh, what the heck - Live Dangerously!

David Waugh, Dinosaur Extraordinaire
DSW Consulting & Services

P.S. It's a heated rock - very cozy. Really important for these Lincoln Nebraska winters (it was -8 F last night - Brrrrrrrrrr!)

_.-_
__.' o "-.
___----"" ,,,'
__--" _-_ ^^;
____--"" ___ _-\" `""
..--===-------""" "( __-" ,}
.'_/"\
.'/" `\`._
"-_c " '


-- "Bell, Raymond" <[login to unmask email]> wrote:
Colleagues,

Just a quickie. I'm trying to track down the origin of a couple of
collection names we have here. I think they belong to products we don't
have installed anymore. The removal seems to have left these behind.
Anyway, do any of you know what product these collections are from?

DTMM_COLLECTION
PI1BDD_COLLECT
PI1CDD_COLLECT
PTDM_COLLECTION
PTMM_COLLECTION

There's also a coupla plans involved:

PTDMI1, PTMMI1, PI1BDD, PI1CDD

(s?)Trolling thru the SMF records shows no execution of these wee beasties
for a coupla months, so their days are numbered. I suspect at one stage we
had some CA/Platinum products installed but no one here is admitting as
much. I could be way off base here, but that's where my money is.

Anyway, if someone knows where these things may have come from I'd love to
hear your opinions. Particularly those of any long-lost colleagues that may
or may not refer to themselves as dinosaurs... (David, if you stay under
that rock you'll never get warm enough to move about).



Raymond Bell
Database Administrator



________________________________________________________________
The best thing to hit the internet in years - Juno SpeedBand!
Surf the web up to FIVE TIMES FASTER!
Only $14.95/ month - visit www.juno.com to sign up today!

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm