Recent content by DBA_learner

  1. D

    OER D/L

    Hello Cringer, database size is around 800 GB. Hello Tom, thanks for your reply. I meant by, type-1 to type-2 storage area during this dump/load. Regards,
  2. D

    OER D/L

    Hello Cringer, thanks for your reply. Yes, OER breaks during this activity and we will recreate it once all done. Please give your views on above approach. Regards,
  3. D

    OER D/L

    Hello All, Can we do dump and load on OER server and later-on apply the same on live server, below activities are for the same: Dump and load database on OER server (including type conversion). Stop Live DB after dump/load completed and apply all live ai (al-roll forward) files on OER server...
  4. D

    How Many APW’s

    Thanks Tom and Cringer all for this information. Thanks Rob for the clarification and shared slides, it helped. Regards,
  5. D

    How Many APW’s

    Dear All, How many APW’s we should have with a database? Our database size is around 800GB and currently we have 12 APW’s running. As per below Promon activities, writes by APW seems fine but rest values should be lower (I think). Writes by APW 99 % Buffs Flushed...
  6. D

    Error 1124/4229

    Hello Cringer, Below is the required detail: (1124) SYSTEM ERROR: Wrong dbkey in block. Found 0, should be 80128 in area 6. (4229) Corrupt block detected when reading from database. Regards,
  7. D

    Error 1124/4229

    Hello All, We have been getting error 1124 and 4229 in the database logs and sometimes client got this error when running the application (QAD menu option). After facing of this issue, database won’t shut down and everything works fine. Backup of this database is also fine (we restored this...
  8. D

    Error 1124/4229

    Hello All, We have been getting error 1124 and 4229 in the database logs and sometimes client got this error when running the application (QAD menu option). After facing of this issue, database won’t shut down and everything works fine. Backup of this database is also fine (we restored this...
  9. D

    Appserver Hangs

    Hello RealHeavyDude, thanks for your reply!!! Database log entries are not relating with Appserver logs. Could to please give your supervision on how Appserver trimming works with these kind of issues because we didn't face this issue again since we have applied Appserver trimming. Regards
  10. D

    Appserver Hangs

    Hello All, Users were facing error 3244 very frequently (3-4 times in two weeks) when opening .NET UI and were not even able to see menu structure after clicking this error message. Below are the error messages that we found in Appserver Logs: P-094746 T-2959914784 1 AS -- Failed to create...
  11. D

    -n Exceeded

    Thanks for your inputs Rob Fitzpatrick AND Cecil..
  12. D

    -n Exceeded

    Hello All, We have one cron job running in every 15-20 seconds and this cron is setup/associated via qad menu..each time this cron runs it calls a .p program...but here whenever this cron runs, it increases number of user sessions and exceeded -n. I think, every time cron runs will open the...
  13. D

    Question Bi Hwm/logical Size

    Thanks for this prompt response RHD!!! So here, number of BI clusters in use will be 54376 – 54376 + 1, will be 1. BI size in use = 1 * 16384 kb (cluster size)= 16384 KB (actual Bi size). Is this correct? Regards
  14. D

    Question Bi Hwm/logical Size

    Hello @RealHeavyDude, Thanks for your reply! There is one active transaction from last one and half hour and one transaction that I have initiated. Oldest _Trans-Counter (from _trans table) is 54376 and new transaction number that is linked with my transaction (_Trans._Trans-UsrNum =...
  15. D

    Question Bi Hwm/logical Size

    Hello @Rob Fitzpatrick Thanks for your reply!!! I tried this query but its value seems same as physical file value. Its output is 7,696 where physical file size is also 7.6 GB. Kindly suggest. Regards,
Top