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

[Penney, John]

Hey, Peter:
   
  This is an old version of the product (1994 IIRC) and I bet it issues another attach in that instance you highlight. 
   
  Any lister know for sure?
   
  Tks

Peter Bateman <peterbateman808 at hotmail.com> wrote:
      .hmmessage P  {  margin:0px;  padding:0px  }  body.hmmessage  {  FONT-SIZE: 10pt;  FONT-FAMILY:Tahoma  }            Hi John:
        
            With RMS an ALIAS should not cause another open unless the file options were incompatable with
            previous file options.
 
        i.e. FILE XXX PRIMARY READ SHARE
             FILE XXX DESIGNER ALIAS XXX2 WRITE SHARE
       you would 2 opens of XXX
       Let us hope that PH7.10E6 did not use the same rule for Oracle/RDB but have not actually
       looked.
       Regards,
        Peter Bateman


    
---------------------------------
  Date: Tue, 22 Apr 2008 10:58:10 -0700
From: resolutebay at yahoo.com
Subject: RE: VMS 6.2, Dec Rdb V6.1-13, Powerhouse 7.10E6 database attaches
To: peterbateman808 at hotmail.com

  Hey, Peter:
   
  What about the ALIAS syntax?
   
  Thanks, I'll add your fuel to the fire!
   
  JP

Peter Bateman <peterbateman808 at hotmail.com> wrote:
      .ExternalClass .EC_hmmessage P  {padding:0px;}  .ExternalClass body.EC_hmmessage  {font-size:10pt;font-family:Tahoma;}           Hi John:
 
           You definitely want to get rid of the OPEN # syntax as each OPEN with a different # causes
           another attach.
 
          Try running the application with DBAUDIT=FULL this will show when there is a new attach.
 
          If you do use GO or $QUICK from QDESIGN then the signon user will still have the attaches that
          QDESIGN opened. I believe SET DICT before the GO will cause QDESIGN to detach.
 
      Regards,
      Peter Bateman
 
         


    
---------------------------------
  Date: Tue, 22 Apr 2008 08:48:42 -0700
From: resolutebay at yahoo.com
Subject: RE: VMS 6.2, Dec Rdb V6.1-13, Powerhouse 7.10E6 database attaches
To: powerh-l at lists.sowder.com

  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.
  
---------------------------------
  Sign in now! Windows Live Messenger is giving you a chance to win $1000 a day until May 12th Check out SignInAndWIN.ca today! -- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.


  John M Penney, Partner
  The TechUnion Group 
  1532 Fern Street SW
  Olympia, WA  98502
   
  (360)789-8159
  
---------------------------------
  Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
  
---------------------------------
  Sign in now! Windows Live Messenger is giving you a chance to win $1000 a day until May 12th Check out SignInAndWIN.ca today! 


John M Penney, Partner
  The TechUnion Group 
  1532 Fern Street SW
  Olympia, WA  98502
   
  (360)789-8159

       
---------------------------------
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/3a198caa/attachment.htm