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
+---