Page 1 of 1

[Solved] Multiple Logons / Member Locks

Posted: Wed Feb 09, 2011 1:40 pm
by RussCraig
Hi All,

Currently running 2.2.5, iOS v7.1, Open Access.

I can't seem to get past an issue I'm having with member locks. When someone goes to the login page for our application (custom login page, anonymous application), it loads fine if it is the only person accessing the system. As soon as a second person tries to access the login page, the page simply sits there with the spinning circle in the corner. When I check the Active Jobs list (WRKACTJOB), here's what I see (aside from all the PROFOUNDUI jobs):

Code: Select all

Opt  Subsystem/Job  User        Type  CPU %  Function        Status
       PUIADMIN     QTMHHTP1    BCI      .0  PGM-PUIMENUCL    SELW 
       PUIADMIN1    QTMHHTP1    BCI      .0  PGM-PUIMENUCL    LCKW 
Here is the link I'm testing this with:
https://xxx.xxx.xxx.com/profoundui/star ... suffixid=1


Here are the file overrides from PUIMENUCL:

Code: Select all

             OVRDBF     FILE(CLIENT) +
                          RCDFMTLCK((YCLIGRPN *SHRUPD)) +
                          OVRSCOPE(*JOB) +
                          SHARE(*YES)
             OVRDBF     FILE(PUILOGON) +
                          RCDFMTLCK((PUILOGON *SHRUPD)) +
                          OVRSCOPE(*JOB) +
                          SHARE(*YES)
             OVRDBF     FILE(PUIACTLG) +
                          RCDFMTLCK((PUIACTLG *SHRUPD)) +
                          OVRSCOPE(*JOB) +
                          SHARE(*YES)
             OVRDBF     FILE(PUIMAINT) +
                          RCDFMTLCK((PUIMAINT *SHRUPD)) +
                          OVRSCOPE(*JOB) +
                          SHARE(*YES)
Here is the information from the Work With Job Locks (same for both jobs):

Code: Select all

                              Object                      Member  ASP    
 Opt  Object      Library     Type       Lock     Status  Locks   Device 
      CLIENT      QS36F       *FILE-PHY  *SHRRD    HELD    YES           
      PROFOUNDUI  QSYS        *LIB       *SHRRD    HELD                  
      PUIACTLG    QS36F       *FILE-PHY  *SHRRD    HELD    YES           
      PUILOGON    QS36F       *FILE-PHY  *SHRRD    HELD    YES           
      PUIMAINT    QS36F       *FILE-PHY  *SHRRD    HELD    YES           
Is there any way to avoid these locks to allow multiple users to log in at the same time?

Please let me know. This is rather urgent. Thanks!

(edit: Solved. Please see below.)

Re: Multiple Logons / Member Locks

Posted: Thu Feb 10, 2011 12:01 pm
by RussCraig
I've been testing this more, and here is how I did my overrides when this was previously working. This is how they were before multiple logins stopped working, and I've tested it since and it still does not work:

Code: Select all

             OVRDBF     FILE(CLIENT) +
                          TOFILE(QS36F/CLIENT) +
                          SHARE(*YES)
             OVRDBF     FILE(PUILOGON) +
                          TOFILE(QS36F/PUILOGON) +
                          SHARE(*YES)
             OVRDBF     FILE(PUIACTLG) +
                          TOFILE(QS36F/PUIACTLG) +
                          SHARE(*YES)
             OVRDBF     FILE(PUIMAINT) +
                          TOFILE(QS36F/PUIMAINT) +
                          SHARE(*YES)

Re: Multiple Logons / Member Locks

Posted: Thu Feb 10, 2011 2:30 pm
by RussCraig
Please disregard. It related to how I opened and used the file PUIMAINT in my RPGLE program. Everything is functioning properly now.

Sorry for any confusion. Thanks.