enable housekeepr GC

[former_member207908]

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

[former_member187136 · Accepted solution]

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

[former_member188883]

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