H2 DB2 Password with $$ Causes Job to Fail Web Viewer 14.0

Products

• Output Management Web Viewer

Issue/Introduction

When following the instructions for how to migrate an h2 db for PTF's LU08230 and LU08231 the migrate db job in step 7 is failing due to an issue where the passed in h2 db password is being overwritten.

The password ends in two dollar signs which are being substituted for a numeric value.

Environment

Release : 14.0

Web Viewer

DVWEB

Cause

The shell script is interpreting the $$ in the password when setting the H2DBPASS variable. NOTE: in a shell script $$ resolves to the current process id.

Resolution

To prevent the $$ from being interpreted, escape the $ characters using the backslash “\” in CAHVVARS.

For example, if the password is password$$ then in CAHVVARS, code:

//             H2DBPASS='password\$\$',