Recent content by Jack@dba

  1. J

    Never expiry Password for SQL user id

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    BROKER: Could not spawn a server. (1890)

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

    Table access

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

    Table access

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

    Table access

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

    Table access

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

    QUICK Help : Shared memory utilization

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

    QUICK Help : Shared memory utilization

    Database went down and quckily restated database. I found in 9.1e doc during this issue we need to release shared segment to free up the memory using ipcrm -m id
Top