P
Paul Koufalis
Guest
OE 11.7.1 on AIX 6.1 I am trying to activate indexes online. What am I doing wrong? My database is started with -usernotifytime 180. I am running _proutil db -C idxactivate table.index recs 10000 refresh 200 Here is my output: Index Activate: Primary index in use for building keys. (14815) Index Activate: index abc123 in use for building keys. (15883) Index Activate: BEGIN activation of newIndex. (13258) Index Activate: recs value: 10000 refresh rate: 200. (13259) Index record(s) updated at timestamp 1501255613. (18223) Usr Name Type Pid Timestamp 54 demon ABL 9634114 1501084546 55 demon ABL 43581842 1501084546 ... a bunch more ... Connections with timestamps older than 1501255613 exist. (13246) Do you wish to continue waiting..... Type y to continue (y/n). (13247) Index Activate: User canceled Idxactivate operation - index was not activated. (15925) I answered "y" and the prompt came back 200 seconds later. The documentation says that idxactivate will wait: For OpenEdge Release 11.7 and later, if you have enabled Database Client Notification (-usernotifytime), IDXACTIVATE waits until all connected clients respond to the notification, and then proceeds. Note that timestamp 1501084546 = Wednesday 26 July 2017 11:55:46 Eastern = BEFORE the database was started. What am I doing wrong? Paul
Continue reading...
Continue reading...