0

Assuming that there are only two available paths, say /log and /data. Would it be better to set DBPATH to /log or /data. I.e.

CREATE DATABASE WHATEVER  
AUTOMATIC STORAGE YES
ON /data DBPATH ON /log;
UPDATE DB CFG WHATEVER USING newlogpath /log;

or

CREATE DATABASE WHATEVER  
AUTOMATIC STORAGE YES
ON /data DBPATH ON /data;
UPDATE DB CFG WHATEVER USING newlogpath /log;

I noticed the other day a system that used /data for both DBPATH and tablespace storage, and I'm wondering whether /log would have been a better choice for DBPATH?

Any thoughts?

1

It almost certainly doesn't really matter.

The only significant I/O going to files in the database path would be to the recovery history file (and even that isn't much).

Considering that DB2 uses the first storage path by default if you do not specify DBPATH ON, I would put it on /data if that was the only choice.

My SOP is to keep DBPATH in the instance owner home directory. This is obviously another important location and perhaps makes more sense than the other two locations.

  • Thanks, I've seen recommendations on separating DBPATH and tablespaces, but I assume this has more to do with DBPATH holding the transaction logs by default (as pointed out by @mustaccio in a now removed answer). – Lennart Sep 12 '16 at 18:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.