Hi everyone,

I'm trying to migrate DB2 from V8 to V9. When i'm executing the db2ckmig command i'm getting the following error message:

Cannot open log file

here is the command i'm trying to run
i'm in the directory with V9: db2ckmig <dbname> -l db2ckmig.log

Thanks in advance

What OS are you using? Do you have permissions to write the file you specify with the l parameter?

Andy

Linux on Z and i don't think i have permission to write to the file. How would i grant permission to the file?

Your system admin should do it. You need root privileges to grant the permission.

Andy

Sorry i'm still new to this. I have root privileges so how do i grant access to the file tho? Doesn't the log file get created when i run the command? All i need the file for is to write any error messages to.

As root, you need to give the user write privileges to the directory that the file will be created in. Go one directory above this directory and use either chmod or chown to grant the rights.

for example for the directory /db/log/:
cd /db
chown db2inst1:db2grp1 log

Andy

Ok i did that and it worked but when i run the db2ckmig command again it's still giving the error message:

Cannot open log file

Try to specify an absolute pathname and also try writing the log file to the /tmp/ directory. On a properly configured system, every user can create new files under /tmp/ and write to those files.

As an explanation: relative path names are always relative to the directory which the program considers as the current directory. Since each program can switch the current directory, you have no clue whatsoever what the current directory is and where a relative path name actually points to (unless your program documents what it does). I have seen that some DB2 programs switch the current directory to the root directory. And since your DB2 instance owner should not be allowed to write to "/db2ckmig.log", the error may occur. (I'm not sure if this is the problem in your case, though.)