469,267 Members | 1,113 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

NEWLOGPATH and folder NODE000

Hello,

In DB2 UDB 9.1 and AIX 5.3, I want to have the logs for a database in
this folder:

/db2/logs/db1

For that we use:

db2 update db cfg for db1 using NEWLOGPATH using /db2/logs/db1

In the db2iag we can see the message that the path was successfuly
changed. After that we deactivate the db and reactive again.

The problem is that the folder is used but DB2 automaticly add the
folder NODE0000 under /db2/logs/db1.

Does anyone know how to prevent DB2 to create this NODE0000 folder an
leave the logs directly under /db2/logs/db1 ?

For information:
- Database logged LOGRETAIN RECOVERY
- Methode Archivagin LOGARCHMETH TSM
- FAILARCHPATH /db2/lostlogs
- USEREXIT OFF

Thanks in advance for your help
Sep 17 '08 #1
3 6893
Ian
jf****@gmail.com wrote:
Hello,

In DB2 UDB 9.1 and AIX 5.3, I want to have the logs for a database in
this folder:

/db2/logs/db1

For that we use:

db2 update db cfg for db1 using NEWLOGPATH using /db2/logs/db1

In the db2iag we can see the message that the path was successfuly
changed. After that we deactivate the db and reactive again.

The problem is that the folder is used but DB2 automaticly add the
folder NODE0000 under /db2/logs/db1.

Does anyone know how to prevent DB2 to create this NODE0000 folder an
leave the logs directly under /db2/logs/db1 ?
Unfortunately this is the way that DB2 works. I agree that it's
annoying.

The only way that I know that you can avoid this is by doing a restore,
and setting NEWLOGPATH in the restore command. You *might* also be able
to do it with db2relocatedb, but I'm not sure about that.


Sep 18 '08 #2
Does anyone know how to prevent DB2 to create this NODE0000 folder an
leave the logs directly under /db2/logs/db1 ?
I believe that even if you found a fix, that wouldn't do any good
because DB2 itself or some tool would assume that they are below
NODE0000/C000...../....

What about symlinks, would that help you?
Sep 18 '08 #3
I can only say: Hands off from symlinks inside DB2s internal
directories!
We went into quite a "nice" mess when doing this with tablespace
containers (SMS),
because DB2 internally resolved the "real" path, not the given one
with a symlink.
One thing was, the path with the link was listed but internally the
one with the real path was used!
The DB went to "damaged" and it was quite a thrill to clean this up...

I suggest NOT to do this just because of a simple directory name/
level...
On Sep 18, 7:08*pm, w.l.fisc...@googlemail.com wrote:
Does anyone know how to prevent DB2 to create this NODE0000 folder an
leave the logs directly under /db2/logs/db1 ?

I believe that even if you found a fix, that wouldn't do any good
because DB2 itself or some tool would assume that they are below
NODE0000/C000...../....

What about symlinks, would that help you?
Sep 24 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jeff | last post: by
reply views Thread by John H. | last post: by
4 posts views Thread by Dave Veeneman | last post: by
17 posts views Thread by rdemyan via AccessMonster.com | last post: by
24 posts views Thread by biganthony via AccessMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.