Re: Slow Performance with BPCS User Signon after Y2K

There are also loadsa other performance improvements by creating
logicals..especailly on cash/memo and month end *900 things.
use prtsqlinf on pgm...and check which access path takes over 1 second.or a
logical is not used..read sql statement and create logical
same as select .using either sql or dds.
another good one is clrpfm on server work files..zqwap ect.use a cl on
jobschedule overnight...others include echw/eclw ect ect.ie clear all your
work files periodically.
-----Original Message-----
From: Lacelle, Marc <LACELLE@rcmint.ca>
To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
Date: 05 January 2000 16:28
Subject: RE: Slow Performance with BPCS User Signon after Y2K


>Hi Ho Jeff.
>
> Quick work around to your problem. I believe there is a BMR on this.
>Look for BMR under SYS500B.
>
> 1. Build an index using SQL:
> on a command line: STRSQL
> once in SQL type: CREATE INDEX and press F4(prompt)
>
> 2. You will see:
> Index....... give it a name
> Library...... use your data library (example: BPCSF)
> File...... ZXO
> Library..... use your data library (example: BPCSF)
> Unique..... N
> Press Enter
>
> 3. You will see the 8 fields that make up ZXO
>
> 4. Put a 1 beside XOMENU
> Put a 2 beside XOSYS
> Put a 3 beside XORELN
> ignore ascending / descending order (leave blank)
> Press Enter
>
> 5. That is it.  Enjoy
>
> Marc Lacelle
> Royal Canadian Mint
>
>
>
>
>
>> ----------
>> From: ScottConsBPCS@aol.com[SMTP:ScottConsBPCS@aol.com]
>> Reply To: BPCS-L@midrange.com
>> Sent: Wednesday, January 05, 2000 10:29 AM
>> To: BPCS-L@midrange.com
>> Subject: Slow Performance with BPCS User Signon after Y2K
>>
>> We are experiencing a very unique problem.  Not sure wether it is related
>> to
>> Y2K or not.  I am aware of the access path for V4R2 for a user that needs
>> to
>> be created so that it doesn't take an hour for the user to signon
however,
>>
>> since Y2K, it seems to take forever for a user to signon.  I have
examined
>>
>> the sql trace and found the system is now building an index for the
ZX3L01
>>
>> and the ZXOL01.  It is taking our users approx 3 min to signon on a 720.
>> Prior to Y2K it was almost instant.  When I examine the trace, it says
>> that a
>> permanent access path cannot be built and that *MAP ASCEND is the
>> temporary
>> access path that was built.   If anyone could please help, it would be
>> appreciated....  Is this a Y2K issue, SQL optimizer bug?????/
>>
>> TIA
>>
>> Jeff
>> +---
>> | This is the BPCS Users Mailing List!
>> | To submit a new message, send your mail to BPCS-L@midrange.com.
>> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>> | Questions should be directed to the list owner: dasmussen@aol.com
>> +---
>>
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---
>

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---