Search results

  1. R

    How to get record read stat from client memory

    Thanks Rob. But why would it go every time through the buffer pool on server? I do understand if I force an exclusive lock,it has go and fetch the record from server but I am just reading with no-lock. The background is, we suspect there are lot of pgms in our code base which are repeatedly...
  2. R

    How to get record read stat from client memory

    Hello Everybody: OpenEdge Ver 10.2b. Is there anyway to get record read stat just performed on client memory. from what I understand, VSTs/Promonitor provide CRUD info based on buffer pool and disk access. so say, if my client pgm is reading a record 10 times (with no-lock and -rereadnolock...
  3. R

    Dataserver connection issue

    Hello: we are trying to connect progress to Oracle Db through Dataserver OE client ;10.2b on Win 7 oracle : 11 on Linux. steps followed: --------------- 1) created empty DB on Progress 2) created a schema holder now when progress tries to connect to oracle DB, it comes back with error : "error...
  4. R

    Question Asynch Com Event

    Hello: (I had posted my queries on PSDN, so far no response and trying my luck here ) OE version : 10.2B http://knowledgebase.progress.com/articles/Article/P12604?q=process+events&l=en_US&fs=Search&pn=13 Per above KB, async com events are handled during waiting for user inputs , alert message...
  5. R

    Application freezes or slows down

    -B was set up to have a large buffer pool. It was not arrived based on any specific process. We will definitely review the Mi/Ma/Mn parameters. We dont require SQL access at this point of time.So we will start with only 4GL brokers. -spin 60000 or 100000 -- both are probably too high. This...
  6. R

    Application freezes or slows down

    DB startup param and client start up below [2012/05/20@04:45:28.039-0400] P-20325 T-1 I BROKER 0: (333) Multi-user session begin. [2012/05/20@04:45:28.064-0400] P-20325 T-1 I BROKER 0: (15321) Before Image Log Initialization at block 0 offset 0...
  7. R

    Application freezes or slows down

    Rob: just so that I dont mess up again. Should I use code tag as below Code: paste content here ......... ....... code:
  8. R

    Application freezes or slows down

    During blocked session, whatever we saw it was 'Rec' wait. They didnt last the refresh interval of 2 sec. latch waits - Unfortunately we didnt monitor or record the latch wait (I am assuming this is the latch activity from 'Protop' and not 'Semaphore Latch waits' as in Promon) Until this point...
  9. R

    Application freezes or slows down

    Sorry about that. I'll use it next time if i have to paste something like this.
  10. R

    Application freezes or slows down

    Tom: Cluster size of both DBs (we have 2 DB) are set to 64 MB each. Below i've pasted the checkpoint history from Promon logged around issue time. Checkpoint '2054' stands out from rest with 'len' column showing 1733 sec. Actually, I was going to write this earlier but we were reported with the...
  11. R

    Application freezes or slows down

    Hello: ********** OE 10.2B05 Database on Solaris Clients accessing application over Citrix ********** Users of our progress application intermittently complain that the application freezes (no response at all) or responds slowly (eg:delayed movement b/n screens, delayed data population on the...
  12. R

    Promon R&D - Processes/Clients status option

    Tom /Rob : Thanks for responding.
  13. R

    Promon R&D - Processes/Clients status option

    Hello All: I have one query about Promon option output. While reading from Promon R&D option -> Processes/Clients status , we can see values in 'Wait' column as '- -' but Column 'Wait Info' displays numerical values. so my query is what does value in 'wait Info' column indicate while 'Wait'...
  14. R

    Web Service call from OpenEdge

    Hi All: OpenEdge 10.2B we are encountering an issue with web service call from OE. The respone contains a soap-fault error with the string 'duplicate default namespace declaration'. when soap spy is enabled from proenv below message is being shown Attribute "xmlns" bound to namepsace...
  15. R

    Webspeed connection issue?

    Hello: openedge 10.2B Apache server webspeed Broker on Linux. we have observed sometimes, the requests made from the webserver to webspeed is not returning anything. This happens intermittently. (around 200 requests fails out of 50,000 http requests), There are no errors or any log message...
  16. R

    Merging Two DB into one DB

    Thanks Tom and CJ Brandt for responding.
  17. R

    Merging Two DB into one DB

    Hi: we have 2 database Db1 - 300+ GB (around 400 tables) DB2 - 500+ GB (around 350 tables) progress 9.1E (will upgrade to OE in couple of months) Database on solaris maximum users (at peak time) : around 800 My query is - if we were to combine both database into one DB, will it affect DB...
  18. R

    Database field encryption and Decryption

    Thanks Tom. I had originally tried the code which is in KB P11878. In your example, the key is being generated with PBE. In the KB it is through 'Generate-random-key' Using both the options, I can encrypt and decrypt succcessfully within OE sessions. But still not able to do if I try to do with...
  19. R

    Database field encryption and Decryption

    Tom / Thomas - Thanks for your feedback. couldnt revert earlier, sorry about that. we have decided to try encryption/decryption with OE. I am able to encrypt /decrypt within OE but when I export the encrypted content (into a file) and try to decrypt using Pl/sql or java, it is failing. Details...
  20. R

    Database field encryption and Decryption

    Hello Folks: I have few question on database field level encryption and decryption. Those of you who were using (or currently using) progress 9.x version, did you have a scenario where you store sensitive information (say SSN) value as encrypted in database but should be available for...
Top