IBM Support

75 ways to demystify DB2 #58: Techtip : SQL5099 RC 9 while updating logpath or mirror logpath

Technical Blog Post


Abstract

75 ways to demystify DB2 #58: Techtip : SQL5099 RC 9 while updating logpath or mirror logpath

Body

Hello!

 

On Windows, updating logpath or mirror logpath with path pointing to a mapped drive letter for a network drive may return SQL5099 RC 9.

 

C:\Program Files\IBM\SQLLIB\BIN>db2 update db cfg for sample using mirrorlogpath  "U:\pmrs\03298.082.000"
 

SQL5099N  The value "U:\pmrs\03298.082.000" indicated by the database configuration parameter "MIRRORLOGPATH" is not valid, reason code "9".
SQLSTATE=08004

 

Here U:\pmrs\ is mapped driver letter for my network drive:

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You can find more information about SQL5099 here.

RC 9 indicates:

              9      The path cannot be accessed.

 

DB2 is not able to access the path, because it is not able to decipher the drive letter.

Drive letter mapping on Windows is not visible in all processes running on the box, this can lead to the error SQL5099N RC9.
Instead of using drive letter, one can use UNC path and overcome this error. If you still run into problems with this the access rights to the network path need to be reviewed.

Here is a good Microsoft article explaining this.

 

In my example, I changed the drive letter to UNC path and it worked:

 

C:\Program Files\IBM\SQLLIB\BIN>db2 update db cfg for sample using mirrorlogpath "\\xyz.abc.com\tlbgsa\projects\d\dbtpmrs\pmrs\03298.082.000"


DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W  One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, the
database must be shutdown and reactivated before the configuration parameter changes become effective.

 

Please let me know if you have any questions on this.

 

Thanks,

-Swati Thorve

 

 

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11140946