setFilePath

The setFilePath command enables you to set the path of all database files or selected files specified in the optional [file-list] argument so that you can relocate files.

When setting file paths, existing *.dat files and dependent files are moved to the specified path.

As the setFilePath action is not audited, it is not replayable.

The syntax of the setFilePath command in the jdbutilb command line is as follows.

jdbutilb path=database-path
         ini=initialization-file-name
         setFilePath
         fileDir=directory
         [file-list]

The following example shows the use of the setFilePath command in the jdbutilb command line when a secondary system has had more disk added so some files of employee data are moved to a new drive.

jdbutilb path=e:\ProdB\system ini=e:\ProdB\jade.ini setFilePath fileDir=f:\ProdB\system emp*

In the following example, a production system file is moved to a new drive, using the unaudited command, so that it is not redone in roll-forward recovery.

jdbutilb path=e:\ProdA\system ini=e:\ProdA\jade.ini setFilePath fileDir=f:\ProdA\system AcctHist