VMS 6.2, Dec Rdb V6.1-13, Powerhouse 7.10E6 database attaches

[Penney, John]

Hello again, fellow PH listers:
   
  I've been asked to determine how many PH attaches Quick makes to Rdb. Our DBA (in Denver) says he sees between 2 and 5 per user. He's concerned about exceeding the 2,032 attach limit and having to upgrade because of same. i.e. RDB, PH, VMS O/S
   
  I conclude we have one d/b attach for each file statement referencing a unique database.  So if we have 3 databases we get 3 attaches?
   
  What about ALIASes? 
   
  What effect (if any) is there in using a CLOSE command but FWIW, I believe that only works for flat or indexed files, not relational databases?
   
  I don't know off the top, Google wasn't that much help, how we can minimize the attaches which is the focus of the questions. I recall DISCONNECT DEFAULT works in SQL, but......
   
  TIA
   
  Best and thanks to all who responded to my earlier....
   
  JP

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080422/969792d3/attachment.html