Replication command-line interface error

Edit online

If you have a master server that is configured to do replication, you might see a command-line interface error. This error occurs only on Windows™ operating systems. Follow the steps to resolve this error.

You might see an error like the following error in the ibmslapd error log during updates:

[IBM][CLI Driver] CLI0157E Error opening a file. SQLSTATE=S1507

This problem can be resolved by adding the following entry to the \sqllib\db2cli.ini file:

[COMMON]
TempDir=x:\your directory

where x:\your directory specifies an existing directory on a drive that has space available. DB2® writes temporary files to this directory. The amount of space that is required depends on the size of the directory entries you are adding or updating. Generally, more space is required than the size of the largest entry you are updating.