Indus Passport software and DB2

[login to unmask email]

Indus Passport software and DB2
Hi,

We have Passport here in production R5+ customized and 7.0 in Demo
(A/P, Inventory, purchasing, doc mgmt, MSDS, AITTS, etc.). In the
three years I've been supporting the system, I've seen nothing in
the application that ties it to a specific release of DB2 (for upward
compatibility). They just generate TYPE 1 indexes for old DB2 systems.
We have converted all of our indexes to TYPE 2. In fact they provide
much generated DDL that we find necessary to modify (i.e., simple
tablespaces)!

Regards,

Michael Levine
Premier Data Services, Inc


>Steve:
>Currently have 7.0.1(Baseline) in our test region with DB2 V5. From the
>installation documentation I have read for PassPort, it looks like Indus is
>still recommending Type 1 index for their tables. I believe that DB2 6.0 does
>not support type 1 indexes any longer. We have created the tables with Type 2,
>but this Baseline Test Region has the minimal amount of Baseline Test Data
>needed to work.
>Best Regards,
>Fred O.
>
>
>
>
>
>"Whittaker, Stephen" <[login to unmask email]> on 12/21/99 12:53:17 PM
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>To: [login to unmask email]
>cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
>Subject: Indus software and DB2
>
>
>
>
> Is anyone out there using the Indus/Passport product??
>
>We've currently installed Indus/Passport Version 7.0 and we are currently
>running
>DB2 V5. I'm looking at going to DB2 Version 6 next year and I was wondering
>if anyone
>is currently running Indus 7.0 with DB2 V6?? My understanding is that Indus
>has not
>certified DB2 V6 to run with their Version 7.0 and I'm trying to get some
>clarification on
>this.
> Any information would be greatly appreciated.
>
>Thanks:
>--Steve....
>
> Steve Whittaker
> DB2/DBA Carolina Power & Light
> Mail stop: CPB 17A4 - Raleigh
> Email: [login to unmask email]
> Phone: (919) 546-7267
>
>
>
>
>
>
>
>


>
>



Myron Miller

Re: Indus software and DB2
(in response to Mike_Levine@TEKHELP.NET)
I put in Indus 6 on a DB2 release 4 client's shop and
made all of the indexes Type 2 a couple of years ago.
It has run in production just fine with them since
then with moderate volumes. One major DBA consultant
that works very closely with INDUS and a number of
their shops about had kittens because I had changed to
type 2 indexes, but the system ran just fine.
Switching to type 2 indexes should be done as soon as
possible - the other performance benefits are
definitely worth it.

--- Fred Occhipinti <[login to unmask email]> wrote:
> Steve:
> Currently have 7.0.1(Baseline) in our test region
> with DB2 V5. From the
> installation documentation I have read for PassPort,
> it looks like Indus is
> still recommending Type 1 index for their tables. I
> believe that DB2 6.0 does
> not support type 1 indexes any longer. We have
> created the tables with Type 2,
> but this Baseline Test Region has the minimal amount
> of Baseline Test Data
> needed to work.
> Best Regards,
> Fred O.
>
>
>
>
>
> "Whittaker, Stephen" <[login to unmask email]> on
> 12/21/99 12:53:17 PM
>
> Please respond to DB2 Data Base Discussion List
> <[login to unmask email]>
>
> To: [login to unmask email]
> cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
> Subject: Indus software and DB2
>
>
>
>
> Is anyone out there using the Indus/Passport
> product??
>
> We've currently installed Indus/Passport Version 7.0
> and we are currently
> running
> DB2 V5. I'm looking at going to DB2 Version 6 next
> year and I was wondering
> if anyone
> is currently running Indus 7.0 with DB2 V6?? My
> understanding is that Indus
> has not
> certified DB2 V6 to run with their Version 7.0 and
> I'm trying to get some
> clarification on
> this.
> Any information would be greatly appreciated.
>
> Thanks:
> --Steve....
>
> Steve
> Whittaker
> DB2/DBA Carolina
> Power & Light
> Mail stop: CPB 17A4
> - Raleigh
> Email:
> [login to unmask email]
> Phone: (919)
> 546-7267
>
>
> To change your subscription options or to cancel
> your subscription visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can be
>
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com



Fred Occhipinti

Re: Indus software and DB2
(in response to Myron Miller)
As long as you are benchmarking everything, that is fine. Our current release
of PassPort (5.0.3 heavily customized) requires a certain table to remain Type
1 (TIDECOVL). When this table is converted to Type 2 index, the response time
is exponentially larger (where you can measure in many seconds) versus Type 1.
The only characteristic about this table is that it is really small. On
version 5.0 of DB2 there is an IBM fix regarding small volume tables with
Indexes(Indices?). Our systems group has not applied the maintenance on 5.0 yet
to see if it works. DB2 V6.0 is not installed yet, so we are not sure if the
problem was resolved with that release.
Maybe the solution in this situation is to delete the index altogether for small
tables?
Best Regards,
Fred O.





Myron Miller <[login to unmask email]> on 12/21/99 04:01:38 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
Subject: Re: Indus software and DB2




I put in Indus 6 on a DB2 release 4 client's shop and
made all of the indexes Type 2 a couple of years ago.
It has run in production just fine with them since
then with moderate volumes. One major DBA consultant
that works very closely with INDUS and a number of
their shops about had kittens because I had changed to
type 2 indexes, but the system ran just fine.
Switching to type 2 indexes should be done as soon as
possible - the other performance benefits are
definitely worth it.

--- Fred Occhipinti <[login to unmask email]> wrote:
> Steve:
> Currently have 7.0.1(Baseline) in our test region
> with DB2 V5. From the
> installation documentation I have read for PassPort,
> it looks like Indus is
> still recommending Type 1 index for their tables. I
> believe that DB2 6.0 does
> not support type 1 indexes any longer. We have
> created the tables with Type 2,
> but this Baseline Test Region has the minimal amount
> of Baseline Test Data
> needed to work.
> Best Regards,
> Fred O.
>
>
>
>
>
> "Whittaker, Stephen" <[login to unmask email]> on
> 12/21/99 12:53:17 PM
>
> Please respond to DB2 Data Base Discussion List
> <[login to unmask email]>
>
> To: [login to unmask email]
> cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
> Subject: Indus software and DB2
>
>
>
>
> Is anyone out there using the Indus/Passport
> product??
>
> We've currently installed Indus/Passport Version 7.0
> and we are currently
> running
> DB2 V5. I'm looking at going to DB2 Version 6 next
> year and I was wondering
> if anyone
> is currently running Indus 7.0 with DB2 V6?? My
> understanding is that Indus
> has not
> certified DB2 V6 to run with their Version 7.0 and
> I'm trying to get some
> clarification on
> this.
> Any information would be greatly appreciated.
>
> Thanks:
> --Steve....
>
> Steve
> Whittaker
> DB2/DBA Carolina
> Power & Light
> Mail stop: CPB 17A4
> - Raleigh
> Email:
> [login to unmask email]
> Phone: (919)
> 546-7267
>
>
> To change your subscription options or to cancel
> your subscription visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can be
>
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com








[login to unmask email]

Re: Indus software and DB2
(in response to Fred Occhipinti)
Hi Myron,

I don't recall any specific recommendations from INDUS
advising not to convert to TYPE 2. However, in high volume
systems you did have to be careful with full index scans now
locking many data pages but we corrected this with use of
REOPT(VARS) on selective programs.

Regards,

Michael Levine
Premier Data Services, Inc.



>I put in Indus 6 on a DB2 release 4 client's shop and
>made all of the indexes Type 2 a couple of years ago.
>It has run in production just fine with them since
>then with moderate volumes. One major DBA consultant
>that works very closely with INDUS and a number of
>their shops about had kittens because I had changed to
>type 2 indexes, but the system ran just fine.
>Switching to type 2 indexes should be done as soon as
>possible - the other performance benefits are
>definitely worth it.
>
>--- Fred Occhipinti <[login to unmask email]> wrote:
>> Steve:
>> Currently have 7.0.1(Baseline) in our test region
>> with DB2 V5. From the
>> installation documentation I have read for PassPort,
>> it looks like Indus is
>> still recommending Type 1 index for their tables. I
>> believe that DB2 6.0 does
>> not support type 1 indexes any longer. We have
>> created the tables with Type 2,
>> but this Baseline Test Region has the minimal amount
>> of Baseline Test Data
>> needed to work.
>> Best Regards,
>> Fred O.
>>
>>
>>
>>
>>
>> "Whittaker, Stephen" <[login to unmask email]> on
>> 12/21/99 12:53:17 PM
>>
>> Please respond to DB2 Data Base Discussion List
>> <[login to unmask email]>
>>
>> To: [login to unmask email]
>> cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
>> Subject: Indus software and DB2
>>
>>
>>
>>
>> Is anyone out there using the Indus/Passport
>> product??
>>
>> We've currently installed Indus/Passport Version 7.0
>> and we are currently
>> running
>> DB2 V5. I'm looking at going to DB2 Version 6 next
>> year and I was wondering
>> if anyone
>> is currently running Indus 7.0 with DB2 V6?? My
>> understanding is that Indus
>> has not
>> certified DB2 V6 to run with their Version 7.0 and
>> I'm trying to get some
>> clarification on
>> this.
>> Any information would be greatly appreciated.
>>
>> Thanks:
>> --Steve....
>>
>> Steve
>> Whittaker
>> DB2/DBA Carolina
>> Power & Light
>> Mail stop: CPB 17A4
>> - Raleigh
>> Email:
>> [login to unmask email]
>> Phone: (919)
>> 546-7267
>>
>>
>> To change your subscription options or to cancel
>> your subscription visit the
>> DB2-L webpage at http://www.ryci.com/db2-l. The
>> owners of the list can be
>>
>>
>>
>> To change your subscription options or to cancel
>> your subscription visit the DB2-L webpage at
>> http://www.ryci.com/db2-l. The owners of the list
>> can
>>
>
>__________________________________________________
>Do You Yahoo!?
>Thousands of Stores. Millions of Products. All in one place.
>Yahoo! Shopping: http://shopping.yahoo.com
>
>
>


>
>



[login to unmask email]

Re: Indus software and DB2
(in response to Mike_Levine@TEKHELP.NET)
Hi,

Never, never, never drop any UNIQUE baseline indexes! This
is how INDUS enforces uniqueness. The code often checks for
a -803 and takes appropriate action. You can sometimes drop
non-unique indexes but NEVER unique ones.

Regards,

Michael Levine
Premier Data Services, Inc.


>As long as you are benchmarking everything, that is fine. Our current release
>of PassPort (5.0.3 heavily customized) requires a certain table to remain Type
>1 (TIDECOVL). When this table is converted to Type 2 index, the response time
>is exponentially larger (where you can measure in many seconds) versus Type 1.
>The only characteristic about this table is that it is really small. On
>version 5.0 of DB2 there is an IBM fix regarding small volume tables with
>Indexes(Indices?). Our systems group has not applied the maintenance on
5.0 yet
>to see if it works. DB2 V6.0 is not installed yet, so we are not sure if the
>problem was resolved with that release.
>Maybe the solution in this situation is to delete the index altogether for
small
>tables?
>Best Regards,
>Fred O.
>
>
>
>
>
>Myron Miller <[login to unmask email]> on 12/21/99 04:01:38 PM
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>To: [login to unmask email]
>cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
>Subject: Re: Indus software and DB2
>
>
>
>
>I put in Indus 6 on a DB2 release 4 client's shop and
>made all of the indexes Type 2 a couple of years ago.
>It has run in production just fine with them since
>then with moderate volumes. One major DBA consultant
>that works very closely with INDUS and a number of
>their shops about had kittens because I had changed to
>type 2 indexes, but the system ran just fine.
>Switching to type 2 indexes should be done as soon as
>possible - the other performance benefits are
>definitely worth it.
>
>--- Fred Occhipinti <[login to unmask email]> wrote:
>> Steve:
>> Currently have 7.0.1(Baseline) in our test region
>> with DB2 V5. From the
>> installation documentation I have read for PassPort,
>> it looks like Indus is
>> still recommending Type 1 index for their tables. I
>> believe that DB2 6.0 does
>> not support type 1 indexes any longer. We have
>> created the tables with Type 2,
>> but this Baseline Test Region has the minimal amount
>> of Baseline Test Data
>> needed to work.
>> Best Regards,
>> Fred O.
>>
>>
>>
>>
>>
>> "Whittaker, Stephen" <[login to unmask email]> on
>> 12/21/99 12:53:17 PM
>>
>> Please respond to DB2 Data Base Discussion List
>> <[login to unmask email]>
>>
>> To: [login to unmask email]
>> cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
>> Subject: Indus software and DB2
>>
>>
>>
>>
>> Is anyone out there using the Indus/Passport
>> product??
>>
>> We've currently installed Indus/Passport Version 7.0
>> and we are currently
>> running
>> DB2 V5. I'm looking at going to DB2 Version 6 next
>> year and I was wondering
>> if anyone
>> is currently running Indus 7.0 with DB2 V6?? My
>> understanding is that Indus
>> has not
>> certified DB2 V6 to run with their Version 7.0 and
>> I'm trying to get some
>> clarification on
>> this.
>> Any information would be greatly appreciated.
>>
>> Thanks:
>> --Steve....
>>
>> Steve
>> Whittaker
>> DB2/DBA Carolina
>> Power & Light
>> Mail stop: CPB 17A4
>> - Raleigh
>> Email:
>> [login to unmask email]
>> Phone: (919)
>> 546-7267
>>
>>
>> To change your subscription options or to cancel
>> your subscription visit the
>> DB2-L webpage at http://www.ryci.com/db2-l. The
>> owners of the list can be
>>
>>
>>
>> To change your subscription options or to cancel
>> your subscription visit the DB2-L webpage at
>> http://www.ryci.com/db2-l. The owners of the list
>> can
>>
>
>__________________________________________________
>Do You Yahoo!?
>Thousands of Stores. Millions of Products. All in one place.
>Yahoo! Shopping: http://shopping.yahoo.com
>
>
>
>
>
>
>
>


>
>



Myron Miller

Re: Indus software and DB2
(in response to Mike_Levine@TEKHELP.NET)
When I installed the system and supported it, INDUS
itself didn't have any recommendations. But one
independent consultant who had a lot of influence with

INDUS and a number of INDUS customers did actively
recommend against Type 2's. He was referred to the
installation I was supporting by INDUS for additional
performance and tech support.

What you're saying about the potential for a large
number of pass-thru locks is very true. We found this
especially due to the large number of SQL betweens
using host variables as INDUS uses this technique a
lot for page scrolling. REOPT(VARS) certainly helps
and I believe is required for several of the programs.
We also changed a number of the impacted tables to
use row level locking rather than page. This
significantly reduced locking contention problems.

This shop also found, the hard way, that it was really
critical to stay pretty current with DB2 maintenance.
That helped a lot of the performance issues.
--- [login to unmask email] wrote:
> Hi Myron,
>
> I don't recall any specific recommendations from
> INDUS
> advising not to convert to TYPE 2. However, in high
> volume
> systems you did have to be careful with full index
> scans now
> locking many data pages but we corrected this with
> use of
> REOPT(VARS) on selective programs.
>
> Regards,
>
> Michael Levine
> Premier Data Services, Inc.
>
>
>
> >I put in Indus 6 on a DB2 release 4 client's shop
> and
> >made all of the indexes Type 2 a couple of years
> ago.
> >It has run in production just fine with them since
> >then with moderate volumes. One major DBA
> consultant
> >that works very closely with INDUS and a number of
> >their shops about had kittens because I had changed
> to
> >type 2 indexes, but the system ran just fine.
> >Switching to type 2 indexes should be done as soon
> as
> >possible - the other performance benefits are
> >definitely worth it.
> >
> >--- Fred Occhipinti <[login to unmask email]>
> wrote:
> >> Steve:
> >> Currently have 7.0.1(Baseline) in our test region
> >> with DB2 V5. From the
> >> installation documentation I have read for
> PassPort,
> >> it looks like Indus is
> >> still recommending Type 1 index for their tables.
> I
> >> believe that DB2 6.0 does
> >> not support type 1 indexes any longer. We have
> >> created the tables with Type 2,
> >> but this Baseline Test Region has the minimal
> amount
> >> of Baseline Test Data
> >> needed to work.
> >> Best Regards,
> >> Fred O.
> >>
> >>
> >>
> >>
> >>
> >> "Whittaker, Stephen" <[login to unmask email]>
> on
> >> 12/21/99 12:53:17 PM
> >>
> >> Please respond to DB2 Data Base Discussion List
> >> <[login to unmask email]>
> >>
> >> To: [login to unmask email]
> >> cc: (bcc: Fred Occhipinti/Juno/Nuclear/FplNuc)
> >> Subject: Indus software and DB2
> >>
> >>
> >>
> >>
> >> Is anyone out there using the Indus/Passport
> >> product??
> >>
> >> We've currently installed Indus/Passport Version
> 7.0
> >> and we are currently
> >> running
> >> DB2 V5. I'm looking at going to DB2 Version 6
> next
> >> year and I was wondering
> >> if anyone
> >> is currently running Indus 7.0 with DB2 V6?? My
> >> understanding is that Indus
> >> has not
> >> certified DB2 V6 to run with their Version 7.0
> and
> >> I'm trying to get some
> >> clarification on
> >> this.
> >> Any information would be greatly appreciated.
> >>
> >> Thanks:
> >> --Steve....
> >>
> >> Steve
> >> Whittaker
> >> DB2/DBA
> Carolina
> >> Power & Light
> >> Mail stop: CPB
> 17A4
> >> - Raleigh
> >> Email:
> >> [login to unmask email]
> >> Phone:
> (919)
> >> 546-7267
> >>
> >>
> >> To change your subscription options or to cancel
> >> your subscription visit the
> >> DB2-L webpage at http://www.ryci.com/db2-l. The
> >> owners of the list can be
> >>
> >>
> >>
> >> To change your subscription options or to cancel
> >> your subscription visit the DB2-L webpage at
> >> http://www.ryci.com/db2-l. The owners of the list
> >> can
> >>
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Thousands of Stores. Millions of Products. All in
> one place.
> >Yahoo! Shopping: http://shopping.yahoo.com
> >
> >
> >To change your subscription options or to cancel
> your subscription visit
> the DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can
>
> >
> >
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com