Skip to Content

enable housekeepr GC

Hi Experts,

As per SAP's 'optimizing performance with SAP Sybase ASE' document released in Oct 2013 by Chris Baker enable,

housekeepr GC should be 5 for OLTP and 4 for batches (OLAP i think)

My current environment (ASE 15.7SP122 on AIX 7.1) is combination of OLTP and OLAP and the configured value is "5" .

Let me know if you think it is wrong and should try something else...

Regards,

Rajesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 07:00 AM

    Rajesh,

    As I already said all those recommended parameters are not completely true, this decision depends on your database and the type of the database.

    We DBAs are the whole and sole owners of all the parameters and values which we set 😊

    Taking an example our saptools database should be 1-3 GB but we are extending when we receive 1105 Error 🤪 similarly we are the responsable for our database which is our BABY 🤪

    Coming to your question:

    Option 5: is for aggressive garbage collection for the House Keeping, if your database has delete operations for concurrent operations, definitely go for 5, because it is very cost effective 😊

    Option 4 is more or less for the batch deletion on the DOL tables 😊 not much recommended for the normal delete because it is too costly 😉

    Regards

    Kiran Kumar A

    SAP

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02, 2015 at 02:26 PM

    Hi Rajesh,

    As per SAP note 1749935 - SYB: Configuration Guide for SAP ASE 15.7

    housekeeper  GC should have value >0.

    A value of "5" is what is recommended in the SAP note.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded