Recent content by Jack@dba

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...