Search results

Rob- To answers to your questions. What causes a filled AI extent to be copied to an archive directory and the original file marked as empty? Are you using the AI File Management Daemon (aiarchiver)? Yes we are using AI archiver with on-demand mode only archive once Ai file Fills up and switch...

Hi Tom - I have found in target database is matching with Source last Ai extent which archived. The last block received at: Tue Mar 14 10:39:14 2023 Activity information: Blocks received: 45588157 Blocks processed...

Hi Tom Thanks for the details. To answer to your question Aside from that - why on earth do you have 243 after-image extents on the target? That is an unheard of a number of after-image extents. Please explain why that is. This set up is suggested by the progress vendor long back 3 years...

HI ALL, I would like to know whether our Replication database DR is Sync with Production. In Source database last Ai extents archived is mfgprod.a27. But in DR target database last Ai file copied is mfgprod.a243. Whenever we check replication status showing "normal processing" and Blocks...

Thanks Tom for your response initially we used to have two targets due to some reasons they made to 1.

HI All, Gud mng... Progress database version 11.7.4. OS is AIX 7.1. We have 2 servers Prod and DR with Open edge replication plus enabled. Source DB size db1 is 800gb db2 is 50gb db3 is 15gb db4 is 10gb. Target DB size db1 is 800gb db2 is 50gb db3 is 15gb db4 is 10gb Activity : Management...

HI All, Is there any sql query where we can set password as never expiry for SQl user id. Progress version : 9.1e OS version : Aix 5.3

Thanks Rob. Can i set -Mpb parameter to 50, so 50 ports can be used and i will reduce maxport and minport to 13000 to 13500.

Thanks Rob. Please find attached screenshot for the error we received during application connection and also i have attached promon report for issue first occurrence and last one. Error in Database : prdslc =================================== 23:18:59 SRV 18: Connection timed out on...

Thanks Rob.. Application team contacted QAD vendor and they suggested us to enlarge ports and to add max/min port for SQl Broker also. we are going to implement the same after Change freeze window in next week. Once again we faced application connectivity and found below findings on our...

Please let us know what exactly it is causing this error users are facing error again.

HI Tom, we have only SQL broker for connecting SQL connections. prdslc.pf file -B 70000 # Number of (8K) Blocks in database buffer -bibufs 200 # Number of before-image buffers -aibufs 300 # Number of after-image buffers #-Mi 2 # Min processes on a client server -Ma 15 # Max number of REMOTE...

proserve /progdata/prd/slcdb1/prdslc -m3 -Mi 3 -Ma 5 -Mn 4 -Mpb 4 -S prdslcoi -ServerType SQL proserve /progdata/prd/slcbard1/prdslcb -m3 -Mi 3 -Ma 5 -Mn 4 -Mpb 4 -S prdslcboi -ServerType SQL

-B 70000 # Number of (8K) Blocks in database buffer -bibufs 200 # Number of before-image buffers -aibufs 300 # Number of after-image buffers #-Mi 2 # Min processes on a client server -Ma 15 # Max number of...

HI All, Today we received below application connectivity error. Broker : Could not spawn a server. (1890). For 5 mins users are able to connect to application after few mins they facing the same. Can i know reason during which situation we will face this error.Please provide your inputs. I...

Thanks Rob for your suggestion will do the same..:)

Thanks Rob.. Error we are receiving on below highlighted filed. Before doing it we will test in test server. Please suggest what value we can define and also can we do it when users using this table.

HI Rob, thanks for information.. i'm able to generate your query and it helped me alot. After that we have provided access for below table but when we run below select command it showing an error. As per progress knowledge base it stating "to avoid errors from data in a field exceeding its SQL...

HI Team, We have Progress Database which is running on 9.1e version. Today we have received incident where user dont have access to vo_mstr table while they are connecting from SQL explorer tool they facing "Access Denied error". We checked using below command they dont have access to table and...

We don't have vendor supportand also we checked with vendor they are out of support for 9.1e version. Can I reboot the server to fix this issue