[progress Communities] [progress Openedge Abl] Forum Post: Is It Possible To Add An Index...

  • Thread starter Thread starter Dmitri Levin
  • Start date Start date
Status
Not open for further replies.
D

Dmitri Levin

Guest
I would say "YES" and "NO". Yes because I just did it. No because it was not as easy as I was thinking it would be in 11.7. So I started 11.7 database with -usernotifytime 600 paramter. ( 600 sec = 10 minutes it is ) Then added an index inactive. Then just before running idxactivate I changed in promon R&D 4/7/8 User notify time 60 seconds ( 1 min ). Run idxactivate. First I got the list of 100 processes OpenEdge Release 11.7 as of Fri Mar 17 19:00:35 EDT 2017 Index Activate: Primary index in use for building keys. (14815) Index Activate: index order-data-ix in use for building keys. (15883) Index Activate: BEGIN activation of order-data-pk. (13258) Index Activate: recs value: 100 refresh rate: 10. (13259) Index record(s) updated at timestamp 1492712916. (18223) Usr Name Type Pid Timestamp 24 alpbatch ABL 46727392 1492312983 25 alpbatch ABL 59900078 1492312983 etc Connections with timestamps older than 1492712916 exist. (13246) Do you wish to continue waiting..... Type y to continue (y/n). (13247) y I answered "y" several times. After that the list became much smaller. I was expecting that after 1 minute the list will be empty and process will finish. That did not happen. About 10 processes (webspeed and users) were still there after several minutes. More than likely those processes were idle. After I manually disconnected those 10 processes from the database idxactivate successfully finished. Usr Name Type Pid Timestamp 320 p2sqlsvc ABL 6568 1492312983 <-- that is Pro2sql running on a Windows somewhere else was last one I disconnected Connections with timestamps older than 1492712916 exist. (13246) Do you wish to continue waiting..... Type y to continue (y/n). (13247) y Index Activate: Index order-data-pk No. 2394 - 0 keys added. (13244) Index Activate: Index order-data-pk No. 2394 - 0 keys processed. (13245) Index Activate: Index order-data-pk has been activated. (15878) So it works. Can it be improved? Do I need to set -usernotifytime 600 paramter for each and every 4GL client? I thought that is a server parameter since it is in promon Administrative Functions.

Continue reading...
 
Status
Not open for further replies.
Back
Top