MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

RE: Aldon & Index Advisor Indexes



fixed

Then don't treat it as a pseudo source object. Aldon will probably try to
recreate it when it's promoted. A *SRCMBR is only has the source copied.

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Tuesday, December 04, 2012 8:52 AM
To: Midrange Systems Technical Discussion
Subject: Re: Aldon & Index Advisor Indexes

There is no "index adviser object"

There are only index objects, doesn't matter if it was create via index
adviser or manually or via Aldon.

Charles


On Tue, Dec 4, 2012 at 9:31 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:

I don't know. I've never tried it. Given that Aldon can "retrieve" the
source code for a table/index when it is loaded to the release, I'm not
sure
what would happen if it tried to deal with an index advisor object.

I don't use SQL, but is a new index advisor object created whenever an
index
is recreated?

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Tuesday, December 04, 2012 8:23 AM
To: Midrange Systems Technical Discussion
Subject: Re: Aldon & Index Advisor Indexes

Why would you not just add the index as a pseudo-source object?

Charles


On Tue, Dec 4, 2012 at 9:14 AM, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:

I would create the index advisor source into a *SRCMBR object and tie it
to
the index as a dependent object. That way, whenever you need to modify
the
index, you can check them both out, modify the index, and then paste the
new
source into the *SRCMBR.

That should keep the loop closed in terms of audit tracking and whatever
change control standards you have.

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Sam_L
Sent: Monday, December 03, 2012 8:32 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Aldon & Index Advisor Indexes

Index Advisor makes it very easy to create new SQL indexes. However, I
have to add them to Aldon LMi, either as a non-source object, or create
the source and use the same approach as with DDS.

Any Aldon users with an opinion pro or con?

The non-source object approach is the easiest but I have this hankering
for source under source control... I can get the source back from Index
Advisor, but then I have to hand tweak it to fit into Aldon.

Sam
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact